
Principal Data Architect
Mercury Insurance Services, LLC1 day ago
Remote, United StatesStaff+
Base Salary
$107k - $301k/yr
Responsibilities
- Define and lead Mercury’s enterprise data architecture strategy, target state, standards, and multi-year roadmap.
- Establish reference architectures and guardrails for ingestion, transformation, modeling, orchestration, quality, observability, and data consumption.
- Lead architecture decisions for enterprise data warehouses, lakehouses, streaming systems, operational data integration, and domain-oriented data products.
- Provide technical direction and architectural leadership to data engineering, analytics engineering, and platform teams.
- Design and oversee end-to-end data solutions, foundational enterprise data models, data marts, and analytics capabilities.
- Guide scalable batch and streaming pipeline development using layered data architecture patterns such as Bronze, Silver, and Gold zones.
- Own the reliability, quality, consistency, observability, lineage, monitoring, alerting, and recovery of core data assets and pipelines.
- Define service levels and operational standards for critical data products and pipelines.
- Partner with security, compliance, governance, Product, Engineering, Data Science, Analytics, and business teams.
- Lead proof of concepts, architecture reviews, technology evaluations, vendor selection, and platform-direction decisions.
- Identify opportunities to apply GenAI and LLM capabilities to engineering productivity, data operations, governance, and insight generation.
- Mentor engineers and technical leaders and raise technical quality, design rigor, and execution standards across the data engineering organization.
Requirements
- Bachelor’s degree in Computer Science, Engineering, Information Systems, or a related field is required; a master’s degree is preferred.
- 12+ years of experience in data engineering, data architecture, or enterprise data platform leadership.
- 5–10 years of experience leading, mentoring, and growing high-performing data engineering or analytics engineering teams.
- Proven experience defining enterprise data strategy and leading large-scale modernization of data pipelines, platforms, and models.
- Expertise in enterprise data modeling, including 3NF, dimensional, star, and snowflake patterns.
- Expert-level SQL and Python skills with strong production experience in Informatica and dbt, including models, testing, and package management.
- Experience with orchestration frameworks such as Airflow, Dagster, Tivoli, or similar tools.
- Familiarity with streaming and event-driven data technologies such as Kafka or comparable platforms.
- Hands-on experience with modern warehouse and lakehouse platforms such as Snowflake, Databricks, Redshift, or BigQuery.
- Strong understanding of cloud-native engineering practices across AWS, GCP, or Azure.
- Experience implementing data quality, observability, lineage, and operational controls in production environments.
- Experience with Git, infrastructure automation, testing, and disaster recovery practices.
- Strong stakeholder management and communication skills with the ability to influence technical and non-technical leaders.
- Experience in insurance, SaaS, or marketplace environments is a plus.
- Experience leveraging GenAI or LLM platforms such as OpenAI, Claude, or Gemini is strongly preferred.
Benefits
- Competitive compensation, incentive bonus programs, and potential holiday, referral, and performance-based bonuses.
- Paid time off including vacation time, sick time, nine company holidays, and volunteer hours.
- Medical, dental, vision, life, and pet insurance.
- 401(k) retirement savings plan with company match.
- Flexibility to work from anywhere in the United States for most positions; an in-person interview may be required during the hiring process.
- Education assistance and professional and personal development opportunities.
- Promotional opportunities and a company recognition program.
- Health and wellbeing resources including free mental wellbeing therapy or coaching sessions and child- and eldercare resources.
Tech Stack
Amazon RedshiftApache AirflowApache KafkaAWSAzureDatabricksdbtGitGoogle BigQueryGoogle Cloud PlatformInformaticaPythonSnowflakeSQL
Categories
Data Engineering
About Mercury Insurance Services, LLC
Mercury Insurance Services, LLC sells personal auto, homeowners, renters, and related coverage (umbrella, condo, business auto, and mechanical breakdown) to consumers, primarily through independent agents. The company generates revenue from underwriting and premiums on property-and-casualty policies and is publicly traded on the NYSE (ticker: MCY). Founded in 1962 and headquartered in Brea, California, it is a major writer of auto insurance in California and operates in multiple U.S. states.