SQL Database Engineer

This is a fully remote position, open to applicants in India.

📋 Description

• Extract, transform, and validate clinical patient data from EMR/EHR systems utilizing HL7 v2.x, CCDA, and FHIR bundles.

• Analyze HL7 segments such as PID, PV1, ORC, OBR, OBX, DG1, and RXA for the purpose of clinical measure mapping.

• Address issues with inconsistent or malformed HL7 messages and rectify data quality discrepancies with vendors.

• Develop parsing logic to standardize data across diverse EMR systems.

• Execute queries on EMR databases including NextGen, eCW, Greenway, and Athena to extract both structured and unstructured clinical data necessary for MIPS measures.

• Comprehend vendor-specific table schemas, metadata dictionaries, and proprietary data models.

• Convert measure specifications into SQL logic in accordance with CMS MIPS calculation guidelines.

• Ensure measure completeness, timeliness, and accuracy prior to client submission.

• Uphold engineering implementation standards, documentation needs, and building methodologies.

• Align engineering efforts with solution architecture, technology standards, and security protocols.

• Enhance standard configurations, automation, templates, and reusable frameworks.

• Guarantee engineering quality through audits, peer reviews, and structured validation processes.

• Construct scalable ingestion pipelines using SQL, Spark, Python, Databricks, EMR, or OCI Data Flow.

• Create metadata-driven pipelines that support various clients and EMR platforms.

• Implement frameworks for data quality, establish thresholds, and generate reconciliation reports.

• Maintain data lineage, audit trails, and ensure governance compliance for CMS readiness.

• Assist MIPS Advisors with numerator/denominator data for clinical quality measures.

• Produce documentation that is ready for audits and ensures reproducible calculations for CMS submission.

• Map EHR data elements to CMS measure logic and identify gaps or areas needing vendor remediation.

• Validate client adherence to annual CMS submission deadlines and data completeness requirements.

• Translate technical data challenges into actionable insights for non-technical MIPS Advisors.

• Collaborate with EMR vendors to resolve issues regarding data extraction failures or schema alterations.

⛳️ Requirements

• Over 5 years of experience in data engineering, healthcare data extraction, or clinical informatics.

• In-depth knowledge of SQL, Python, and Spark (both batch and streaming) on Databricks, EMR, or DataFlow.

• Strong familiarity with HL7 v2.x, CCDA, FHIR, and EDI X12 (837/835).

• Demonstrated ability to query and interpret ambulatory EMR/EHR schemas (such as NextGen, eCW, Greenway, etc.).

• Hands-on experience optimizing Autonomous Data Warehouse, Snowflake, or Redshift.

• Experience with cloud platforms, including AWS, Azure, or OCI.

• Proficient in creating metadata-driven pipelines and implementing data lineage, auditability, and governance processes.

• Familiarity with Airflow or similar orchestration tools.

• Experience with Git, CI/CD, Terraform, and DataOps workflows.

• Ability to manage multiple deadlines and support regulatory timelines effectively.

• Bachelor’s degree in computer science, Information Systems, Health Informatics, or a related field.

• Experience with CMS eCQMs, MIPS/MACRA, ACO performance measures, or quality reporting initiatives.

• Knowledge of clinical terminology including SNOMED, LOINC, RxNorm, CPT/HCPCS, and ICD-10.

• Familiarity with Delta Lake / Lakehouse architectures.

• Previous work experience in a healthcare IT vendor, Managed Service Provider, EMR company, or consulting environment.

🏝️ Benefits

• Comprehensive Health Insurance policy.

• Employee Wellness Program focusing on mental health.

• Robust reward and recognition initiatives.

• Company incentive programs available.

• Holiday Leave.

• Maternity Leave.

• Paternity Leave.

• Birthday Leave.

• Bereavement Leave.

• Paid Leave for personal time off.

• Abundant opportunities for growth and learning.

• Options for remote work.

• Emphasis on work/life balance.

• Immigration Program available for eligible employees to support immigration to Canada.