Exasol Data Engineer

Accountabilities

• Design, develop, and optimize complex SQL queries using set-based logic, window functions, and advanced query-tuning techniques within Exasol or comparable MPP and columnar database environments.
• Extract and stage data from SQL Server sources, including through JDBC-based data loads.
• Build, maintain, and validate data pipelines that support healthcare analytics, clinical reporting, and operational outcomes.
• Perform chart validation by reconciling data extracts against medical records for sample patients and coordinating correction cycles with clinical and quality-measure subject matter experts.
• Apply healthcare terminology knowledge to accurately interpret and engineer data involving LOINC, ICD-10-CM/PCS, CPT, HCPCS, SNOMED CT, and RxNorm.
• Support healthcare quality-measure development across eligible populations, denominators, numerators, exclusions, and value sets, including VSAC and NCQA requirements.
• Leverage Exasol in-database computing capabilities, including Python UDFs, script-language containers, and BucketFS model artifacts.
• Work with healthcare claims structures such as 837, 835, 834, CMS CCLF, and member-month analytic grain.
• Support value-based care analytics across MSSP, Medicare Advantage Stars, HEDIS, eCQMs, CQL, and HCC risk adjustment, including CMS-HCC V28.
• Investigate and resolve SQL performance issues, identifying the underlying causes of slow queries and implementing effective optimization strategies.
• Maintain disciplined engineering practices through version control, peer review, documented business and technical logic, and repeatable deployment processes.
• Collaborate with technical, clinical, and analytics stakeholders to ensure data solutions are accurate, reproducible, well documented, and aligned with project requirements.

Requirements

• 5+ years of professional SQL data engineering experience, including at least 2 years working with healthcare provider or payer analytics.
• Deep and demonstrable SQL expertise, including set-based logic, window functions, query optimization, and performance tuning.
• Experience working with columnar or MPP database platforms and the ability to independently diagnose complex SQL performance problems.
• Direct Exasol experience is strongly preferred; experience with Snowflake, Redshift, Teradata, Vertica, or similar platforms is highly transferable.
• Experience extracting and staging data from SQL Server environments, including JDBC-based loads.
• Hands-on experience with chart validation, including reconciling analytical extracts against medical records and managing correction cycles with clinical SMEs.
• Working knowledge of healthcare terminology and coding systems, including LOINC, ICD-10-CM/PCS, CPT, HCPCS, SNOMED CT, and RxNorm.
• Understanding of healthcare quality-measure structures, including eligible populations, denominators, numerators, exclusions, and value sets.
• Experience with healthcare claims data such as 837, 835, 834, CMS CCLF, and member-month analytical structures is preferred.
• Familiarity with value-based care programs, including MSSP, Medicare Advantage Stars, HEDIS, eCQMs, CQL, and HCC risk adjustment using CMS-HCC V28 is preferred.
• Experience with Exasol in-database compute capabilities, Python UDFs, script-language containers, or BucketFS model artifacts is an advantage.
• Strong engineering discipline, including version control, peer review, documentation, testing, and repeatable deployment practices.
• Ability to work independently, prioritize complex technical problems, and deliver high-quality results with minimal supervision.
• Strong analytical, troubleshooting, communication, and documentation skills.
• Must be eligible to work in the United States without company sponsorship.
• Ability to work effectively in a fully remote environment.

Benefits

• Competitive compensation for a senior contract data engineering engagement.
• Contract expected to run through the end of the year, with potential for extension.
• Full-time remote work arrangement.
• Health insurance benefits.
• Dental insurance benefits.
• Vision insurance benefits.
• 401(k) plan.
• Supportive and collaborative working environment.
• Opportunity to contribute to complex healthcare analytics and value-based care initiatives.
• Opportunity to work with advanced data engineering technologies and large-scale healthcare datasets.