The Lead Data Engineer will decommission legacy SQL based infrastructure and rebuild data pipelines on modern cloud platforms, including Snowflake, AWS, and dbt, to support Safeliteβs SV2 transformation.
Responsibilities
- Assess SSIS packages and document the underlying business logic
- Rebuild and modernize data pipelines using dbt, Snowflake, and AWS
- Migrate data from legacy SQL clusters to scalable cloud-based infrastructure
- Collaborate with business and technical stakeholders to define, test, and deploy clean, optimized pipelines
- Contribute to architectural decisions aligned with Safeliteβs SV2 transformation strategy
Requirements
- Extensive experience with SSIS and a solid understanding of package structures
- Expert-level SQL skills
- Proven track record in cloud data engineering, including migrating and transforming large-scale data in the cloud
- Proficiency in dbt, 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 dedicated to 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 are focused on delivering results.
Nice-to-have Skills
- Experience with Snowflake modeling and performance tuning
- Familiarity with AWS cloud services
- Exposure to Type 2 slowly changing dimensions
- Understanding of medallion architecture (bronze/silver/gold)
Compensation
Salary: USD 145,000 - 150,000 per year
Location: Dublin, OH, onsite