Lead Data Analytics Engineer

Job not on LinkedIn

🔥 0 minutes ago

💵 $139.7k - $218.3k / year

⏰ Full Time

🟠 Senior

📊 Analytics Engineer

Where this job comes from

Posted on Mercury Insurance's careers page ↗Mercury Insurance's careers page, not through a job board

First seen by Remote Rocketship 0 minutes ago

Apply Now
Logo of Mercury Insurance

Mercury Insurance

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

• Help shape Mercury's governed, AI-ready analytics ecosystem • Build enterprise metrics and enable trusted insights across underwriting, sales, product, claims, and customer experience • Create highly scalable production data pipelines for advanced analytics and data science teams • Perform ad-hoc analyses for personnel in less technical functions • Design, evaluate, and test data infrastructures • Serve as a subject matter expert for data across the organization • Work closely with the Data Science team on complex analytics and data preparation tasks • Design, build, and launch sophisticated data models and visualizations supporting multiple use cases across departments, products, and states • Solve complex data integration problems using ETL patterns, frameworks, query techniques, and structured and unstructured data sources • Own existing production processes and optimize complex code through advanced algorithmic concepts • Extract and manipulate data from Mercury's data lakes, data warehouses, and data cubes • Collaborate with data analysts and data scientists to develop solutions for complex data problems • Influence organizational functions to identify data opportunities that drive profitable growth • Identify pain points in existing data models • Fulfill data-related requests and perform data housekeeping, cleansing, normalization, hashing, and required data model changes • Analyze data to identify anomalies, trends, and correlations • Design, develop, and implement natural language processing software modules

🎯 Requirements

• Bachelor's degree in Computer Engineering, Computer Science, Mathematics, Electrical Engineering, Information Systems, or related field, or equivalent combination of education and/or experience • 5 or more years of experience in data analytics, analytics engineering, data engineering, and/or data science • 3 or more years experience in P&C insurance, preferred, but not required • Experience building enterprise metrics stores, semantic layers, or governed KPI frameworks, including metric definitions, relationships, hierarchies, and lineage (e.g., with dbt) • Experience with prompt engineering or LLM-powered assistants, including persona design, guardrails, retrieval or knowledge bases, and validation • Experience working with P&C insurance data such as quote, bind, policy, claims, or agent data • Familiarity with orchestration tools such as Airflow, Dagster, Prefect, or dbt Cloud • Experience working with SQL and Python to build data pipelines and perform analyses • Experience with AWS (S3, EC2) and Unix/Shell scripting • ETL/ELT experience, such as dbt, Informatica, or Fivetran • Experience with relational and non-relational databases and data sources • Familiarity with data pipeline orchestration frameworks and related tools • Familiarity with CI/CD best practices • Expert data skills with large structured and unstructured data sources • Ability to work with senior management • Expertise analyzing data to identify gaps and inconsistencies • Conceptual, analytical, and creative thinking; comfort with ambiguity • Experience managing and communicating data plans and data models to internal clients • Understanding of data/analytics engineering best practices • Expert skills in data mining and data analytics • Experience with cloud-based advanced data and analytics environments • Excellent problem-solving skills • Excellent analytical and critical thinking • Excellent written and verbal communication skills • Demonstrate Company's Core Values

🏖️ 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 • Bonus potential

Apply Now

📊 Check your resume score for this job

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

Similar Jobs

🔥 2 hours ago

ISI

51 - 200

💼 Consulting

🎖️ Defense

🔒 Cybersecurity

Analytics Engineer building secure Snowflake models, metrics, and dashboards. Supporting defense, managed security services, and finance operations with governed automation.

🕒 3 days ago

The Krazy Coupon Lady

51 - 200

🤲 Charity

🌍 Social Impact

Senior Analytics Engineer building governed Databricks data products for CPG brands. Delivering secure client analytics, data sharing, and trustworthy agentic insights.

🕒 4 days ago

EvenUp

51 - 200

💼 Consulting

🏥 Healthcare

⚖️ Legal

Analytics Engineer building BigQuery and dbt finance data infrastructure for EvenUp’s AI-powered legal technology platform. Ensuring PHI-safe, reconciled reporting for Finance self-service.

🕒 4 days ago

LTHC

2 - 10

🧘 Wellness

⚽ Sports

👥 B2C

Software Engineer developing and supporting ETL software for Excellus Health Plan. Building secure applications, testing systems, and resolving production issues across the health plan service region.

🕒 4 days ago

Fi

51 - 200

👥 B2C

🔧 Hardware

Lead Analytics Engineer owning analytics models and BI for Fi’s pet tracking technology. Building subscription and collar telemetry data foundations for acquisition, retention, churn, and LTV insights.

Developed by Lior Neu-ner. I'd love to hear your feedback — Get in touch via DM or support@remoterocketship.com
Follow Remote Rocketship on LinkedInFollow Remote Rocketship on InstagramFollow Remote Rocketship on FacebookFollow Remote Rocketship on TikTok