[Remote] Data Analytics Engineer II

Note: The job is a remote job and is open to candidates in USA. Mercury Insurance is a company dedicated to helping people manage risk and overcome unexpected events. They are seeking an Analytics Engineer II to build and scale the enterprise metrics store, enabling insights across various business functions such as underwriting and sales. This role involves data modeling, analytics engineering, and collaboration with product and business stakeholders to ensure high-quality data governance and metric definitions.ResponsibilitiesBuild and scale the metric layerDevelop and maintain dbt modelsContribute to semantic layer definitions (metrics, dimensions, relationships)Ensure consistency and correctness of: key business metrics o metric hierarchies (metric pyramid)Implement analytical logic (root cause analysis & metric insights)Build root cause analysis workflows:Implement baseline comparisons , companion metric analysisTranslate business questions into scalable analytical patternsEnable metric consumption across toolsSupport metric usage in different BI or analytical toolsBuild reusable logic that avoids duplication across toolsPrepare for future API-based metric serving layerPartner with business and product stakeholdersWork closely with sales, product, underwriting, claims, experience and other business teams, Translate ambiguous questions into:Structured metricsActionable insightsImprove data quality and governanceDefine and enforce:Metric definitionsDimension standardsData contractsDebug issues across:Upstream pipelinesSemantic layerAnalytical outputsSkillsBachelor's Degree in Computer science, Statistics or similar3–5 years of analytics engineering or similar analytical role experience with dbt or similar transformation frameworks proficiency: models, tests, incremental materialization, Jinja macrosAdvanced SQL on a columnar warehouse (Redshift, Snowflake, or BigQuery)Python for data transformation and analysis (pandas, basic scripting)Comfort working with YAML-based configuration and version-controlled analytics workflowsClear written and verbal communication—able to explain metric definitions and data lineage to non-technical stakeholdersP&C insurance domain experienceExperience with: Cohort analysisFunnel metricsPerformance analysisFamiliarity with MetricFlow specifically and the dbt Semantic LayerExposure to Retool or similar low-code tools for operational write-back workflowsFastAPI or similar Python API frameworks (Flask, Django REST) for serving data products as servicesBenefitsCompetitive compensationFlexibility to work from anywhere in the United States for most positionsPaid 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 insurance401 (k) retirement savings plan with company matchEngaging work environmentPromotional opportunitiesEducation assistanceProfessional and personal development opportunitiesCompany recognition programHealth and wellbeing resources, including free mental wellbeing therapy/coaching sessions, child and eldercare resources, and moreCompany OverviewMercury Insurance has offered quality insurance for personal auto insurance to homeowners insurance to mechanical breakdown protection. It was founded in 1962, and is headquartered in Los Angeles, California, USA, with a workforce of 5001-10000 employees. Its website is http://www.mercuryinsurance.com.Company H1B SponsorshipMercury Insurance has a track record of offering H1B sponsorships, with 7 in 2026, 22 in 2025, 23 in 2024, 14 in 2023, 15 in 2022, 8 in 2021, 13 in 2020. Please note that this does not guarantee sponsorship for this specific role.