SQL Database Engineer

• Extract, transform, and validate patient clinical data from EMR/EHR systems using HL7 v2.x, CCDA, and FHIR bundles
• Interpret HL7 segments including PID, PV1, ORC, OBR, OBX, DG1, and RXA for clinical measure mapping
• Troubleshoot inconsistent or malformed HL7 messages and resolve data quality gaps with vendors
• Build parsing logic to normalize data across heterogeneous EMR systems
• Query EMR databases such as NextGen, eCW, Greenway, and Athena to extract structured and unstructured clinical data required for MIPS measures
• Understand vendor-specific table schemas, metadata dictionaries, and proprietary data models
• Translate measure specifications into SQL logic based on CMS MIPS calculation rules
• Validate measure completeness, timeliness, and accuracy before client submission
• Maintain engineering implementation standards, documentation requirements, and build methodologies
• Align engineering work with solution architecture, technology standards, and security baselines
• Improve standard configurations, automation, templates, and reusable frameworks
• Ensure engineering quality through audits, peer reviews, and structured validation
• Build scalable ingestion pipelines using SQL, Spark, Python, Databricks, EMR, or OCI Data Flow
• Develop metadata-driven pipelines supporting multiple clients and EMR platforms
• Implement data quality frameworks, thresholds, and reconciliation reports
• Maintain data lineage, audit trails, and governance compliance for CMS readiness
• Support MIPS Advisors with numerator/denominator data for clinical quality measures
• Produce audit-ready documentation and reproducible calculations for CMS submission
• Map EHR data elements to CMS measure logic and identify gaps or vendor remediation needs
• Validate client compliance with annual CMS submission timelines and data completeness requirements
• Translate technical data issues into actionable insights for non-technical MIPS Advisors
• Coordinate with EMR vendors to resolve data extraction failures or schema changes

• 5+ years in data engineering, healthcare data extraction, or clinical informatics
• Deep expertise with SQL, Python, Spark (batch + streaming) on Databricks, EMR, or DataFlow
• Strong experience with HL7 v2.x, CCDA, FHIR, EDI X12 (837/835)
• Proven ability to query and interpret ambulatory EMR/EHR schemas (NextGen, eCW, Greenway, etc.)
• Hands-on optimization experience with Autonomous Data Warehouse, Snowflake, or Redshift
• Experience with cloud platforms (AWS, Azure, OCI)
• Skilled in building metadata-driven pipelines, implementing data lineage, auditability, and governance
• Experience with Airflow or similar orchestration tools
• Experience with Git, CI/CD, Terraform, DataOps workflows
• Ability to meet deadlines and multitask, manage multiple deadlines, and support regulatory timeframes
• Bachelor’s degree in computer science, Information Systems, Health Informatics, or related field
• Experience supporting CMS eCQMs, MIPS/MACRA, ACO performance measures, or quality reporting initiatives
• Familiarity with clinical terminology (SNOMED, LOINC, RxNorm, CPT/HCPCS, ICD-10)
• Experience with Delta Lake / Lakehouse architectures
• Previous experience in a healthcare IT vendor, MSP, EMR company, or consulting environment

• Comprehensive Health Insurance policy
• Employee Wellness Program with focus on mental health
• Robust reward and recognition programs
• Company incentive programs offered
• Holiday Leave
• Maternity Leave
• Paternity Leave
• Birthday leave
• Bereavement Leave
• Paid Leave for personal time off
• Ample growth and learning opportunities
• Remote work opportunities
• Focus on work/life balance
• Immigration Program supporting immigration to Canada for eligible employees