Lead Data Engineer

A little about this gig

This opportunity sits at the center of a large-scale digital transformation focused on modernizing enterprise data systems, decommissioning legacy infrastructure, and building scalable, cloud-native data platforms. You’ll join a newly established engineering team tasked with analyzing and rebuilding legacy SQL-based pipelines into modern architectures using tools like Snowflake, AWS, and dbt. This is a highly visible, high-impact role that directly supports enterprise-wide innovation efforts.

What you’ll do:

Evaluate and analyze existing SSIS packages, documenting underlying business logic and dependencies

Rebuild and modernize legacy data pipelines using dbt, Snowflake, and AWS services

Migrate data from traditional SQL-based environments to scalable, cloud-native platforms

Collaborate closely with both technical and business stakeholders to define requirements, test solutions, and deploy optimized pipelines

Contribute to architecture decisions that align with broader enterprise transformation strategies

The ideal candidate

Extensive hands-on experience working with SSIS, including strong understanding of package architecture and workflows

Expert-level SQL skills with a deep ability to analyze and refactor legacy queries and logic

Proven experience in cloud data engineering, specifically designing, migrating, and optimizing large-scale data pipelines

Strong proficiency with dbt, including building modular pipelines and utilizing dbt seeds

Experience working within AWS and modern data platforms such as Snowflake

Ability to confidently navigate both legacy systems and modern cloud-based solutions

Reasons to love it

Opportunity to work on a highly visible enterprise transformation initiative

Exposure to modern, in-demand technologies such as Snowflake, AWS, and dbt

Collaborative, fast-paced team environment filled with highly capable, self-driven professionals

Significant ownership and influence in shaping data architecture and engineering best practices

A “get it done” culture that values autonomy, problem-solving, and innovation