Data Warehouse Engineer

About the Role

Our client is modernizing their data ecosystem and building a

new ingestion framework

using the latest cloud and data engineering tools. We're looking for hands-on

Data Warehouse Engineers

with experience in

Snowflake, Azure , and

modern data pipelines . Ideal candidates bring a mix of

ETL development, data analysis , and

strong SQL , with the ability to work in a metrics-driven, quality-focused environment.

Top Skills We're Screening For
Snowflake

+

DBT-Snowflake
Microsoft Fabric / Snowflake Fabric
Azure Data Factory (ADF)
ADLS Gen2 / Iceberg (Apache)
GoldenGate
(Bonus)

Modern pipeline tools:

Kafka ,

Airflow ,

IDMC
Core Responsibilities

Design, build, and optimize

modern data pipelines
Develop and maintain

ETL / ELT

workflows using

Informatica & Snowflake
Perform

data analysis , focusing on data quality, lineage, and integrity
Support and contribute to the new ingestion framework
Build and enhance data warehouse, data marts, and ODS solutions
Collaborate with engineering, analytics, and cross-functional teams
Tech Environment

Snowflake
Informatica
Azure

(ADLS Gen2, ADF, MS Fabric)
Kafka ,

GoldenGate
DBT-Snowflake ,

IDMC
PySpark ,

Airflow
Meta-Data Pipeline Management tools
Preferred Background

5+ years in

data engineering , ETL development, or database applications
Strong SQL, query optimization, and RDBMS design
End-to-end

Snowflake architecture

experience (RBAC, tuning, cloning, etc.)
Experience with data warehouse, mart, and ODS solutions
Healthcare payer data familiarity (member, enrollment, claims, provider)
Cloud engineering:

Azure preferred , AWS acceptable
Nice to Have

CDMP or CBIP certification
ERwin, ER/Studio, or PowerDesigner
DataStage or SSIS experience (Informatica preferred)
Agile or ITIL certification