Remote Healthcare Data Engineer: Databricks on AWS

CORMAC; United States; Híbrido; USD 120 000 - 170 000; Tempo integral

Resumo da oferta

CORMAC seeks a Data Engineer to design, build, and operate data pipelines for CMS Reporting and Quality. You will work hands-on in Databricks and AWS with Medicare claims, patient assessment, and provider demographics to produce validated quality outputs for confidential provider reports and public reporting.

The role emphasizes scalable ETL/ELT development, data validation, and HIPAA-compliant handling of PII/PHI in a collaborative Agile environment.

Qualificações

• Bachelor's degree in Computer Science, Information Technology, Statistics, Data Science, or a similar field.

Responsabilidades

• Design, build, and maintain scalable data pipelines in Databricks (Spark with Scala and/or PySpark, and SQL) that ingest, integrate, validate, and transform Medicare claims, patient assessment, and provider demographic data
• Develop, schedule, and optimize Databricks jobs, notebooks, and workflows, and tune Spark performance and cluster cost for large-scale claims processing
• Process Medicare claims and encounter data, including claim types, variables, values, and final action record logic
• Implement claims-based and hybrid quality measure specifications, including risk adjustment and imputation, using Databricks, SQL, PL/pgSQL, PostgreSQL, Python, SAS, and R as appropriate
• Build and integrate pipelines with AWS services such as S3, Glue, Lambda, SQS, EventBridge, EMR, Redshift and Redshift Spectrum, and RDS for PostgreSQL
• Produce confidential provider-level quality measure feedback reports and public reporting files on weekly, monthly, and quarterly cycles
• Apply matching rules across provider identifiers such as internal system provider IDs, CCNs, and NPIs, and geographic indicators, to track provider demographic changes such as address, certification, and ownership changes
• Implement patient and resident ID assignment, assessment matching, episode and stay building, and de-duplication routines
• Implement automated data validation frameworks, ETL/ELT testing suites, and statistical anomaly detection to validate measure logic, stored procedures, and output schemas before release
• Support relational schema and virtual data mart design for multi-dimensional, longitudinal analysis, and ensure de-identification and data security requirements are met for PII and PHI
• Prepare data pipelines for HL7/FHIR and digital quality measure data standards by applying the same core ingestion and validation logic

Conhecimentos

Data engineering

ETL/ELT development

Healthcare data

PII/PHI protection

Communication

US citizenship

Public Trust clearance

Formação académica

Bachelor's degree in CS/IT/Stats/Data Science

Ferramentas

Databricks

Spark

SQL

PostgreSQL

S3

Glue

Lambda

Redshift

RDS

AWS

Descrição da oferta de emprego

CORMAC seeks a Data Engineer to design, build, and operate data pipelines for CMS Reporting and Quality. You will work hands-on in Databricks and AWS with Medicare claims, patient assessment, and provider demographics to produce validated quality outputs for confidential provider reports and public reporting.

The role emphasizes scalable ETL/ELT development, data validation, and HIPAA-compliant handling of PII/PHI in a collaborative Agile environment.