Data Analytics Engineer II

About this role

Position Summary
We’re looking for an Analytics Engineer II to build our next-generation enterprise metrics store and enable insights across underwriting, sales, product, claim and experience. This role blends analytics engineering and prompt engineering, supporting our journey toward a fully governed, AI-ready 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 (root cause analysis, metric relationships, metric store)

This is a hands-on role where you will design, build, and scale core metrics and analytical workflows, working closely with product, business, and engineering stakeholders. The team is evolving toward exposing metric infrastructure as internal services, so you’ll have the opportunity 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 base salary for this position will vary depending on a number of factors, including relevant experience, skills and location.


Responsibilities
Essential Job Functions:

• Build and scale the metric layer
• Develop 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 (root cause analysis & metric insights)
• Build root cause analysis workflows: Implement baseline comparisons , companion metric analysis
• Transl...