[Remote] Exasol Data Engineer

Note: The job is a remote job and is open to candidates in USA. Quoris is seeking an Exasol Data Engineer to support a healthcare analytics engagement requiring deep SQL engineering expertise. This role will focus on building, optimizing, and validating data pipelines to drive clinical and operational analytics outcomes.

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

Skills

• 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
• 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

Benefits

• Competitive benefits including Health, Dental, Vision, 401k, and a great culture/working environment

Company Overview