Director, Data Warehouse Engineering

🕒 September 11

🇺🇸 United States – Remote

💵 $107.3k - $300.6k / year

⏰ Full Time

🔴 Lead

🚰 Data Engineer

🦅 H1B Visa Sponsor

This company has sponsored H1B visas in the past.

👻 Ghost score 10%

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 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 • Establish engineering standards for reliability, performance, scalability, data quality, and maintainability • Establish SLAs, data contracts, and data quality standards with engineering and data sciences teams • Oversee end-to-end data processing solutions supporting 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 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 focused on ownership, continuous improvement, automation, and disciplined execution • Mentor and develop managers, senior engineers, and technical leads • Build and manage multiple teams to execute on 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 trust in enterprise data and reduce manual effort and technical debt • Identify opportunities to use AI and automation to improve developer productivity and accelerate delivery

🎯 Requirements

• 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, 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 • Deep expertise in enterprise data architecture and data modeling • Experience with redesign and migration of foundational data pipelines and warehouse structures involving 1000s of tables, data pipelines and feeds • Mastery of 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, 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 practices, and scalable software delivery in AWS, GCP, or Azure • Strong communication skills with the ability to influence technical and non-technical audiences without authority • Experience using 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 • Experience in insurance, SaaS, or marketplace environments is a plus

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