Back to jobs

Director, Data Warehouse Engineering

Pay
Pay varies by location — pay source
State specific pay scales for this role are as follows: $118,078 to $330,661 (NJ, NY, WA, HI, AK, MD, CT, RI, MA) $118,078 to $330,661 (NV, OR, AZ, CO, WY, TX, ND, MN, MO, IL, WI, FL, GA, MI, OH, VA, PA, DE, VT, NH, ME)
$118,078 to $330,661 (NJ, NY, WA, HI, AK, MD, CT, RI, MA) $118,078 to $330,661 (NV, OR, AZ, CO, WY, TX, ND, MN, MO, IL, WI, FL, GA, MI, OH, VA, PA, DE, VT, NH, ME) $118,078 to $330,661 (UT, ID, MT, NM, SD, NE, KS, OK, IA, AR, LA, MS, AL, TN, KY, IN, SC, NC, WV)
$118,078 to $330,661 (NV, OR, AZ, CO, WY, TX, ND, MN, MO, IL, WI, FL, GA, MI, OH, VA, PA, DE, VT, NH, ME) $118,078 to $330,661 (UT, ID, MT, NM, SD, NE, KS, OK, IA, AR, LA, MS, AL, TN, KY, IN, SC, NC, WV) In CA: Typical hiring range is $201,933 to $280,462
Read the full posting
Work setting
Working pattern needs review — work setting source
Listed location: Remote, UNAVAILABLE
Read the full posting
Employment
Not stated

Pay by location

Also stated
$118K–$331K
In CA
$202K–$280K
Also stated
$107K–$301K

What you’ll work on

Full posting

Mercury Insurance is looking for a Director, Data Warehouse Engineering to lead the strategy, architecture, and delivery of our enterprise data warehouse platform.

This role combines people leadership, architectural depth, and operational excellence.

  • Define the vision, roadmap, and operating model for data warehouse engineering

  • Lead teams building enterprise data warehouse, data marts, and data pipelines

  • Drive modernization of the data platform, modeling standards, and testing

  • Establish engineering standards for reliability, performance, and data quality

  • Lead the evolution of enterprise data models and conformed dimensions

From the employer’s posting
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.
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.
Define and lead the vision, roadmap, and operating model for data warehouse engineering
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.
Lead the evolution of enterprise data models, including decisions on grain, entities, relationships, conformed dimensions, and slowly changing dimensions.

What you’ll bring

All qualifications

Core experience

  • Bachelor's degree in Data Science, Data Engineering, Computer Science, Mathematics, Statistics, Engineering, Information Systems, Business Administration, or related technical field
  • 15+ years of experience in data engineering, data warehousing, or related disciplines, with significant experience leading high-performing engineering teams and managers.
  • 5 or more years of experience leading large-scale data warehouse overhauls, pipeline migrations, and performance improvement initiatives across legacy platforms and modern cloud architectures.
  • Deep expertise in enterprise data architecture and data modeling.
  • Master’s degree preferred or equivalent combination of education and/or experience
  • 10+ years of strong people leadership experience, including coaching leaders, building teams, setting expectations, and creating accountability.

Preferred experience

  • Master’s degree preferred.
  • Experience in insurance, SaaS, or marketplace environments is a plus.
Qualification wording
Bachelor's degree in Data Science, Data Engineering, Computer Science, Mathematics, Statistics, Engineering, Information Systems, Business Administration, or related technical field
15+ years of experience in data engineering, data warehousing, or related disciplines, with significant experience leading high-performing engineering teams and managers.
5 or more years of experience leading large-scale data warehouse overhauls, pipeline migrations, and performance improvement initiatives across legacy platforms and modern cloud architectures.
Deep expertise in enterprise data architecture and data modeling.
Master’s degree preferred or equivalent combination of education and/or experience
10+ years of strong people leadership experience, including coaching leaders, building teams, setting expectations, and creating accountability.
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.
Education & alternatives
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
- 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:
- 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.

About Mercury Insurance Services

At Mercury, we have been guided by our purpose to help people reduce risk and overcome unexpected events for more than 60 years.

In the employer’s words · Read in context

Posting record

Report an error
Status in our records
Live
First seen by us
Sep 20, 202662 days ago
Recorded sightings
72
Last seen by us
Nov 21, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Time since we first saw it

Day 62

Up longer than most. Similar jobs usually come down between day 8 and day 57.

Well past Mercury Insurance Services’s usual: its jobs come down by about day 3.

From 9,984 similar postings that came down, and 6 of Mercury Insurance Services’s. Coming down is not always a hire.

Mercury Insurance Services is hiring

9 open jobs

Open jobs by the week we first saw them, last 12 weeks.

  • Hiring is picking up
  • Takes jobs down at a usual pace
  • 22% of open jobs were reposted
Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • Python
  • SQL
  • AWS
  • Azure
  • BigQuery
  • Databricks
  • dbt
  • GCP
  • Informatica
  • Redshift
  • Snowflake
  • Airflow
  • Dagster
Where the posting names them
- 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.
- 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.
- 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 warehouse or Lakehouse technologies such as Redshift, Databricks, Snowflake, or BigQuery. - Familiarity with layered(medallion) data architecture patterns.
- 5 or more years of experience leading large-scale data warehouse overhauls, pipeline migrations, and performance improvement initiatives across legacy platforms and modern cloud architectures. - Strong technical and strategic background evaluating platforms such as Redshift, Snowflake, Databricks, or similar technologies, with the ability to recommend a path forward and build stakeholder alignment. - Experience leading and developing data engineering organizations, including inheriting and guiding teams responsible for warehouse architecture, ETL performance, and execution at scale.
- 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 warehouse or Lakehouse technologies such as Redshift, Databricks, Snowflake, or BigQuery.
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. You’ll lead the evaluation, optimization, and future direction of an overloaded Redshift-based environment, guide major migration and architecture decisions, and partner with a sizable data engineering organization to bring the warehouse to the next level. We’re looking for a leader who combines deep technical credibility with strong strategic judgment, stakeholder influence, and a forward-looking view on how AI can improve data architecture, warehouse management, and ETL performance. Position Summary:
- 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.

Your next step

Complete your application on careers-mercuryinsurance.icims.com. The employer’s form will show what is required.

Applying through iCIMS

  • You start with your email. New applicants then create a login, and returning ones sign in.
  • Upload your resume before you fill anything in: iCIMS fills some profile fields from it.
  • Check your status on the employer’s iCIMS Dashboard, under Past Job Submittals.

Already applied? Track this application

Job description

View original posting ↗

Overview

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. You’ll lead the evaluation, optimization, and future direction of an overloaded Redshift-based environment, guide major migration and architecture decisions, and partner with a sizable data engineering organization to bring the warehouse to the next level. We’re looking for a leader who combines deep technical credibility with strong strategic judgment, stakeholder influence, and a forward-looking view on how AI can improve data architecture, warehouse management, and ETL performance.

 

Position Summary:

 

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.

 

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.

 

Geo-Salary Information

An in-person interview may be required during the hiring process

 

State specific pay scales for this role are as follows:

$118,078 to $330,661 (NJ, NY, WA, HI, AK, MD, CT, RI, MA)

$118,078 to $330,661 (NV, OR, AZ, CO, WY, TX, ND, MN, MO, IL, WI, FL, GA, MI, OH, VA, PA, DE, VT, NH, ME)

$118,078 to $330,661 (UT, ID, MT, NM, SD, NE, KS, OK, IA, AR, LA, MS, AL, TN, KY, IN, SC, NC, WV)

 

In CA: Typical hiring range is $201,933 to $280,462

 

The expected base salary for this position will vary depending on a number of factors, including relevant experience, skills and location.

Responsibilities

Essential Job Functions:

  • 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:

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

Experience:

Minimum:

  • 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 strong people leadership experience, including coaching leaders, building teams, setting expectations, and creating accountability.
  • Proven success leading enterprise-scale data warehouse or lake house platforms in complex business environments.

Preferred:

  • 5 or more years of experience leading large-scale data warehouse overhauls, pipeline migrations, and performance improvement initiatives across legacy platforms and modern cloud architectures.
  • Strong technical and strategic background evaluating platforms such as Redshift, Snowflake, Databricks, or similar technologies, with the ability to recommend a path forward and build stakeholder alignment.

  • Experience leading and developing data engineering organizations, including inheriting and guiding teams responsible for warehouse architecture, ETL performance, and execution at scale.

  • Experience with leveraging AI to drive process efficiencies across optimization, modernization, management, performance.  

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 warehouse or 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.

 

About the Company

Why choose a career at Mercury?

At Mercury, we have been guided by our purpose to help people reduce risk and overcome unexpected events for more than 60 years. We are one team with a common goal to help others. Everyone needs insurance and we can’t imagine a world without it.

 

Our team will encourage you to grow, make time to have fun, and work together to make great things happen. We embrace the strengths and values of each team member. We believe in having diverse perspectives where everyone is included, to serve customers from all walks of life.

 

We care about our people, and we mean it. We reward our talented professionals with a competitive salary, bonus potential, and a variety of benefits to help our team members reach their health, retirement, and professional goals.

 

Learn more about us here: https://www.mercuryinsurance.com/about/careers

#LI-ZK1

Perks and Benefits

We offer many great benefits, including:

  • 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, child and eldercare resources, and more

Mercury Insurance is an equal opportunity employer.  All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other characteristic protected by federal, state, or local law.

Pay Range

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

About Mercury Insurance Services

People
About 4,300 in 2025, up 2% from the year before.Annual report (SEC Form 10-K)
Company
Listed as MCY.

Demand for Data Leadership roles

New Data Leadership postings at the employers we follow are up 8% over the last 6 weeks compared with the 6 before.

Weekly new Data Leadership postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 751, the most 1,165, and the latest week had 775.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Data Leadership, by the work the posting describes.

Data leaders run data teams or design how a company's data fits together. Managers hire, set priorities and answer for whether the data work pays off; architects choose the systems and the shape of the data.

Expect years of hands-on data work, experience leading people or projects, and the ability to explain tradeoffs to executives.

Unlike a senior engineer or analyst, most of a data leader's week goes to people, planning and decisions rather than building.

US government figures for computer and information systems managers

Median yearly pay, May 2025
$175,140
Expected change, 2025 to 2035
15.8% more jobsagainst 3.5% for all jobs

The government has no code for data leaders, so these figures are for the closest group, computer and information systems managers, which includes data processing and data operations managers.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 11-3021.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay
State specific pay scales for this role are as follows: $118,078 to $330,661 (NJ, NY, WA, HI, AK, MD, CT, RI, MA) $118,078 to $330,661 (NV, OR, AZ, CO, WY, TX, ND, MN, MO, IL, WI, FL, GA, MI, OH, VA, PA, DE, VT, NH, ME)
More source context
$118,078 to $330,661 (NJ, NY, WA, HI, AK, MD, CT, RI, MA) $118,078 to $330,661 (NV, OR, AZ, CO, WY, TX, ND, MN, MO, IL, WI, FL, GA, MI, OH, VA, PA, DE, VT, NH, ME) $118,078 to $330,661 (UT, ID, MT, NM, SD, NE, KS, OK, IA, AR, LA, MS, AL, TN, KY, IN, SC, NC, WV)

More relevant text appears in the full description.

Location & working pattern

Remote

Working pattern and location restrictions need checking in the full posting.

Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.