Data Warehouse Engineer

Data Warehouse Engineer (Contract-to-Hire)

IRIS Consulting Company is a trusted leader in providing IT staffing needs to our clients. With offices in the Minneapolis/St. Paul and Atlanta metro, we have built solid business relationships with our clients in the airline, manufacturing, insurance, healthcare, and tech industries. Full SDLC support means we get to know our clients and our candidates to find not just a match, but a true fit on both sides.

With over 25 years of experience, we can truly deliver.

Location: Remote during contract →
Hybrid after conversion (3 days onsite)

Citizenship:
USC or GC Holders Only

Type: C2H

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.

Tools

• Snowflake +
  DBT-Snowflake
• Microsoft Fabric / Snowflake Fabric
• Golden Gate
• (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
• Kafka
  , Golden Gate
• DBT‑Snowflake
  , IDMC
• Py Spark ,
  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)

Nice to Have

• CDMP or CBIP certification
• ERwin, ER/Studio, or Power Designer
• Data Stage or SSIS experience (Informatica preferred)
• Agile or ITIL certification

Referrals increase your chances of interviewing at IRIS Consulting LLC by 2x