Senior Data Modeler

Your 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 Senior Data Analyst 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  Physical models and dB objects  for New & expanding existing  Subject areas related to health care.
• 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 implementation and physicalization is occurring. 
• You will be Constantly be working on the Schema Migration process to ensure timely delivery.  

What You Need 

• Ability to create Conceptual , Logical and Physical data models for New Subject areas related to health care
• Propose versatile solutions with the ability to understand and extend current Models with minimal supervision
• Solid Understanding and working knowledge of Healthcare Informatics specifically with HL7 FHIR (all levels)
• Previous Experience in translating various healthcare data and IG  into Entity Relationship models
• 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 Skill Sets 

• Strong Database knowledge and work experience in dealing with multi terabyte and high concurrent work loads
• 2+ years of 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