Data Engineer

ProgenyHealth, LLC

. Design, build, and optimize the Claims Data Warehouse in Snowflake .

Posted 10/27/2026full-timeRemote • United StatesSeniorLeadWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in designing and optimizing Claims Data Warehouses using Snowflake, with a strong focus on SQL, data modeling, and healthcare data standards. Proficient in building and managing ETL/ELT pipelines, ensuring data quality, and implementing security and governance measures.

Highest-signal resume keywords

Snowflake Data Warehouse DesignSQL Query OptimizationHealthcare Claims Data ManagementAzure Data Factory (ADF) ExperienceMedallion Architecture Implementation

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

SQLSnowflakeETL/ELTData ModelingHealthcare Code SetsData Quality ChecksIncremental ProcessingPerformance TuningData GovernanceCI/CD Practices

Soft Skills

Strong Communication SkillsCritical ThinkingTeam CollaborationMulti-taskingProject Management

Tools & Technologies

Azure Blob StorageADLS Gen2Azure DevOpsGitSSIS

Industry Keywords

Healthcare Data StandardsX12 EDI TransactionsHIPAA ComplianceClaims AnalyticsManaged Care Concepts

Tech Stack

Tools & technologies

AzureCloudETLSnowflakeSQLSSISVault

About the role

Key responsibilities & impact

Design, build, and optimize the Claims Data Warehouse in Snowflake
Build continuous and batch ingestion into Snowflake using Snowpipe, COPY INTO, external stages, and Azure Blob Storage/ADLS Gen2
Implement incremental and near-real-time processing with Snowflake Streams, Tasks, and Dynamic Tables, including CDC, schema drift handling, and error recovery
Implement medallion architecture from raw claim ingestion through standardized, deduplicated claim data to analytics-ready marts
Tune Snowflake performance and cost using warehouse sizing, Query Profile, clustering keys, search optimization, materialized views, and resource monitors
Enforce Snowflake security and governance, including RBAC, dynamic data masking, row access policies, object tagging, and secure data sharing
Use Snowflake Time Travel, Fail-safe, zero-copy cloning, and replication for backup, recovery, testing, and BCDR
Write SQL, Snowpark, and stored procedures for ETL/ELT of large claims data volumes
Model claim header and claim line structures and manage the full claim lifecycle
Apply and maintain healthcare code sets and reference data
Develop claims-based data products for utilization management, case management, cost and trend analysis, PMPM reporting, provider and network analytics, quality measures, risk adjustment, and financial reporting
Perform claims data quality and reconciliation checks, including financial balancing, duplicate detection, eligibility matching, and completeness/timeliness validation
Partner with claims, medical management, actuarial, finance, and analytics stakeholders
Build, schedule, and monitor ADF ETL/ELT pipelines with parameterization, alerting, and retry logic
Use Azure services including ADLS Gen2/Blob Storage, Key Vault, Microsoft Entra ID, Azure Monitor, and Azure SQL/SQL Server
Maintain and migrate SSIS packages and modernize them into ADF and Snowflake patterns
Contribute to CI/CD, Git, Azure DevOps, and infrastructure-as-code practices
Use AI tools such as Snowflake Cortex, GitHub Copilot, Microsoft Copilot in Fabric, and LLM-based assistants
Optimize SQL queries and database structures across Snowflake and SQL Server
Develop and maintain data pipelines between source systems and the EDW and integrate data services with applications and business systems
Monitor platform health, performance, latency, data freshness, and storage; manage security, backup, and recovery
Keep current with Snowflake, cloud data engineering, healthcare data standards, and SQL optimization best practices

Requirements

What you’ll need

Bachelor's degree in computer science, Information Technology, or a related field
10 or more years of experience in a healthcare environment, with a focus on SQL and Enterprise Data Warehousing
Hands-on experience with Snowflake, including Snowpipe, Streams and Tasks, Dynamic Tables, COPY INTO, RBAC, masking and row access policies, warehouse sizing and performance tuning, and secure data sharing
Experience implementing medallion architecture (Bronze, Silver, and Gold layers) in Snowflake or another cloud data warehouse/lakehouse environment
Extensive hands-on experience with medical claims data, including claim header/line structures, adjustments and reversals, and eligibility/enrollment data
Working knowledge of X12 EDI healthcare transactions (837, 835, 834, 270/271, 276/277) and claim forms (CMS-1500, UB-04)
Strong command of healthcare code sets and reference data, including ICD-10, CPT/HCPCS, revenue codes, DRG, NDC, and place of service
Experience building claims-based analytics and reporting, such as utilization, cost and trend, PMPM, risk adjustment, and quality measures (e.g., HEDIS)
Hands-on experience with Azure Data Factory (ADF) and Azure data services such as ADLS Gen2/Blob Storage, Key Vault, and Azure DevOps
Experience with SQL Server Integration Services (SSIS) and SQL Server (preferred), particularly in maintaining or migrating legacy packages
Strong knowledge of data modeling and database design principles, including dimensional modeling and handling slowly changing dimensions and claim versioning
Understanding of data security, privacy, backup, and recovery procedures (i.e., BCDR), including HIPAA and handling of PHI/PII
Experience with Git-based version control and CI/CD (Azure DevOps or similar)
Knowledge of Agile methodologies and experience working in Agile environments
Strong communication skills working across business functions, including clinical, claims, and finance teams
Manage multiple projects, issues, and deliverables in a fast-paced environment
Able to multi-task and prioritize work to meet deadlines
Excellent listening, critical thinking, written and verbal skills
Works well within a team environment
Experience working in a professional environment with clinical managed care concepts, practices, and procedures preferred

Benefits

Comp & perks

Paid Time Off
Paid Parental Leave
Medical, dental, vision benefits
401K with company match
Short- and Long-Term Disability
Group Life Insurance
Tuition Reimbursement
Pet Insurance
Professional development opportunities
Business Casual work environment