Senior Data Engineer: Snowflake, dbt & Cloud Pipelines

Sedgwick; South Dakota; On-site; USD 111,000 - 200,000; Full time

Job summary

You will guide a data engineering teammate, promote CI/CD, and evaluate cloud data tools (Azure, AWS) to optimize data flow. A strong background in Python, SQL, and dbt will be essential.

Qualifications

• Five or more 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, LLM, or NLP search capabilities.

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 for decentralized teams.

Skills

Snowflake

Python

SQL

dbt

Azure Functions

Data pipelines

Education

Bachelor’s degree in CS/IS/Data Eng

Tools

Azure Data Factory

Stream Analytics

Snowflake Cortex

Job description

You will guide a data engineering teammate, promote CI/CD, and evaluate cloud data tools (Azure, AWS) to optimize data flow. A strong background in Python, SQL, and dbt will be essential.