Senior Data Engineer - Snowflake, dbt & Cloud Pipelines

Sedgwick; South Dakota Park (SD); On-site; USD 111,000 - 200,000; Full time

Benefits offered by this job

Medical benefits

Dental benefits

Vision benefits

401k with matching

PTO (paid time off)

Disability insurance

Life insurance

Employee assistance program

HSA/FSA

Job summary

Sedgwick is seeking a Senior Data Engineer to design, build, and maintain scalable data pipelines across on-premises and cloud sources. You will work with Snowflake, dbt, and Azure tools to enable robust data movement and governance.

The role includes mentoring a data engineer and collaborating with cross-functional teams to mature data engineering practices, with a focus on performance and AI-ready data structures.

Qualifications

• Bachelor’s degree in computer science, information systems, data engineering, or a related field from an accredited college or university preferred.
• Equivalent combination of education, professional certifications, and relevant work experience will be considered.
• Five (5)+ years of dedicated data engineering experience, with a proven record of building production-grade data pipelines, required.

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.

Skills

Snowflake architecture

Python

SQL

Data pipelines

batch and streaming

data modeling

Education

Bachelor’s degree in CS/IS/Data Eng

Equivalent experience/certs

Tools

dbt

Azure Data Factory

Azure Functions

Stream Analytics

Snowflake Cortex/Semantic Layer

AWS data tools

Job description

Sedgwick is seeking a Senior Data Engineer to design, build, and maintain scalable data pipelines across on-premises and cloud sources. You will work with Snowflake, dbt, and Azure tools to enable robust data movement and governance.

The role includes mentoring a data engineer and collaborating with cross-functional teams to mature data engineering practices, with a focus on performance and AI-ready data structures.