Data Engineer

ProgenyHealth, LLC

. Build, schedule, and monitor ETL/ELT pipelines using Azure Data Factory and SQL Server Integration Services .

Posted 10/23/2026contractRemote • United StatesSeniorLeadWebsite

Core Competencies

Role fit

Core Competencies

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

Demonstrates expertise in building and optimizing ETL/ELT pipelines using Azure Data Factory and SQL Server Integration Services, with a strong focus on healthcare claims data and data warehousing principles. Proficient in implementing medallion architecture and ensuring data quality and security in a fast-paced environment.

Highest-signal resume keywords

Azure Data Factory (ADF)SQL Server Integration Services (SSIS)SnowflakeData ModelingHealthcare Claims Data

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

ETL/ELT Pipeline DevelopmentSQL Query WritingData Warehouse OptimizationChange Data CaptureSchema Drift HandlingError-Recovery PatternsData Quality ChecksDatabase Performance MonitoringInfrastructure-as-Code PracticesAgile Methodologies

Soft Skills

Problem-Solving SkillsAttention to DetailStrong Communication SkillsMultitasking AbilityTeam Collaboration

Tools & Technologies

Azure DevOps (ADO)GitCI/CD PracticesAI ToolsMicrosoft Copilot in Fabric

Industry Keywords

Healthcare EnvironmentMedallion ArchitectureClinical Managed Care ConceptsData Security ProceduresBackup and Recovery Procedures

Tech Stack

Tools & technologies

AzureCloudETLSQLSSIS

About the role

Key responsibilities & impact

Build, schedule, and monitor ETL/ELT pipelines using Azure Data Factory and SQL Server Integration Services
Implement change data capture, schema drift handling, and error-recovery patterns
Ingest, model, and process healthcare claims and cases data for reporting and analytics
Use AI tools including GitHub Copilot, Microsoft Copilot in Fabric, Snowflake Cortex, and LLM-based assistants for pipeline development, code generation, documentation, testing, and troubleshooting
Develop and optimize data structures, warehouses, and workloads in Snowflake
Write SQL queries and scripts for data extraction, transformation, and loading
Analyze, monitor, and fine-tune SQL queries and database structures
Contribute to CI/CD, Git, Azure DevOps, and infrastructure-as-code practices
Manage database security, backup, and recovery strategies
Develop and maintain data pipelines between source systems and the Enterprise Data Warehouse
Perform data quality checks and troubleshoot data accuracy and consistency issues
Monitor database performance, latency, and storage
Integrate databases with applications and business systems
Keep current with database engineering, data warehousing, and SQL optimization best practices

Requirements

What you’ll need

Experience implementing medallion architecture (Bronze, Silver, and Gold layers) in a lakehouse or cloud data warehouse environment
Bachelor’s degree in computer science, Information Technology, or a related field
10 or more years of experience as a Database Engineer in a healthcare environment, focused on SQL and Enterprise Data Warehousing
Hands-on experience with healthcare claims data
Hands-on experience with Azure Data Factory (ADF)
Hands-on experience with Azure DevOps (ADO)
Hands-on experience with SQL Server Integration Services (SSIS)
Hands-on experience with Snowflake (preferred)
Strong knowledge of data modeling and database design principles
Understanding of data security, backup, and recovery procedures (BCDR)
Knowledge of Agile methodologies and experience working in Agile environments
Strong problem-solving skills and attention to detail
Strong communication skills working across business functions
Ability to manage multiple projects, issues, and deliverables in a fast-paced environment
Ability to multitask and prioritize work to meet deadlines
Excellent listening, critical thinking, written, and verbal skills
Ability to work well within a team environment
Experience working in a professional environment with clinical managed care concepts, practices, and procedures preferred

Benefits

Comp & perks

Contract opportunity
Fully remote work
Equal Opportunity Employer, including individuals with disabilities and veterans
Interview accommodation available for individuals with disabilities