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
