Senior Snowflake Data Engineer — Healthcare Claims

ProgenyHealth, LLC; United States; Remote; USD 140,000 - 190,000; Full time

Benefits offered by this job

Paid Time Off

401K with company match

Short‑and‑Long‑Term Disability

Group Life Insurance

Tuition Reimbursement

Pet Insurance

Professional development opportunities

Business Casual work environment

Job summary

ProgenyHealth, LLC is seeking a Senior Data Engineer to design, develop, and maintain our Snowflake-based Claims Data Warehouse fed by Azure services. You will implement medallion architecture, optimize performance, and ensure HIPAA-compliant data handling for professional, institutional, and pharmacy claims.

Responsibilities include building robust ETL/ELT pipelines with Snowpipe and Azure Data Factory, maintaining security with RBAC and data masking, and collaborating with claims, actuarial,

Qualifications

• Bachelor's degree in computer science, information technology, or a related field.
• 10+ years in data/DB engineering with healthcare focus and SQL/EDW experience.
• Hands-on Snowflake experience including Snowpipe, Streams/Tasks, Dynamic Tables, and secure sharing.
• Experience with medallion architecture (Bronze-Silver-Gold).
• Healthcare claims data expertise (header/line, adjustments, eligibility).
• X12 EDI knowledge (837, 835, 834, 270/271, 276/277) and CMS-1500/UB-04 forms.
• Healthcare code sets: ICD-10, CPT/HCPCS, DRG, NDC, place of service.
• ADF and Azure data services (ADLS Gen2, Key Vault, DevOps).
• SSIS and SQL Server experience; data modeling and slowly changing dimensions.
• BDR/BCDR, HIPAA, PHI/PII handling and security.
• Git-based version control and CI/CD (Azure DevOps).
• Strong communication, agile, and multi-project leadership.

Responsibilities

• Design, build, and optimize the Claims Data Warehouse in Snowflake (databases, schemas, tables, views, stages).
• Ingest data continuously via Snowpipe, COPY INTO, external stages, and Azure landing zones.
• Implement CDC, schema drift handling, and robust error-recovery in pipelines.
• Apply medallion architecture from raw to analytics-ready marts.
• Tune performance and cost via warehouses sizing, clustering, and materialized views.
• Enforce RBAC, masking, access policies, and secure data sharing for PHI/HIPAA.
• Use Time Travel, Fail‑safe, zero-copy cloning for backup and testing.
• Develop SQL and Snowpark/stored procedures for ETL/ELT of large claims data.
• Model claim header/line, adjudication status, adjustments, COB coordination.
• Map ICD codes and revenue codes to source systems; maintain reference data.
• Develop data products for utilization management, PMPM, risk adjustment, and BI reporting.
• Quality checks: data reconciliations, eligibility-to-claim matching.

Skills

Snowflake

Azure

SQL

ETL/ELT

Data Modeling

HIPAA

CI/CD

Snowflake Cortex

Education

Bachelor's degree in CS/IT

Tools

ADF

SSIS

Azure DevOps

ADLS Gen2

RBAC

Job description

ProgenyHealth, LLC is seeking a Senior Data Engineer to design, develop, and maintain our Snowflake-based Claims Data Warehouse fed by Azure services. You will implement medallion architecture, optimize performance, and ensure HIPAA-compliant data handling for professional, institutional, and pharmacy claims.

Responsibilities include building robust ETL/ELT pipelines with Snowpipe and Azure Data Factory, maintaining security with RBAC and data masking, and collaborating with claims, actuarial,