Senior Snowflake Data Engineer

Hello,

Please find the JD below:

MGT Briefing:

Introduction: The MGT & LearningMate/Straive PartnershipMGT and LearningMate/Straive have established a strategic global partnership designed to deliver world-class advisory, technology, and operational solutions for public sector and education clients. This collaboration leverages MGTs deep expertise in management consulting and technology services with LearningMate/Straive’s global leadership in educational technology and talent solutions.
Through this partnership, LearningMate/Straive serves as a key sourcing and onboarding partner for MGT, enabling access to a diverse pool of global talent and specialized resources. New roles are sourced and hired in close coordination between both organizations, with LearningMate/Straive managing recruitment, onboarding, and initial training.
The partnership is built on a foundation of shared values—commitment to equity, innovation, and social impact. Together, MGT and LearningMate/Straive are able to scale services, accelerate project delivery, and offer compelling career opportunities for professionals passionate about making a difference in education and public service.
As a member of the team, you will benefit from robust onboarding, ongoing training, and the support of both organizations’ leadership. You’ll play a vital role in delivering impactful solutions that help communities thrive, while advancing your own career in a dynamic, global environment.
MGT.US
WHO WE ARE:
MGT is a leading provider of technology and advisory solutions serving state, local, and education government agencies (SLED) across the United States. Through client partnerships, MGT’s almost 1,200 employees impact communities for good by managing and securing critical networks, solving complex human capital and fiscal problems, elevating education systems, and advancing equity as a performance imperative. MGT partners with thousands of agencies as a trusted advisor delivering solutions that improve technology, operational, and economic performance to help communities thrive.
Founded in 1975, MGT initiated an ambitious restart in 2016, broadening the solutions portfolio to provide the most specialized solutions, tackling the most mission-critical problems that live at the top of the public agency leadership agenda. MGT drives over 20% compound annual organic growth and utilizes programmatic mergers and acquisitions to grow capabilities, attract top talent, and accelerate growth scale. Since 2020, MGT has successfully completed 13 acquisitions, driving over 60% compound annual inorganic growth.
Celebrating its 50th year in 2025, the firm attracts exceptional talent and empowers them to exceed client expectations as they navigate the dynamic demands of the clients we serve. Hear more about MGT’s culture in the words of our employees.

Senior Snowflake Data Engineer

Role Summary

We are seeking an experienced Senior Snowflake Data Engineer to own, build, and optimize enterprise data pipelines and transformations. This role requires an independent practitioner capable of taking on BAU/change workloads, executing data-model architectures defined by lead architects, and driving data quality, performance, and cost management across our Snowflake environment.

What You Will Own & Drive

• Build and maintain robust Snowflake data pipelines and complex data transformations.
• Absorb and execute BAU (Business-As-Usual) and change requests to free up core engineering capacity.
• Implement data-model updates and architectural changes defined by the Principal Data Architect.
• Design and build reusable data models, dynamic tables, time-travel structures, and snapshot frameworks.
• Establish automated reconciliation mechanisms, data validation, and data-quality controls across pipelines.
• Maintain Snowflake performance, cost optimization (query/warehouse tuning), and operational observability.
• Support CI/CD practices and Git-based deployment workflows for database objects and code.
• Troubleshoot, debug, and resolve complex production data pipeline issues independently.

Must-Have Experience & Technical Skills

• Deep, hands-on Snowflake engineering expertise (Dynamic Tables, Snowpark, Task history, Warehouse optimization).
• Advanced SQL mastery, including complex joins, window functions, and performance tuning.
• Proven experience building scalable ELT/ETL pipelines in enterprise environments.
• Strong understanding of dimensional data modeling, star schemas, and data warehousing principles.
• Demonstrated experience implementing data-quality frameworks and automated testing/reconciliation.
• Proficiency with Git and CI/CD pipelines for automated code deployment and database version control.
• Familiarity with MuleSoft or enterprise source integration patterns is strongly preferred.

Capacity & Strategic Impact

This position is designed for a senior engineer who can operate with complete autonomy and absorb significant operational and delivery workload. By scaling development capacity alongside our core Snowflake technical lead (Chrag), this role will accelerate pipeline delivery and insulate core architecture initiatives from operational disruption.