Senior Data Engineer: Snowflake, dbt & Pipelines Lead

Sedgwick; Eagle (ID); On-site; USD 111,000 - 200,000; Full time

Job summary

Sedgwick is seeking a Sr. Data Engineer to design, build, and maintain scalable data pipelines across batch and real-time streaming.

You will drive Snowflake-based platform improvements, data modeling, and storage structures to ensure high-quality data feeds for analytics and AI features. You will architect transformation pipelines for high-quality inputs to Snowflake and dbt AI features, and contribute to semantic layers and metadata models for Self-Service 2.0 interfaces.

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.

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 platform

Python

SQL

Data pipeline design

Leadership coaching

Education

Bachelor's degree in CS/IS or related field

Equivalent education/experience considered

Tools

Azure Data Factory

Azure Functions

Stream Analytics

dbt Semantic Layer

Snowflake Cortex

AWS data tools

Job description

Sedgwick is seeking a Sr. Data Engineer to design, build, and maintain scalable data pipelines across batch and real-time streaming.

You will drive Snowflake-based platform improvements, data modeling, and storage structures to ensure high-quality data feeds for analytics and AI features. You will architect transformation pipelines for high-quality inputs to Snowflake and dbt AI features, and contribute to semantic layers and metadata models for Self-Service 2.0 interfaces.