SQL Database Engineer

About the role

The SQL Database Engineer II is responsible for extracting, transforming, and validating clinical and administrative data from ambulatory EHR/EMR systems to support CMS MIPS and Value-Based Care reporting. The role requires strong expertise in SQL, HL7, CCDA, FHIR, EDI 837/835, EMR database schemas, and data pipeline engineering to ensure accurate, secure, and audit-ready regulatory submissions.

What you'll do

• Extract, transform, and validate patient clinical data from EMR/EHR systems using HL7 v2.x, CCDA, and FHIR bundles
• Troubleshoot inconsistent or malformed HL7 messages and resolve data quality gaps with vendors
• Build robust parsing logic to normalize data across heterogeneous EMR systems
• EMR/EHR Database Querying & Measure Data Retrieval
• Query EMR databases (NextGen, eCW, Greenway, Athena, etc.) to extract structured and unstructured clinical data required for MIPS measures

What you need

• 5–9 yrs of experience
• SQL
• Python
• Git
• AWS
• ETL
• Spark
• B.Tech or B.E. or B.Sc or BCA

Good to have

• Databricks
• Data warehousing
• CI/CD
• Medical coding
• Snowflake
• Redshift