Responsibilities
- Build and scale the metric layer
- Develop and maintain dbt models
- Contribute to semantic layer definitions including metrics, dimensions, and relationships
- Ensure consistency and correctness of key business metrics and metric hierarchies, such as the metric pyramid
- Implement analytical logic for root cause analysis and metric insights
- Build root cause analysis workflows by implementing baseline comparisons and companion metric analysis
- Translate business questions into scalable analytical patterns
- Enable metric consumption across various tools
- Support metric usage in different BI or analytical tools
- Build reusable logic that avoids duplication across tools
- Prepare for a future API-based metric serving layer
- Partner with business and product stakeholders
- Work closely with sales, product, underwriting, claims, experience, and other business teams
- Translate ambiguous questions into structured metrics and actionable insights
- Improve data quality and governance
- Define and enforce metric definitions, dimension standards, and data contracts
- Debug issues across upstream pipelines, semantic layer, and analytical outputs
Requirements
- Bachelor's Degree in Computer Science, Statistics, or a similar field
- 3–5 years of analytics engineering or similar analytical role experience
- Experience with dbt or similar transformation frameworks including models, tests, incremental materialization, and Jinja macros
- Advanced SQL on a columnar warehouse such as Redshift, Snowflake, or BigQuery
- Python for data transformation and analysis, including pandas and basic scripting
- Comfort working with YAML-based configuration and version-controlled analytics workflows
- Clear written and verbal communication, able to explain metric definitions and data lineage to non-technical stakeholders
Nice to Have
- P&C insurance domain experience
- Experience with cohort analysis, funnel metrics, and performance analysis
- Familiarity with MetricFlow specifically and the dbt Semantic Layer
- Exposure to Retool or similar low-code tools for operational write-back workflows
- FastAPI or similar Python API frameworks such as Flask or Django REST for serving data products as services
Compensation
Competitive compensation, paid time off including vacation, sick time, 9 paid company holidays, and volunteer hours, incentive bonus programs such as holiday, referral, and performance-based bonuses, 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
Work Arrangement
Flexibility to work from anywhere in the United States for most positions
Other
- Flexibility to work from anywhere in the United States for most positions
- Competitive compensation
- 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
- An in-person interview may be required during the hiring process
