Data Engineer (Contract) – Azure, SQL & Snowflake EDW

ProgenyHealth, LLC

Harmonville (PA)

On-site

USD 120,000 - 160,000

Part time

3 days ago

Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

ProgenyHealth, LLC in Harmonville, PA seeks a skilled Database Engineer for a contract EDW initiative. You will design, develop, and maintain the Enterprise Data Warehouse, focusing on Azure, SQL, data modeling, and performance optimization to support analytics and reporting.

You will build and monitor ETL/ELT pipelines (ADF, SSIS), implement CDC and schema drift handling, ingest healthcare data, and collaborate with teams on CI/CD, security, and data quality across the data platform.

Qualifications

Bachelor’s degree in computer science, information technology, or a related field.
10+ years of database engineering experience in a healthcare environment, with a focus on SQL and Enterprise Data Warehousing.
Experience with medallion architecture in a lakehouse/cloud data warehouse environment.
Hands-on experience with Azure Data Factory (ADF) and Snowflake.
Strong knowledge of data modeling and database design principles.

Responsibilities

Build, schedule, and monitor ETL/ELT pipelines using Azure Data Factory (ADF) and SQL Server Integration Services (SSIS).
Implement change data capture (CDC), schema drift handling, and error-recovery patterns to keep pipelines reliable.
Ingest, model, and process healthcare claims and cases data to support reporting and analytics.
Develop and optimize data structures, warehouses, and workloads in Snowflake, including loading, transforming, and sharing data.
Write efficient SQL queries and scripts to support data extraction, transformation, and loading (ETL) processes.
Optimize database performance by analyzing, monitoring, and fine-tuning SQL queries and database structures.
Contribute to CI/CD, version control (Git, Azure DevOps), and infrastructure-as-code practices.
Manage database security, backup, and recovery strategies to ensure data integrity and availability.
Develop and maintain data pipelines to ensure seamless data flow between various source systems and EDW.
Perform regular data quality checks and troubleshooting to ensure the accuracy and consistency of data in the EDW.
Monitor and maintain the performance of databases, addressing any issues related to performance, latency, and storage.
Work with development teams to integrate databases with applications and ensure seamless interaction between data services and business systems.
Keep up to date with emerging trends and best practices in database engineering, data warehousing, and SQL optimization.