Lead Data Engineer

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 #J-18808-Ljbffr Agility Partners