SQL Database Engineer
RemoteFull-time5–9 yrsPosted yesterday
Senior software engineering role at Anovia. Needs 5+ years and a B.Tech, B.E. or B.Sc. Remote.
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
- SQL
- Python
- Git
- AWS
- ETL
- Spark
Good to have
- Databricks
- Data warehousing
- CI/CD
- Medical coding
- Snowflake
- Redshift