Lead Data Analytics Engineer

atMercury InsuranceRemoteUS flagCaliforniaFull-timeAnalytics EngineerSenior$139.7k – $218.3k/year

Posted 11 hours ago

This is a fully remote position, open to applicants in California.

📋 Description

• Contribute to the development of Mercury's governed, AI-ready analytics ecosystem.

• Establish enterprise metrics and facilitate reliable insights across underwriting, sales, product, claims, and customer experience.

• Develop highly scalable production data pipelines for advanced analytics and data science teams.

• Conduct ad-hoc analyses for staff in less technical roles.

• Design, assess, and validate data infrastructures.

• Act as a subject matter expert for data throughout the organization.

• Collaborate closely with the Data Science team on intricate analytics and data preparation tasks.

• Design, construct, and deploy advanced data models and visualizations supporting various use cases across departments, products, and states.

• Address complex data integration challenges using ETL patterns, frameworks, querying techniques, and both structured and unstructured data sources.

• Manage existing production processes and enhance complex code utilizing advanced algorithmic concepts.

• Extract and manipulate data from Mercury's data lakes, data warehouses, and data cubes.

• Partner with data analysts and data scientists to devise solutions for intricate data issues.

• Influence organizational functions to pinpoint data opportunities that foster profitable growth.

• Identify challenges within existing data models.

• Address data-related requests and carry out data housekeeping, cleansing, normalization, hashing, and necessary changes to data models.

• Analyze data to uncover anomalies, trends, and correlations.

• Design, develop, and implement natural language processing software modules.


⛳️ Requirements

• A bachelor's degree in Computer Engineering, Computer Science, Mathematics, Electrical Engineering, Information Systems, or a related field, or an equivalent combination of education and/or experience.

• A minimum of 5 years of experience in data analytics, analytics engineering, data engineering, and/or data science.

• At least 3 years of experience in P&C insurance is preferred, but not mandatory.

• Proven experience in building enterprise metrics stores, semantic layers, or governed KPI frameworks, including metric definitions, relationships, hierarchies, and lineage (e.g., with dbt).

• Familiarity with prompt engineering or LLM-powered assistants, including persona design, guardrails, retrieval or knowledge bases, and validation.

• Experience with P&C insurance data such as quote, bind, policy, claims, or agent data.

• Knowledge of orchestration tools such as Airflow, Dagster, Prefect, or dbt Cloud.

• Proficiency in SQL and Python for building data pipelines and conducting analyses.

• Experience with AWS (S3, EC2) and Unix/Shell scripting.

• ETL/ELT experience with tools like dbt, Informatica, or Fivetran.

• Familiarity with relational and non-relational databases and data sources.

• Understanding of data pipeline orchestration frameworks and related tools.

• Awareness of CI/CD best practices.

• Expert proficiency with large structured and unstructured data sources.

• Capability to interact with senior management.

• Expertise in analyzing data to identify gaps and inconsistencies.

• Strong conceptual, analytical, and creative thinking skills; comfort with ambiguity.

• Experience in managing and communicating data plans and data models to internal clients.

• Knowledge of data/analytics engineering best practices.

• Advanced skills in data mining and data analytics.

• Familiarity with cloud-based advanced data and analytics environments.

• Excellent problem-solving abilities.

• Strong analytical and critical thinking skills.

• Exceptional written and verbal communication skills.

• Demonstrate the Company's Core Values.


🏝️ Benefits

• Competitive compensation.

• Flexibility to work remotely from anywhere in the United States for most positions.

• Paid time off including vacation, sick leave, 9 paid Company holidays, and volunteer hours.

• Incentive bonus programs with potential for holiday bonuses, referral bonuses, and performance-based bonuses.

• Comprehensive medical, dental, vision, life, and pet insurance.

• 401(k) retirement savings plan with company match.

• An engaging work environment.

• Opportunities for promotion.

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

• Bonus potential.

People also viewed

LawnStarter11 hours ago

Analytics Engineering Manager, Data Platform – Governance

BR flagBrazil OnlyFull-timeAnalytics Engineer$75k – $120k/year
ApplyView job
LawnStarter11 hours ago

Lead Analytics Engineer, Data Governance – Platform

MX flagMexico, +3 more countriesFreelanceAnalytics Engineer$75k – $100k/year
ApplyView job
LawnStarter11 hours ago

Lead Analytics Engineer, Data Governance – Platform

BR flagBrazil OnlyFreelanceAnalytics Engineer$75k – $100k/year
ApplyView job
Enfuce11 hours ago

Senior Analytics Engineer

FI flagFinland, +4 more countriesFull-timeAnalytics Engineer
ApplyView job
Coinbase11 hours ago

Senior Analytics Engineer

US flagUnited States OnlyFull-timeAnalytics EngineerC$191.1k/year
ApplyView job
LawnStarter15 hours ago

Analytics Engineering Manager, Data Platform – Governance

MX flagMexico, +3 more countriesFull-timeAnalytics Engineer$75k – $120k/year
ApplyView job

Never miss a great job!

Get handpicked remote jobs straight to your inbox weekly.

Trusted by 7,400+ designers