Senior Data Engineer: Snowflake & Data Pipelines

Sedgwick; Michigan; On-site; USD 111,000 - 200,000; Full time

Benefits offered by this job

Benefits package

401k matching

Job summary

Sedgwick is seeking a Sr. Data Engineer in Michigan to design, build, and maintain scalable data pipelines across on-premises and cloud sources, with a focus on Snowflake, dbt, and AI-enabled data products.

You will serve as a core developer for Snowflake, optimize performance, and guide data analysts and engineers in maturing practices while advancing CI/CD and cloud integration initiatives. The role requires strong Python and SQL skills and experience with Azure data tools.

Qualifications

• Five or more years of dedicated data engineering experience building production-grade data pipelines.
• Advanced hands-on experience with Snowflake architecture, performance tuning, and data sharing.
• Experience moving data across hybrid environments (on-prem to cloud) using batch, streaming, and event-driven patterns.
• Experience building or maintaining semantic layers and structuring data for downstream AI, large language model, or natural-language search capabilities.

Responsibilities

• Designs, builds, and maintains scalable data pipelines supporting batch, real-time streaming, and event-driven data movement from on-premises and cloud sources.
• Serves as a core developer for the Snowflake data platform and supports platform performance, data modeling, and storage structures.
• Architects and builds transformation pipelines that deliver high-quality data inputs to Snowflake and dbt AI features.
• Designs and maintains semantic layers and metadata models required to support Self-Service 2.0 natural-language user interfaces.
• Establishes reference architectures, reusable templates, and CI/CD best practices that enable decentralized line-of-business teams to build data products safely and consistently.
• Provides direct management and career mentorship to one data engineer, with potential for team growth, and guides decentralized data analysts in maturing their engineering practices.

Skills

Snowflake

Data pipelines

Python

SQL

Azure Functions

Education

Bachelor's degree

Tools

dbt Semantic Layer

Snowflake Cortex

Azure Data Factory

Stream Analytics

dbt

Job description

Sedgwick is seeking a Sr. Data Engineer in Michigan to design, build, and maintain scalable data pipelines across on-premises and cloud sources, with a focus on Snowflake, dbt, and AI-enabled data products.

You will serve as a core developer for Snowflake, optimize performance, and guide data analysts and engineers in maturing practices while advancing CI/CD and cloud integration initiatives. The role requires strong Python and SQL skills and experience with Azure data tools.