Abett is building infrastructure for employee benefits optimization and seeks a Senior Analytics Engineer to enhance their Benefits Data Platform. The role involves designing Power BI dashboards, developing data models, and conducting analyses with healthcare and benefits data.
Responsibilities:
- Design, build and improve Power BI dashboards that answer recurring and ad hoc strategic questions
- Develop and extend the data models that power these dashboards and analyses, utilizing dbt within a Microsoft Fabric environment
- Build and maintain pipelines that populate these data models
- Validate data quality and accuracy across claims, eligibility, clinical, HR, and engagement data, investigating and resolving discrepancies
- Support custom and ad hoc analyses on strategic benefits questions
Requirements:
- 6+ years experience in analytics engineering, data analysis, business intelligence or similar roles
- 6+ years experience with SQL and Python
- 3+ years experience working with benefits and healthcare data, including medical claims, eligibility, and pharmacy data sets
- Demonstrated experience conducting analyses and/or building dashboards in benefits-related contexts
- Demonstrated experience engaging directly with clients in a professional, structured way, including gathering requirements, setting expectations, and communicating technical findings clearly
- Ability to work independently in ambiguous, evolving environments
- Proven ability to troubleshoot and resolve complex data quality issues
- Experience working with Power BI and Microsoft Fabric
- Familiarity with Tuva Project
- Familiarity with common risk scoring and benchmarking models