Sr. Data Engineer

The Sr. Data Engineer role supports the Data & Analytics organization’s Data Foundation team, with ownership of governed, production-ready data pipeline design and implementation. The position focuses on building end-to-end ingestion, transformation, and serving layers using Snowflake and Azure.

Role Overview

You will lead enterprise-grade pipeline work within governed data products, ensuring data is reliably ingested, transformed, and served with clear lineage and stewardship. This role also partners with the Director, Data & Analytics on platform strategy, roadmap, and the Center of Excellence operating model.

Key Responsibilities

• Lead the design and implementation of enterprise-grade data pipelines on Snowflake and Azure, owning the ingestion, transformation, and serving layers for governed data products.
• Architect ingestion and integration patterns across source systems, applying CDC, batch, and streaming approaches where appropriate.
• Establish transformation frameworks using dbt as the modeling standard, ensuring pipelines are version-controlled, tested, and observable.
• Own pipeline SLAs by defining and tracking freshness, completeness, and error-rate targets, with documented runbooks and production on-call readiness.
• Drive schema governance, data modeling discipline, and data lineage and metadata management so governed KPIs have traceable sources and clear stewardship.
• Partner directly with the Director, Data & Analytics on platform strategy, roadmap, and Center of Excellence operating model.
• Mentor Data Engineers through code review, architectural pairing, and knowledge sharing as the function scales.

Required Qualifications

• 4-7 years of professional data engineering experience, with demonstrated technical leadership on enterprise-grade data platforms.
• Advanced SQL skills, including complex query authoring, performance tuning, and schema design at scale.
• Hands-on experience with dbt (preferred) or equivalent transformation frameworks, including testing, documentation, and CI/CD integration.
• Production experience with Snowflake and strong working knowledge of Microsoft Azure data services, including Azure Data Factory, Azure SQL, Storage, and Key Vault.
• Working knowledge of data governance, lineage, cataloging, and security or compliance practices in regulated environments, including SOC 2 Type 2 and PII handling principles.

Technology Stack

• Snowflake
• Azure
• dbt
• SQL
• CDC
• Azure Data Factory
• Azure SQL
• Storage
• Key Vault
• SOC 2 Type 2

Location and Experience

Location: Appleton, WI (hybrid)
Minimum Experience: 4 years

Benefits

• Medical and Prescription Drug Plans
• Dental Plan
• Vision Plan
• Health Savings Account
• Health Flexible Spending Account
• Dependent Care Flexible Spending Account
• Supplemental Life Insurance
• Short Term and Long Term Disability Insurance
• Business Travel Insurance
• 401(k), Plus Match
• Weekly Pay

After Waiting Period Eligibility

Upon completion of the waiting period, consultants are eligible for the following benefits:

• Medical and Prescription Drug Plans
• Dental Plan
• Vision Plan
• Health Savings Account
• Health Flexible Spending Account
• Dependent Care Flexible Spending Account
• Supplemental Life Insurance
• Short Term and Long Term Disability Insurance
• Business Travel Insurance
• 401(k), Plus Match
• Weekly Pay

What You Will Work On

• Architect and operate a governed Snowflake plus Azure-native data foundation supporting leadership reporting and AI-powered capabilities.
• Work within an AI governance framework developed in partnership with the client’s Legal, InfoSec, Privacy, and Compliance to support responsible AI deployment.
• Use AI development assistants, including GitHub Copilot, Microsoft Copilot, Claude, and emerging agent-based tooling, as part of daily engineering practice.