Data Warehouse Specialist

Job Title: DW Engineer Location: Minnetonka, MN, Madison, WI (Hybrid) Duration: 12+ Months Interview: Video Tax Terms: C2C (Own Corp & Sub Vendors Allowed) Position Summary: Client is seeking an experienced Data Warehouse (DW) Engineer with a strong Data Analyst mindset and modern data engineering background to support their next-generation ingestion and analytics framework. This role emphasizes quality engineering, analytical thinking, and modern tool expertise — not generalist “can-do-everything” profiles. This is a high-impact role contributing to Medica’s modern data platform transformation using Snowflake and cloud-native technologies. Key Responsibilities: Design, develop, and optimize modern data ingestion and transformation pipelines Build and maintain high-quality analytical data models in Snowflake Implement data quality, validation, and governance frameworks Support metadata and pipeline management Work closely with data analysts, product teams, and business stakeholders Ensure data accuracy, reliability, and performance across the platform Core Environment: Snowflake Informatica Modern Technology Stack (Must Have ~70% or More): Kafka Oracle GoldenGate Azure Data Lake Storage (ADLS Gen2) Apache Iceberg DBT (Snowflake) Informatica IDMC PySpark (Snowflake / Microsoft Fabric) Microsoft Fabric Azure Data Factory (ADF) Apache Airflow Metadata & Pipeline Management frameworks Required Qualifications: Strong DW / Data Engineering experience in Healthcare environments Solid Data Analyst background Strong focus on data quality, governance, and analytical modeling Proven experience working with modern cloud data platforms Excellent problem-solving and critical-thinking skills Preferred Skills: Data Quality frameworks Metadata-driven pipelines Experience modernizing legacy ingestion frameworks Snowflake performance optimization