Agility Partners is seeking a Lead Data Engineer to decommission legacy SQL-based infrastructure and rebuild data pipelines on modern cloud platforms, including Snowflake, AWS, and dbt, as part of Safelite's SV2 transformation. This onsite role is based in Dublin, Ohio.

Responsibilities

Assess SSIS packages to document current business logic and data flows
Rebuild data pipelines utilizing dbt, Snowflake, and AWS
Migrate data from legacy SQL clusters to scalable cloud-based infrastructure
Collaborate with business and technical stakeholders to define, validate, and deploy streamlined pipelines
Contribute to architectural decisions supporting Safelite's SV2 transformation strategy

Requirements

Extensive experience with SSIS and knowledge of package structures
Advanced SQL proficiency
Proven track record in cloud data engineering, including migrating and transforming large-scale data in the cloud
Strong dbt skills, including dbt seeds and modular pipeline builds

Technologies

SSIS
dbt
Snowflake
AWS
SQL

Benefits

401(k)
Dental insurance
Health insurance
Paid time off
Vision insurance

Project Overview

You will join a newly formed team focused on decommissioning legacy SQL-based infrastructure and rebuilding pipelines and logic on modern cloud platforms such as Snowflake, AWS, and dbt. This is a high-impact role supporting one of Safelite's most visible internal transformations.

Team Culture

This is a highly collaborative, fast-moving group of problem-solvers. The environment favors smart, self-starting professionals who focus on getting things done.

Nice-to-Have Skills

Snowflake modeling and performance tuning experience
Familiarity with AWS cloud services
Exposure to Type 2 slowly changing dimensions
Understanding of medallion architecture (bronze, silver, gold)

Pay

Salary: USD 145,000 - 150,000 per year.

Work Location

Location: Dublin, OH on-site

Lead Data Engineer

Job Description