Senior Data Engineer: Snowflake, dbt & AI Pipelines

Sedgwick; Lexington (KY); On-site; USD 111,000 - 200,000; Full time

Job summary

Sedgwick, a leading data engineering innovator, is seeking a Senior Data Engineer in Lexington, KY. You will design and maintain scalable data pipelines across on-prem and cloud sources, serving Snowflake and dbt platforms.

You’ll craft semantic layers and governance to enable AI-enabled data interactions. Ideal candidates have 5+ years in data engineering, deep Snowflake experience, and strong Python/SQL skills.

Qualifications

• Bachelor’s degree in computer science, information systems, data engineering, or a related field preferred; equivalent combination of education, professional certifications, and relevant work experience will be considered.
• Five (5)+ 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 for batch, real-time streaming, and event-driven data movement from on-premises and cloud sources.
• Core developer for the Snowflake data platform; supports platform performance, data modeling, and storage structures.
• Architects and builds transformation pipelines delivering high-quality data inputs to Snowflake and dbt AI features.
• Designs and maintains semantic layers and metadata models to support Self-Service 2.0 natural-language interfaces.
• Establishes reference architectures, reusable templates, and CI/CD best practices enabling decentralized teams to build data products safely.
• Provides direct management and career mentorship to one data engineer with potential for team growth; guides data analysts in engineering practices.
• Drives adoption of dbt for data transformation; evaluates integration of AWS and Azure cloud data tools to optimize data flow.

Skills

Python

SQL

Snowflake

dbt

Azure Functions

Azure Data Factory

Stream Analytics

Cloud environments

Data pipelines

Data modeling

Data sharing

AI / LLM support

Education

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

Tools

dbt Semantic Layer

Azure Data Factory

AWS data ecosystems

Job description

Sedgwick, a leading data engineering innovator, is seeking a Senior Data Engineer in Lexington, KY. You will design and maintain scalable data pipelines across on-prem and cloud sources, serving Snowflake and dbt platforms.

You’ll craft semantic layers and governance to enable AI-enabled data interactions. Ideal candidates have 5+ years in data engineering, deep Snowflake experience, and strong Python/SQL skills.