Senior Data Engineer – Snowflake Pipelines & Mentorship Lead

Sedgwick; Montana City (MT); On-site; USD 111,000 - 200,000; Full time

Job summary

Sedgwick seeks a Sr. Data Engineer to design, build, and maintain scalable data pipelines and Snowflake-based data platforms. You will lead transformation work streams and mentor a data engineer while shaping semantic layers for AI-driven insights.

The role emphasizes on-premises to cloud data movement, batch, streaming, and event-driven patterns, with a focus on governance and scalable, reusable templates across teams.

Qualifications

• Bachelor’s degree in computer science, information systems, data engineering, or a related field from an accredited college or university preferred.
• Five (5)+ years of dedicated data engineering experience, with a proven record of building production-grade data pipelines, required.
• Advanced hands-on experience with Snowflake architecture, performance tuning, and data sharing required.
• Experience moving data across hybrid environments, including on-premises to cloud, using batch, streaming, and event-driven patterns required.
• Experience building or maintaining semantic layers and structuring data for downstream AI, large language model, or natural-language search capabilities preferred.

Responsibilities

• Designs, builds, and maintains scalable data pipelines supporting batch, real-time streaming, and event-driven data movement from on-premises and cloud sources.
• Supports Snowflake 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 enabling decentralized teams to build data products safely.

Skills

Snowflake architecture

Data pipelines

Python

SQL

dbt

Azure Data Factory

Azure Functions

Stream Analytics

Data modeling

Education

Bachelor’s degree in computer science, information systems, data engineering, or related field

Equivalent combination of education, certifications, and experience

Tools

Azure Data Factory

Azure Functions

Azure Stream Analytics

AWS data services

Job description

Sedgwick seeks a Sr. Data Engineer to design, build, and maintain scalable data pipelines and Snowflake-based data platforms. You will lead transformation work streams and mentor a data engineer while shaping semantic layers for AI-driven insights.

The role emphasizes on-premises to cloud data movement, batch, streaming, and event-driven patterns, with a focus on governance and scalable, reusable templates across teams.