Data Engineer

**Data Engineer – Healthcare IT** CORMAC is seeking a Data Engineer to design, build, and operate the data integration and processing pipelines for the CMS Reporting and Quality division. This role works hands\-on in Databricks and AWS with Medicare claims data, patient assessment data, and provider demographic sources to produce validated claims\-based and hybrid quality measure outputs for confidential provider reports and public reporting. **Responsibilities:** * 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 **Basic Qualifications:** * Bachelor's degree in Computer Science, Information Technology, Statistics, Data Science, or a similar field * Must be a U.S. Citizen * Must be able to obtain a Public Trust (Tier I) Clearance * Minimum of 7\+ years of experience in data engineering, ETL/ELT development, or database development * Minimum of 3\+ years of hands\-on experience building and operating production data pipelines in Databricks using Spark (Scala and/or PySpark) and SQL * Advanced SQL skills and strong experience with PostgreSQL or another enterprise relational database, including stored procedures * Hands\-on experience with AWS data services such as S3, Glue, Lambda, and Redshift or RDS * Experience validating data and outputs, including automated testing of ETL/ELT pipelines and data quality checks * Experience working with large\-scale healthcare data and protecting sensitive PII and PHI in accordance with HIPAA * Strong communication skills with the ability to work in a cross\-functional Agile team **Preferred Qualifications:** * Master's degree in a relevant field * Databricks certification (for example Databricks Certified Data Engineer Associate or Professional) * Experience with Medicare and Medicaid claims data and CMS data assets * Experience with CMS quality measure calculation, risk adjustment, and CMS quality reporting programs * Experience with SAS and R, and with Snowflake * Experience with provider data sources and provider identifier resolution (CCN, NPI) * Experience with Amazon EMR and Redshift Spectrum * Experience with HL7/FHIR data standards * Experience producing public reporting files **Why CORMAC?** At CORMAC, we leverage the power of Data Management and Analytics to enable our customers to achieve their strategic goals. With over 20 years of experience in Health Information Technology (HIT), human\-centered design principles and Agile development methodologies, CORMAC delivers complex digital solutions to solve some of the most challenging problems facing public healthcare programs today. As a US Federal Government contractor in the public healthcare sector, our work is impactful and cutting\-edge while being performed in a supportive, collaborative, and welcoming environment. We offer flexible work schedules with remote, hybrid, or fully in\-person workplace options to empower our employees to decide the workplace most suitable for them. At CORMAC, we have a highly diverse workforce, and believe the work environment is a place where creativity, collaboration, enthusiasm, and innovation happens, regardless of location. ***E\-Verify Participation/EEO*** *As an Equal Employment Opportunity employer, CORMAC provides equal employment opportunity to all employees and applicants without regard to an individual's protected status, including race/ethnicity, color, national origin, ancestry, religion, creed, age, gender, gender identity/expression, sexual orientation, marital status, parental status, including pregnancy, childbirth, or related conditions, disability, military service, veteran status, genetic information, or any other protected status.*