Senior Data Engineer: Snowflake & Real-Time Pipelines

Sedgwick; Town of King (WI); On-site; USD 111,000 - 200,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

401(k) match

PTO

Disability insurance

Life insurance

Employee assistance

HSA/FSA

Voluntary benefits

Job summary

Sedgwick in Wisconsin seeks a Sr. Data Engineer to design and maintain scalable data pipelines across on-prem and cloud environments, focusing on Snowflake and dbt integration. You will mentor a data engineer and collaborate with analytics teams to deliver reliable data products for AI and NL search capabilities.

The role emphasizes governance, scalable architectures, and CI/CD practices, with opportunities to grow the data engineering function within a supportive culture.

Qualifications

• Five (5)+ years of dedicated data engineering experience, with a proven record of building production-grade data pipelines.
• Advanced hands-on experience with Snowflake architecture, performance tuning, and data sharing.
• Experience moving data across hybrid environments, including on-premises 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 preferred.
• Strong Python skills in cloud environments and Azure Functions used for data workloads.

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.
• Drives adoption of dbt for data transformation and evaluates the integration of AWS and Azure cloud data tools, including Azure Data Factory, Azure Functions, and Stream Analytics, to optimize data flow.

Skills

Snowflake architecture

Data pipelines

Python

SQL

Azure Functions

dbt

Azure Data Factory

CI/CD

Data modeling

Cloud platforms

Education

Bachelor’s degree in CS/IS/Data Eng

Tools

Snowflake

dbt

Azure Data Factory

Azure Functions

Stream Analytics

AWS

Job description

Sedgwick in Wisconsin seeks a Sr. Data Engineer to design and maintain scalable data pipelines across on-prem and cloud environments, focusing on Snowflake and dbt integration. You will mentor a data engineer and collaborate with analytics teams to deliver reliable data products for AI and NL search capabilities.

The role emphasizes governance, scalable architectures, and CI/CD practices, with opportunities to grow the data engineering function within a supportive culture.