Senior Data Engineer — Remote, Snowflake/dbt Expert

Sedgwick; Frankfort (KY); Remote; USD 120,000 - 180,000; Full time

Job summary

Sedgwick is seeking a Sr. Data Engineer to design, build, and maintain scalable data pipelines across on‑premises and cloud environments. You’ll be a core developer for Snowflake, collaborate on data modeling, and enable AI-ready data inputs with dbt and related tools.

You’ll provide direct mentorship to one data engineer, guide analytics teams, and promote governance, CI/CD practices, and reliable data product delivery in a fast-paced, collaborative setting.

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.
• 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.
• 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.
• Performs other duties as assigned.
• Supports the organization’s quality program(s).
• Travels as required.

Skills

Snowflake architecture

Data pipeline architecture

dbt Semantic Layer

Python (cloud/Azure)

SQL capabilities

dbt

Azure Data Factory

Azure Functions

Stream Analytics

AWS data tools

CI/CD & patterns

Leadership & coaching

Cross-functional collaboration

Data governance & quality

Education

Bachelor's degree in computer science, information systems, data engineering

Equivalent combination of education and experience

5+ years data engineering experience

Tools

Snowflake

dbt

Azure Data Factory

Azure Functions

Stream Analytics

AWS data services

Job description

Sedgwick is seeking a Sr. Data Engineer to design, build, and maintain scalable data pipelines across on‑premises and cloud environments. You’ll be a core developer for Snowflake, collaborate on data modeling, and enable AI-ready data inputs with dbt and related tools.

You’ll provide direct mentorship to one data engineer, guide analytics teams, and promote governance, CI/CD practices, and reliable data product delivery in a fast-paced, collaborative setting.