Data Warehouse Engineer

IRIS Consulting LLC; Minnetonka (MN); Hybrid; USD 90,000 - 120,000; Full time

Job summary

A leading IT staffing firm is seeking a Data Warehouse Engineer to modernize data ecosystems and build a new ingestion framework. The role emphasizes experience with Snowflake and ETL development, and requires skills in data analysis and strong SQL. Candidates should be ready for hybrid work arrangements, with remote work during the contract and partial onsite duties after.

Qualifications

• 5+ years in data engineering, ETL development, or database applications.
• Strong SQL, query optimization, and RDBMS design.
• End-to-end Snowflake architecture experience.

Responsibilities

• Design, build, and optimize modern data pipelines.
• Develop and maintain ETL/ELT workflows using Informatica & Snowflake.
• Perform data analysis, focusing on data quality and integrity.

Skills

Data Engineering

ETL Development

Strong SQL

Data Analysis

Tools

Snowflake

Informatica

Kafka

Airflow

DBT-Snowflake

Job description

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
• 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
• 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)

Nice to Have

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

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