Lead Data Engineer
Agility
Dublin, United States of America
1 month ago
Role details
Contract type
Permanent contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
English Experience level
Senior Compensation
$ 150KJob location
Dublin, United States of America
Tech stack
Amazon Web Services (AWS)
Big Data
Performance Tuning
Standard Sql
SQL Server Integration Services
Snowflake
Requirements
Do you have experience in Scalability?, This is a senior-level engineering role. Candidates must be sharp, experienced, and confident across both legacy and modern data stacks:
- Extensive experience with SSIS and understanding of package structures
- Expert-level SQL skills
- Proven track record of cloud data engineering work - migrating and transforming large-scale data in the cloud
- Proficient in dbt, including dbt seeds and modular pipeline builds
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)
Benefits & conditions
Pulled from the full job description
- 401(k)
- Health insurance
- Paid time off
- Vision insurance
- Dental insurance, * 401(k)
- Dental insurance
- Health insurance
- Paid time off
- Vision insurance
About the company
You'll be joining a newly formed team decommissioning legacy SQL-based infrastructure and rebuilding pipelines and logic on modern cloud-based platforms like 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 vibe is:
Smart, self-starting, "get sht done" kind of people.
What You'll Do
* Evaluate and analyze SSIS packages and document existing business logic
* Rebuild and convert data pipelines using modern technologies such as 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
* Participate in architectural decisions to support Safelite's broader SV2 transformation strategy