Exasol Data Engineer

Quoris; United States; On-site; USD 120,000 - 170,000; Full time

Benefits offered by this job

Health, Dental, Vision, 401k

Job summary

Quoris is seeking an Exasol Data Engineer to support a healthcare analytics engagement with deep SQL engineering, healthcare data structures, and value-based care programs. The role involves building, optimizing, and validating data pipelines in an Exasol environment.

You will reconcile extracts with medical records, apply LOINC, ICD-10-CM/PCS, CPT, SNOMED CT, and RxNorm terminology, and deliver repeatable, well-documented solutions while working remotely in a contract through year-end.

Qualifications

• 5+ years of SQL data engineering with healthcare analytics experience.
• Expert SQL with set-based logic, window functions, and tuning.
• Experience extracting/staging from SQL Server via JDBC.
• Chart validation with medical records and SMEs.
• Knowledge of LOINC, ICD-10-CM/PCS, CPT, HCPCS, SNOMED CT, RxNorm.
• Understanding of quality measures and value sets (VSAC/NCQA).
• Dev best practices including version control, peer review, and repeatable deployment.
• U.S. work eligibility required.

Responsibilities

• Design, build, and optimize complex SQL queries on Exasol or similar platforms.
• Extract and stage data from SQL Server sources via JDBC.
• Perform chart validation against medical records with SMEs.
• Apply knowledge of healthcare terminologies (LOINC, ICD-10-CM/PCS, CPT, SNOMED).
• Support quality measure development for eligible populations and value sets.
• Leverage Exasol in-database compute, Python UDFs, and BucketFS.
• Work with claims data structures (837, 835, 834, CMS CCLF).
• Maintain disciplined engineering practices and repeatable deployment.

Skills

SQL data engineering

Advanced SQL

SQL Server extraction

Chart validation

Healthcare terminologies

Quality measures

Dev best practices

US work eligibility

Tools

Exasol

Snowflake

Redshift

Teradata

Vertica

Job description

• Duration: Contract (Through End of Year, Extension Possible)
• Daily Working Hours: Full-Time
• Travel: Remote
• Work authorization: Must be eligible to work in the U.S. without company sponsorship

This is a remote position.

Exasol Data Engineer

• Start Date: ASAP
• Duration: Contract (Through End of Year, Extension Possible)
• Daily Working Hours: Full-Time
• Travel: Remote
• Work authorization: Must be eligible to work in the U.S. without company sponsorship

Project Scope

We are seeking an Exasol Data Engineer to support a healthcare analytics engagement requiring deep SQL engineering expertise and hands-on experience with healthcare data structures, quality measures, and value-based care programs. This role will work within a complex data environment to build, optimize, and validate data pipelines that drive clinical and operational analytics outcomes.

Position Summary

The Exasol Data Engineer will serve as a senior technical resource responsible for SQL-based data engineering, chart validation, and healthcare analytics development within an Exasol environment. This individual will bring deep knowledge of healthcare terminologies, quality measure structures, and claims data to support accurate, repeatable, and well-documented data solutions. The ideal candidate is a disciplined engineer who can explain why a query is slow, fix it, and deliver reliable outputs that meet clinical and regulatory requirements.

Key Responsibilities

• Design, build, and optimize complex SQL queries using set-based logic, window functions, and query tuning techniques on Exasol or comparable MPP/columnar platforms.
• Extract and stage data from SQL Server sources including JDBC-based loads.
• Perform chart validation by reconciling extracts against medical records on sample patients and running correction loops with clinical or measure SMEs.
• Apply working knowledge of healthcare terminologies including LOINC, ICD-10-CM and PCS, CPT and HCPCS, SNOMED CT, and RxNorm.
• Support quality measure development across eligible populations, denominators, numerators, exclusions, and value sets including VSAC and NCQA.
• Leverage Exasol in-database compute capabilities including Python UDFs, script language containers, and BucketFS model artifacts.
• Work with claims data structures including 837, 835, 834, CMS CCLF, and member-month analytic grain.
• Support value-based care program analytics across MSSP, Medicare Advantage Stars, HEDIS, eCQMs, CQL, and HCC risk adjustment on CMS-HCC V28.
• Maintain disciplined engineering practices including version control, peer review, documented logic, and repeatable deployment processes.

Qualifications

• 5+ years of SQL data engineering experience with at least 2 years in healthcare provider or payer analytics.
• Deep, demonstrable SQL expertise including set-based logic, window functions, and query tuning on columnar or MPP platforms.
• Experience extracting and staging data from SQL Server sources including JDBC-based loads.
• Chart validation experience reconciling extracts against medical records and working correction loops with clinical SMEs.
• Working knowledge of healthcare terminologies including LOINC, ICD-10-CM/PCS, CPT, HCPCS, SNOMED CT, and RxNorm.
• Familiarity with quality measure structure including eligible population, denominator, numerator, exclusions, and value sets.
• Disciplined engineering practice including version control, peer review, documented logic, and repeatable deployment.
• Must be eligible to work in the U.S. without sponsorship.

Preferred Qualifications

• Direct Exasol experience strongly preferred; strong experience on Snowflake, Redshift, Teradata, or Vertica transfers well.
• Experience with Exasol in-database compute including Python UDFs and BucketFS model artifacts.
• Claims data experience across 837, 835, 834, CMS CCLF, and member-month analytic grain.
• VBC program knowledge across MSSP, Medicare Advantage Stars, HEDIS, eCQMs, CQL, and HCC risk adjustment on CMS-HCC V28.

Ideal Candidate Profile

• Senior data engineer who can independently diagnose and resolve complex SQL performance issues without being pointed in the right direction.
• Deep healthcare data professional who understands the clinical context behind the data, not just the technical structures.
• Disciplined and methodical, with a track record of clean, documented, and repeatable data engineering work.
• Comfortable operating in a fully remote environment with minimal oversight.
• Brings technical depth, accountability, and a delivery-focused mindset to every engagement.

• When working with Quoris as a consultant, you are eligible for competitive benefits including Health, Dental, Vision, 401k, and a great culture/working environment.