Lead Data Engineer
Fenton, MO, US
Location: Hybrid – in-office events in St. Louis, MO
Schedule: Full-time with on-call rotation
Overview:
We’re looking for a Lead Data Engineer to architect and optimize the pipelines and platforms that fuel UniGroup’s growing data ecosystem. In this hands-on leadership role, you’ll guide project delivery, shape our cloud-first data infrastructure, and mentor a small, collaborative team, all while working with tools like Snowflake, Matillion, and DBT.
If you thrive in a fast-paced, agile environment, have a passion for solving complex data problems, and enjoy leading others toward technical excellence, this is a great opportunity to make a measurable impact.
What You’ll Do:
• Lead the design, development, and optimization of scalable data pipelines and models using Snowflake, Matillion, Informatica, Python, and SQL
• Manage and enhance our cloud-based data ecosystem, orchestrating both streaming and batch data flows from systems such as HubSpot, Google Analytics, and legacy databases
• Oversee access control, data governance, and platform reliability to ensure secure and timely data access
• Mentor engineers and guide project execution through technical leadership and knowledge sharing
• Collaborate with stakeholders across the organization to align data priorities and support reporting platforms like ThoughtSpot and Qlik
• Participate in an on-call rotation (every 5–6 weeks) to triage and resolve overnight data pipeline issues
• Promote best practices in data engineering including automation, version control, and performance tuning
• Support modernization efforts by helping transition legacy systems to cloud-based infrastructure and DBT-based transformations
What You Bring:
Required:
• 5–7 years of experience deploying production code in a data engineering or application development environment
• Expertise with Snowflake and at least one orchestration tool (Matillion preferred)
• Strong coding experience with Python and SQL
• Familiarity with DataOps tools such as Git and DBT, and cloud environments like AWS
• Ability to translate business needs into scalable technical solutions
• Experience mentoring peers and leading technical initiatives
Nice to Have:
• Experience managing user permissions and access within Snowflake
• Background in legacy system migrations or hybrid cloud environments
• Familiarity with BI tools such as ThoughtSpot and Qlik
• Prior experience in a lead, principal, or senior data engineering role
What Success Looks Like in Year One:
• Own and optimize the Snowflake and Matillion data pipeline strategy
• Serve as a trusted expert and technical partner across engineering and analytics teams
• Drive impactful data initiatives from planning to delivery
• Contribute to a collaborative, learning-focused culture that supports professional growth
What You’ll Gain:
Health & Wellbeing
• Medical and Prescription Drug Coverage
• Dental and Vision Plans
• Flexible Spending Accounts (FSA)
• Employee Assistance Program (EAP)
• 12-week Paid Primary Caregiver Leave
• 4-week Paid Secondary Caregiver Leave
• Competitive Paid Time Off
• 8 Hours Paid Volunteer Time Off Annually
Insurance Benefits
• Company-Paid Life Insurance
• Company-Paid Short- and Long-Term Disability
• Voluntary Supplemental Life and AD&D Insurance
Additional Perks
• 401(k) with 3% Company Match
• Tuition Reimbursement
• 11 Paid Company Holidays
Why UniGroup:
At UniGroup, we support the people and systems behind well-known brands like United Van Lines and Mayflower. We’re investing heavily in cloud-based technologies and growing our data capabilities. You’ll join a close-knit team that values collaboration, curiosity, and impact. Your work will directly shape our data future.
Apply now to join our team and lead the next chapter in UniGroup’s data journey.
We foster diversity, in part, by imposing a strict policy of non-discrimination. Employment decisions are made without regard to race, color, ethnicity, national origin, sex, sexual orientation, gender identity, age, religion, disability, veteran or military status, genetic information or other status protected by the law.
We value the unique skills and experiences that veterans and separated service members bring to our workforce. While serving our country you have gained skills such as leadership, flexibility, and agility, which will help to make you successful here. We are dedicated to supporting military families and ensuring that we provide a welcoming environment for our country’s heroes. We hope you consider joining the UniGroup family.
UniGroup is committed to the full inclusion of all qualified individuals. As part of this commitment, UniGroup will ensure that persons with disabilities are provided reasonable accommodations. If reasonable accommodation is needed to participate in the job application or interview process, to perform essential job functions, and/or to receive other benefits and privileges of employment, please contact careers@unigroup.com.
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Agile AWS Data governance DataOps Data pipelines dbt Engineering Git HubSpot Informatica Matillion Pipelines Python Qlik Snowflake SQL Streaming
Perks/benefits: 401(k) matching Career development Flex hours Flex vacation Health care Insurance Medical leave Team events
More jobs like this
Explore more career opportunities
Find even more open roles below ordered by popularity of job title or skills/products/technologies used.