Director, Data Warehouse Engineering

Job not on LinkedIn

🔥 2 minutes ago

🏄 California – Remote

🏄 California – Remote

💵 $107.3k - $300.6k / year

⏰ Full Time

🟠 Senior

🔴 Lead

🚰 Data Engineer

🦅 H1B Visa Sponsor

This company has sponsored H1B visas in the past.

👻 Ghost score 0%

What it means: how likely this posting is sitting open without active hiring.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.How we score it: age, reposts, open roles vs team size, how fast jobs close, and whether pay is listed.Fine print: an estimate from public data, not a judgment of the company. Real jobs can score high, so treat it as a hint, not a fact.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Mercury Insurance

WebsiteLinkedInAll Job Openings

5001 - 10000 employees

Founded 1962

🚘 Automotive

💼 Consulting

📦 Logistics

Automotive • Consulting • Logistics

Mercury Insurance is a leading provider of insurance products, focusing on protecting individuals and their assets with a commitment to privacy and customer service. The company operates through independent agents and offers a range of insurance services including auto, home, and other personal insurance products. Mercury Insurance prioritizes the security of personal information and compliance with privacy laws, ensuring that customer data is handled with care and only shared when necessary for account servicing or as legally required.

📋 Description

• Define and lead the vision, roadmap, and operating model for data warehouse engineering • Lead multiple teams responsible for enterprise data warehouse development, data marts, core data models, and scalable data pipelines • Drive modernization of the data platform, including modeling standards, orchestration, testing, observability, and automation • Establish engineering standards for reliability, performance, scalability, data quality, and maintainability • Establish SLAs, data contracts, and data quality standards with engineering, technology, and data sciences teams • Oversee end-to-end data processing solutions supporting reporting, business operations, data science, and AI use cases • Partner with senior leaders to align investments, priorities, and delivery plans • Translate business goals into data platform capabilities, roadmaps, and measurable outcomes • Lead the evolution of enterprise data models, including grain, entities, relationships, conformed dimensions, and slowly changing dimensions • Drive a data product mindset and scalable, reusable data capabilities • Build an engineering culture based on ownership, continuous improvement, automation, and disciplined execution • Mentor and develop managers, senior engineers, and technical leads • Build and manage multiple teams to execute data strategy • Guide capacity planning, prioritization, vendor and tool decisions, and resource allocation • Partner with engineering teams to productionize pipelines and integrations with strong service levels, resilience, and operational support • Champion governance, controls, and best practices to improve data trust and reduce manual effort and technical debt • Identify AI and automation opportunities to improve developer productivity and accelerate delivery • Lead production support for EDS and mandatory data requirements

🎯 Requirements

• 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 lakehouse platforms in complex business environments • Deep expertise in enterprise data architecture and data modeling • Experience redesigning and migrating foundational data pipelines and warehouse structures involving 1000s of tables, data pipelines and feeds • Experience partnering with cross-functional stakeholders and senior leaders • Experience with 3NF, dimensional, star, and snowflake modeling patterns • Strong understanding of testing, data quality frameworks, observability, incident reduction, and service reliability • Expert-level proficiency in SQL and strong proficiency in Python • Production experience with Informatica, DBT, Airflow, Tivoli, or Dagster, and Git-based development workflows • Hands-on experience with Redshift, Databricks, Snowflake, or BigQuery • Familiarity with layered (medallion) data architecture patterns • Strong experience with CI/CD, automation-first engineering, and AWS, GCP, or Azure • Strong communication skills with technical and non-technical audiences • Experience using AI tools such as OpenAI, Claude, or Gemini • Bachelor’s degree in computer science or a related field, or equivalent practical experience • Experience in insurance, SaaS, or marketplace environments is a plus

🏖️ Benefits

• 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