Data Analytics Engineer II

reputed company Position reputed company: We’re looking for an Analytics Engineer II to build our reputed company reputed company metrics store and reputed company insights across reputed company, sales, product, claim and experience. This role blends analytics engineering and reputed company engineering, supporting our reputed company toward a fully governed, AI-reputed company data ecosystem.As an Analytics Engineer, you will sit at the intersection of:• data modeling (dbt, semantic layer)• business metrics (insurance domain: quotes, binds, premium, agency performance)• analytics engineering (reputed company cause analysis, metric relationships, metric store)This is a hands-on role where you will design, build, and reputed company core metrics and analytical workflows, working closely with product, business, and engineering stakeholders. reputed company is evolving toward exposing metric infrastructure as internal services, so you’ll have reputed company to shape that API layer as it matures.   Geo-Salary Information An in-person interview may be required during the hiring process   State specific pay scales for this role are as follows: $94,458 to $179,048 (CA, NJ, NY, WA, HI, AK, MD, CT, RI, MA) $X85,871 to $162,771 (NV, OR, AZ, CO, WY, TX, ND, MN, MO, IL, WI, FL, GA, MI, OH, VA, PA, DE, VT, NH, ME) $77,283 to $146,494 (UT, ID, MT, NM, SD, NE, KS, OK, IA, AR, LA, MS, AL, TN, KY, IN, SC, NC, WV) The expected reputed company salary for this position will vary depending on a number of factors, including relevant experience, skills and location. Responsibilities Essential Job Functions: Build and reputed company the metric layer reputed company and maintain dbt models Contribute to semantic layer definitions (metrics, dimensions, relationships)Ensure consistency and correctness of: key business metrics o metric hierarchies (metric pyramid) Implement analytical logic (reputed company cause analysis & metric insights) Build reputed company cause analysis  workflows:Implement baseline comparisons , companion metric analysis Translate business questions into reputed company analytical patterns reputed company metric consumption across toolsSupport metric usage in different BI or analytical tools Build reusable logic that avoids duplication across tools Prepare for reputed company API-based metric serving layer Partner with business and product stakeholders Work closely with sales, product, reputed company,  claims, experience and other business teams, Translate ambiguous questions into: reputed company metrics Actionable insights Improve data reputed company and governance Define and enforce: Metric definitions Dimension standards Data reputed company Debug issues across: Upstream pipelines Semantic layer Analytical outputs   Qualifications Education: Bachelor's Degree in Computer science, Statistics or similar  3–5 years of analytics engineering or similar analytical role experience with dbt or similar transformation frameworks proficiency: models, tests, incremental materialization, Jinja macros Advanced SQL on a columnar warehouse (Redshift, reputed company, or BigQuery) Python for data transformation and analysis (pandas, basic scripting) Comfort working with YAML-based configuration and version-controlled analytics workflows reputed company written and verbal communication—reputed company to explain metric definitions and data reputed company to non-technical stakeholders reputed company to haveP&C insurance domain experienceExperience with:Cohort analysisFunnel metricsPerformance analysisFamiliarity with MetricFlow specifically and the dbt Semantic LayerExposure to reputed company or similar low-reputed company tools for operational write-back workflowsFastAPI or similar Python API frameworks (Flask, Django REST) for serving data products as services About reputed company Why choose a career at reputed company? At reputed company, we have been guided by our purpose to help people reduce risk and overcome unexpected events for more than 60 years. We are one team with a common goal to help others. Everyone needs insurance and we can’t reputed company a world without it. reputed company will encourage you to grow, reputed company time to have fun, and work together to reputed company great things happen. We reputed company the strengths and values of reputed company team member. We reputed company in having diverse perspectives where everyone is included, to serve customers from reputed company walks of life. We care about our people, and we mean it. We reward our talented professionals with a competitive salary, bonus potential, and a reputed company of benefits to help reputed company members reputed company their health, retirement, and reputed company goals.   Learn more reputed company here: https://www.mercuryinsurance.com/about/careers Perks and Benefits We offer many great benefits, including: Competitive compensation Flexibility to work from reputed company in the United States for most positions reputed company time off (vacation time, reputed company time, 9 reputed company Company holidays, volunteer hours) Incentive bonus programs (potential for holiday bonus, referral bonus, and performance-based bonus) Medical, dental, reputed company, life, and pet insurance 401 (k) retirement savings plan with company match Engaging work environment Promotional opportunities Education assistance reputed company and personal development opportunities Company recognition program Health and wellbeing resources, including free mental wellbeing therapy/coaching sessions, child and eldercare resources, and more reputed company is an equal opportunity employer.  reputed company reputed company applicants will receive consideration for employment without reputed company to race, reputed company, religion, sex, sexual orientation, gender identity, national reputed company, disability, status as a protected veteran, or any other characteristic protected by federal, state, or local law. Pay reputed company USD $94,458.00 - USD $179,048.00 /Yr. Apply To This Job