Founded in 1961, Mercury Insurance helps consumers create their ideal insurance policies and specializes in automobile, home, condo, renters, and business insur
Principal Data Architect
Location
United States
Posted
38 days ago
Salary
$107.3K - $300.6K / year
Seniority
Lead
Job Description
Principal Data Architect
Mercury Insurance
• Define and lead the enterprise data architecture strategy, target state, and multi-year roadmap for Mercury’s data platform • Establish reference architectures, standards, and guardrails for data ingestion, transformation, modeling, orchestration, quality, observability, and consumption • Drive architecture decisions for enterprise data platforms, including EDW, lakehouse, streaming, operational data integration, and domain-oriented data products • Partner with senior Technology and business leaders to align data investments to enterprise priorities, business value, and long-term scalability • Evaluate current-state architecture, identify gaps, and lead rationalization of tools, patterns, and technical debt across the data ecosystem • Provide technical direction and architectural leadership to data engineering, analytics engineering, and platform teams • Set standards for design quality, model integrity, operational excellence, and scalable delivery across the Enterprise Data & Operations function • Mentor engineers and technical leaders in architectural thinking, modern engineering practices, and delivery excellence • Design, develop, and oversee end-to-end enterprise data solutions supporting multiple data domains, data marts, and analytics use cases • Ensure scalable batch and streaming data pipelines are built to support both enterprise reporting and advanced analytics environments • Own the reliability, quality, consistency, and observability of Mercury’s core data assets and pipelines • Define service levels and operational standards for critical data products and pipelines • Partner across Product, Engineering, Data Science, Analytics, and business teams to ensure the data platform enables real business outcomes • Lead proof of concepts, architecture reviews, and technology evaluations for new tools and capabilities
Job Requirements
- Bachelor’s degree in computer science, Engineering, Information Systems, or a related field; Master’s degree 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
- Deep expertise in enterprise data modeling, including 3NF, dimensional, star, and snowflake patterns, with strong judgment on how to model real-world business processes
- Strong experience redesigning foundational data models and pipelines with a focus on scalability, usability, and reliability
- 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
- Demonstrated commitment to engineering best practices, including Git, CI/CD, infrastructure automation, testing, and DRY design principles
- Experience implementing data quality, observability, lineage, and operational controls in production environments
- Strong stakeholder management and communication skills, with the ability to influence technical and non-technical leaders
- Data product mindset with the ability to turn business needs into architecture, roadmaps, and execution plans
- Experience in insurance, SaaS, or marketplace environments is a plus
- Experience leveraging GenAI or LLM platforms such as OpenAI, Claude, or Gemini to solve meaningful business and engineering problems is strongly preferred
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
Related Guides
Related Categories
Related Job Pages
More Data Engineer Jobs
Senior Data Engineer
WurlWurl, Inc., also known as Wurl Network, is a connected TV (CTV) network founded in 2017 to connect the world's largest media brands with the largest TV streamin
• Evolve and streamline Wurl’s data ETL processes, Business Intelligence dashboards (internal and external) enhancement, data workflows (with emphasis on scale, security, maintainability, and validation), data warehousing processes, and internal/external monitoring, alarming, and reporting. • Act as a data team representative and gather requirements from the internal customers such as data science, sales team, etc.
Lead Engineer, IT - SAP Data Services
Builders FirstSourceBuilders FirstSource is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, protected veteran status or status as an individual with a disability.
Role Description This role is for a Technical Lead with ownership over the SAP Data Migration aspects of the BFS Data Engineering Team. The ideal candidate will have experience leading the technical aspects of the Data Migration team including: - Providing oversight and ownership over the technical architecture and end-to-end development process. - Implementing data migration solutions using SAP Data Services. - Ensuring timely delivery of high-quality, reliable, and cost-effective migration solutions from diverse ERP sources into SAP S/4 Hana and Azure Cloud. - Defining design guidelines using best practices related to SAP Data Services. - Coding/building pipelines, peer reviews, and general oversight. - Developing the cloud data platform as the environment matures. Qualifications - Bachelor's degree from an accredited college/university. - 7+ years relevant work experience or an equivalent combination of education and experience. - Experience leading ETL on multiple SAP data migration projects from end to end. - Demonstrated high involvement with SAP data object migration processes/tools and complex data extractions, transformations, and loading techniques. - Experience in SAP Data Migration Toolset: SAP Data Services (BODS), iDoc, BAPI, LSMW, RFC, DMC. - Experience in Azure data engineering toolset: Databricks, Microsoft SQL Databases (SQLMI), Azure DevOps. - Experience in basic data warehousing and modeling practices and techniques. - Operating System Technologies: Windows, Linux/Unix including VMs. - Database Technologies: Microsoft SQL, S/4 Hana, Sybase, ODBC/JDBC connection management. - Programming Languages: SQL, Python. Requirements - Manages and resolves data conversion issues during loading, upon consulting with functional team/client. - Demonstrated experience in performance tuning pipelines and applications related to the Data Migration process. - Demonstrated experience in IT security practices in data at rest and in motion. - Maintain Technical and Functional Documentation/Standards including Field Mapping, Validations, Process Flows, Relevancy Rules, etc. Benefits - Medical, dental, vision, and disability insurance plans. - 401(k) retirement savings plan. - PTO (including paid sick time). - 8 paid holidays per year (for salaried and hourly team members). Company Description Builders FirstSource is America’s largest supplier of building materials, value-added components, and building services to the professional market. We are committed to creating a diverse and inclusive workplace that welcomes candidates from all backgrounds and experience levels.
• Build and ship the systems behind Tern's AI features • Build the evaluation systems that answer whether an AI feature is good enough to ship and good enough to keep • Own data quality as a first-class concern • Build and maintain the ETL systems • Work alongside product squads to build reporting
Senior Data Engineer
BranchWe provide cross-platform linking and attribution solutions to the world's leading digital brands.
• Own end-to-end data systems and pipelines, that other teams and customers rely on • Design and implement data integrations across multiple backend business systems, ensuring efficient and reliable data flows • Work on streaming data processing using frameworks like Apache Beam to handle real-time data ingestion and transformation • Build and maintain APIs to enable seamless data access and sharing across internal teams and platforms • Manage orchestration and automation of workflows using Airflow on Kubernetes • Define what "correct" means for the data you own, and back it with monitoring, alerting, and integration tests • Build reusable patterns and components (hooks, plugins, alerting utilities) that are easily adoptable by other engineers and processes • Break down ambiguous work into actionable tasks, surface edge cases and failure modes early, and clarify requirements with stakeholders • Communicate tradeoffs, assumptions, and risks clearly in design reviews and PRs



