
SQL Database Engineer
Job description
Anovia (formerly Innovatia Technical Services) is an industry-leading technology outsourcing support provider with expertise in the telecommunications industry. Operating for over 20 years, we specialize in workflow and knowledge processes, as well as technical support, helpdesk and multilingual support services. With over 200 professional experts across the globe, we service some of the world’s most successful Fortune 500 and Fortune 1000 companies. 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.
Responsibilities
- Extract, transform, and validate patient clinical data from EMR/EHR systems using HL7 v2.x, CCDA, and FHIR bundles.
- Interpret HL7 segments (PID, PV1, ORC, OBR, OBX, DG1, RXA, etc.) for clinical measure mapping.
- 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.
- 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 prior to client submission.
Technical Standards, Architecture Alignment & Governance
- Maintain and enforce engineering implementation standards, documentation requirements, and build methodologies.
- Ensure all engineering work aligns with defined solution architecture, technology standards, and security baselines.
- Lead efforts to improve standard configurations, automation, templates, and reusable frameworks.
- Ensure engineering quality and consistency through audits, peer reviews, and structured validation.
Data Pipeline Engineering & Transformation
- Build scalable ingestion pipelines using SQL, Spark (batch & streaming), Python, Databricks, EMR, or OCI Data Flow.
- Develop metadata-driven pipelines supporting multiple clients and EMR platforms.
- Implement data quality frameworks (DQ checks, thresholds, reconciliation reports).
- Maintain robust lineage, audit trails, and governance compliance for CMS readiness.
Regulatory Data Support for MIPS & Value-Based Care
- Support MIPS Advisors with extraction of 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, identifying gaps or vendor remediation needs.
- Validate that clients meet annual CMS submission timelines and data completeness requirements.
Cross-Functional Collaboration
- Translate technical data issues into actionable insights for non-technical MIPS Advisors.
- Coordinate with EMR vendors to resolve data extraction failures or schema changes.
Skills required
- Healthcare Data Domain Expertise.
- HL7 Parsing & Clinical Data Interpretation.
- SQL / ETL Engineering Excellence.
- Analytical & Critical Thinking Skills.
- Communication & Cross-Functional Collaboration.
- Quality Assurance & Data Governance.
- Cloud Engineering & Modern Data Stack Proficiency.
- Diligence & Regulatory Mindset.
Qualifications
- 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.
Benefits at Anovia
- Comprehensive Health Insurance policy.
- Employee Wellness Program with focus on mental health.
- Robust reward and recognition programs.
- Company incentive programs offered.
- Attractive leave policy: Holiday Leave, Maternity Leave, Paternity Leave, Birthday leave, Bereavement Leave and 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.
We thank all candidates for their interest; however, only those selected for an interview will be contacted. Anovia is an equal opportunity employer.
Job details
- Published
- October 23, 2026
- Last checked
- November 17, 2026
- Job source
- breezy
- Workplace
- Remote · Bengaluru, IN
- First seen
- October 23, 2026
LiftmyCV exclusive data
Anovia hiring intelligence
Anovia currently has 10 active jobs tracked by LiftmyCV. 2 new jobs in the past 7 days.
Verified November 17, 2026
Active openings
10
Currently tracked by LiftmyCV
New in 7 days
2
10 new jobs in the past 30 days
Published salaries
—
Not published by this employer yet
Average opening age
17 days
Across 10 active openings
Workplace breakdown
Hiring countries
Top hiring cities
Most in-demand roles
- • Avaya Aura Security Remediation Consultant
- • DEX-Nexthink Support Engineer
- • Fortinet Network Security Consultant
- • Help Desk Engineer
- • Infrastructure Specialist – System Administration L2
- • L2 NOC Network Engineer
Frequently requested skills
As of November 17, 2026
Hiring insights calculated from active jobs tracked by LiftmyCV.
See how well you match this job
Log in or sign up and Eva will compare your profile with this role, explain your strengths and show what to improve.
Sign up to see your matchAlready have an account? Log inMore at Anovia
Similar jobs from this company
- Infrastructure Specialist, System AdministrationAnoviaBengaluru, INOn-site
- Avaya Aura Security Remediation ConsultantAnoviaCARemote
- Fortinet Network Security Consultant (Independent Contractor)AnoviaVA, USOn-site
- Project EngineerAnoviaINRemote
- Help Desk EngineerAnoviaIndia, USRemote
- DEX-Nexthink Support EngineerAnoviaINRemote
Across the market
Similar jobs from other companies
Third-party content disclaimer
Full job descriptions are sourced directly from third-party applicant tracking systems (ATS), job boards, recruitment platforms, and employer career pages.
LiftmyCV does not claim ownership of this content or guarantee its accuracy or current availability. All original content is the intellectual property of the respective employers or other rights holders.
LiftmyCV hiring intelligence, availability checks, and related-job recommendations are generated from LiftmyCV data and public sources.
If you prefer, you may apply directly via the original listing for transparency.