Dir Data Warehouse Engineering

Mercury Insurance Services, LLC; Brea (CA); On-site; USD 107,000 - 301,000; Full time

Job summary

Mercury Insurance Services, LLC is seeking a Director of Data Warehouse Engineering to lead the strategy, architecture, and delivery of the enterprise data warehouse platform. You will own the direction of the data warehouse engineering function and help modernize data across the company.

The role combines leadership, architecture, and operational excellence, building scalable data platforms and pipelines that support analytics, reporting, and AI use cases.

Qualifications

• 15+ years of experience in data engineering or data warehousing.
• 10+ years of people leadership and coaching leaders.
• Proven success leading enterprise-scale data warehouse or lakehouse platforms.

Responsibilities

• Define and lead vision, roadmap, and operating model for data warehouse engineering.
• Direct multiple teams responsible for data warehouse development, data marts, data models, and pipelines.
• Modernize data platform with governance, testing, observability, and automation.
• Establish engineering standards for reliability, performance, and data quality.
• Partner with stakeholders to align data strategy with business priorities.
• Design end-to-end data processing solutions for analytics, operations, and AI use cases.
• Lead capacity planning, tool decisions, and resource allocation across the function.
• Champion data governance and reduce technical debt; promote AI/automation enhancements.

Skills

Data architecture

Data modeling

SQL

Python

CI/CD

Cloud platforms

ETL/ELT

Leadership

Education

Bachelor's degree in a technical field

Master’s degree preferred

Tools

Informatica

DBT

Airflow

Dagster

Git

Job description

Overview

Position Summary:

Mercury Insurance is looking for a Director, Data Warehouse Engineeringto 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.

This role combines people leadership, architectural depth, and operational excellence. You will lead teams that build and support scalable EDW data platforms, enterprise data models, and high-reliability pipelines that serve analytics, reporting, operational use cases, and AI-enabled solutions. You will partner closely with Engineering, Data Science, Product, and business stakeholders to ensure Mercury’s data foundation is trusted, scalable, and aligned with business priorities.

The ideal candidate brings strong experience leading data warehousing and data engineering organizations, modernizing enterprise data platforms, and driving execution across a complex environment. This is a highly visible leadership role for someone who can set vision, raise engineering standards, and develop high-performing teams while staying connected to the technical details that matter.

Responsibilities

Essential Job Functions:

What You’ll Do

• Define and lead the vision, roadmap, and operating model for data warehouse engineering in support of Mercury’s enterprise data strategy.
• Lead multiple teams or a broader engineering function responsible for enterprise data warehouse development, data marts, core data models, and scalable data pipelines.
• Drive modernization of the data platform, including data modeling standards, orchestration patterns, testing frameworks, observability, and automation to optimize efficiency.
• Establish engineering standards for reliability, performance, scalability, data quality, and maintainability across the warehouse and pipeline ecosystem.
• Cross-collaborate with engineering/technology and data sciences teams to establish SLAs, data contracts, and data quality standards.
• Oversee the design and implementation of end-to-end data processing solutions that support enterprise reporting, business operations, data science, and AI use cases.
• Partner with senior leaders across Engineering, Data Science, Architecture, and business teams to align investments, priorities, and delivery plans.
• Translate business goals into a clear portfolio of data platform capabilities, delivery of roadmaps, and measurable outcomes.
• Lead the evolution of enterprise data models, including decisions on grain, entities, relationships, conformed dimensions, and slowly changing dimensions.
• Drive a data product mindset across the organization, helping teams move from reactive ticket-based delivery to scalable, reusable data capabilities.
• Build a strong engineering culture grounded in ownership, continuous improvement, automation, and disciplined execution.
• Mentor and develop managers, senior engineers, and technical leads, while strengthening succession planning and organizational capability.
• Build and manage multiple teams to execute on establishing data strategy.
• Guide to capacity planning, prioritization, vendor and tool decisions, and resource allocation across the function.
• Partner with engineering teams to productionize pipelines and integrations with strong service levels, resilience, and operational support.
• Champion governance, controls, and best practices that improve trust in enterprise data and reduce manual effort and technical debt.
• Identify opportunities to use AI and automation to improve developer productivity, reduce repetitive work, and accelerate delivery.

Qualifications

Education:

· 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

Experience:

15+ years of experience in data engineering, data warehousing, or related disciplines, with significant experience leading high-performing engineering teams and managers.

• 10+ years of strongpeopleleadership experience, including coaching leaders, building teams, setting expectations, and creating accountability.
• Proven success leading enterprise-scale data warehouse or lakehouse platforms in complex business environments.

Knowledge and Skills:

• Deep expertise in enterprise data architecture and data modeling.
• Redesign and migration of foundational data pipelines and warehouse structures involving 1000s of tables, data pipelines and feeds.
• Experience partnering with cross-functional stakeholders and senior leaders to prioritize roadmaps, resolve trade-offs, and deliver business value.
• Lead production support for EDS and support mandatory data requirements.
• Mastery of modern modeling approaches, including 3NF, dimensional, star, and snowflake patterns, with the judgment to apply the right model for the business need.
• Strong understanding of operational excellence in data engineering, including testing, data quality frameworks, observability, incident reduction, and service reliability.
• Expert-level proficiency in SQL and strong proficiency in Python.
• Production experience with modern data engineering tools and practices, including Informatica, DBT, orchestration platforms such as Airflow, Tivoli, or Dagster, and Git-based development workflows.
• Hands-on experience with cloud data warehouseor Lakehouse technologies such as Redshift, Databricks, Snowflake, or BigQuery.
• Familiarity with layered(medallion) data architecture patterns.
• Strong experience with CI/CD, automation-first engineering practices, and scalable software delivery in cloud environments such as AWS, GCP, or Azure.
• Strong communication skills with the ability to influence technical and non-technical audiences without authority.
• Experience using AI tools such as OpenAI, Claude, or Gemini to solve high-value operational or engineering problems.
• Bachelor’s degree in computer science or a related field, or equivalent practical experience. Master’s degree preferred.
• Experience in insurance, SaaS, or marketplace environments is a plus.

Why Join Us

• Lead a high-impact function that shapes Mercury’s enterprise data foundation.
• Help modernize the data platform and influence the future of analytics, AI, and data-driven decision-making across the company.
• Work across Engineering, Data Science, and business teams on visible initiatives with meaningful enterprise reach.
• Build and grow a strong organization while raising the bar on architecture, delivery, and operational excellence.

Pay Range

USD $107,344.71 - USD $300,603.92 /Yr.