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