Data Architect

About the Role

The technology that once promised to simplify patient care has brought more issues than anyone ever anticipated. At Innovaccer, we defeat this beast by making full use of all the data Healthcare has worked so hard to collect, and replacing long-standing problems with ideal solutions. Data is our bread and butter for innovation. We are looking for a Data Architect for the BI sub-team within the analytics team who can help us build the next generation of dashboards, reports, and other analytics for our customers in the provider/payer market

A Day in the life

• Creating Logical/ physical models and dB objects for New & expanding existing Subject areas related to Supply Chain, Finance etc
• Create a link and Data Model Associations between health care and Other Domains such as SCM , FIN etc.
•  Working with various cross functional and technical teams .
• You will be dealing with extremely unique Innovaccer Proprietary Data Structures.
• You will face various challenges as you adapt data models and ensure engagement with the evolving data landscape.
• However you will have an amazing team to help and back you up.
• You will work very closely with development and SRE teams to ensure effective physicalization is occurring.
• You will be Constantly be working on the Schema Migration process to ensure timely delivery

What You Need

• Strong Understanding and working knowledge of Finance, SCM and HR .
• Solid Understanding and working knowledge of SAP Finance , SAP SCM , and HR modules SAP SAHL (SA Analytical Healthcare Library) , SAP clinical supply chain planning and operations .
• Understand Backend Schema , Data Dictionaries related to SAP SCM , SAP Financial Accounting .
• Ability to consult and integrate various data domains and associations for enhancing data models .
• Ability to create Conceptual , Logical and Physical data models for New Subject areas
• Propose versatile solutions with the ability to understand and extend current Models with minimal supervision
• Previous Experience in associating healthcare data with financial and supply chain data .
• Ability to solve unstructured big data problems and help team/s with peer review and triage processes
• Adhere and also recommend when needed to data governance and CI/CD best practices.
• Solid communication skills and analytical skills to communicate with product and project teams

Technical Skills

• Strong Database knowledge and work experience in dealing with SAP HANA Architecture and work loads.
• Experience related to MPP and/Or Columnar database platforms like Redshift , Azure , Snowflake etc
• 4 years of experience with traditional OLTP database platforms like Postgres ,MS SQL server etc
• Strong theoretical knowledge and practical exposure in creating and troubleshooting various database objects / techniques including but not limited to:
  ○ Define better indexing strategies
  ○ Create optimal database triggers
  ○ Work with stakeholders to come up with innovative UDF’s
  ○ Stored Procedures ,data partitioning
  ○ Strong Distribution , clustering key concepts related to MPP platforms etc...
  ○ Brainstorm Query profiling, break down query plans etc
  ○ Come up with optimal storage patterns and designs for LOB data structures
•  Previous experience in dealing with migration of high volume databases from traditional database platforms to modern columnar (MPP) platforms
• Exposure in working with multi tenant platforms
• Extensive experience in working with and advising data engineering teams related to high volume data ingestion and transformation pipelines