[Hiring] Director, Data Warehouse Engineering @Mercury Insurance Services, LLC

Role Description

Join an amazing team that is consistently recognized for our achievements and culture, including our most recent Forbes award of being one of America's Best Midsize Employers for 2026! This is a high-impact leadership opportunity for a true data warehouse expert to help modernize a critical enterprise platform.

• Lead the evaluation, optimization, and future direction of an overloaded Redshift-based environment.
• Guide major migration and architecture decisions.
• Partner with a sizable data engineering organization to enhance the warehouse.
• Combine deep technical credibility with strong strategic judgment and stakeholder influence.
• Focus on how AI can improve data architecture, warehouse management, and ETL performance.

Mercury Insurance is looking for a Director, Data Warehouse Engineering to lead the strategy, architecture, and delivery of our enterprise data warehouse platform. This leader will own the direction of the data warehouse engineering function and help modernize the way data is built, governed, and delivered across the company.

• Combine people leadership, architectural depth, and operational excellence.
• Lead teams that build and support scalable EDW data platforms, enterprise data models, and high-reliability pipelines.
• Partner closely with Engineering, Data Science, Product, and business stakeholders.

The ideal candidate brings strong experience leading data warehousing and data engineering organizations, modernizing enterprise data platforms, and driving execution across a complex environment.

Qualifications

• Minimum: Bachelor's degree in Data Science, Data Engineering, Computer Science, Mathematics, Statistics, Engineering, Information Systems, Business Administration, or related technical field.
• Master’s degree preferred or equivalent combination of education and/or experience.
• 15+ years of experience in data engineering, data warehousing, or related disciplines.
• 10+ years of strong people leadership experience.
• Proven success leading enterprise-scale data warehouse or lake house platforms.
• Preferred: 5 or more years of experience leading large-scale data warehouse overhauls.
• Strong technical and strategic background evaluating platforms such as Redshift, Snowflake, Databricks, or similar technologies.
• Experience leveraging AI to drive process efficiencies.

Requirements

• Deep expertise in enterprise data architecture and data modeling.
• Experience partnering with cross-functional stakeholders and senior leaders.
• Mastery of modern modeling approaches, including 3NF, dimensional, star, and snowflake patterns.
• Strong understanding of operational excellence in data engineering.
• Expert-level proficiency in SQL and strong proficiency in Python.
• Production experience with modern data engineering tools and practices.
• Hands-on experience with cloud data warehouse or Lakehouse technologies.
• Strong communication skills with the ability to influence technical and non-technical audiences.
• Experience using AI tools to solve high-value operational or engineering problems.

Benefits

• Competitive compensation.
• Flexibility to work from anywhere in the United States for most positions.
• Paid time off (vacation time, sick time, 9 paid Company holidays, volunteer hours).
• Incentive bonus programs (potential for holiday bonus, referral bonus, and performance-based bonus).
• Medical, dental, vision, life, and pet insurance.
• 401 (k) retirement savings plan with company match.
• Engaging work environment.
• Promotional opportunities.
• Education assistance.
• Professional and personal development opportunities.
• Company recognition program.
• Health and wellbeing resources, including free mental wellbeing therapy/coaching sessions.