Sr. Business Intelligence Analyst, DentaQuest

Position Overview

Sun Life U.S. is one of the largest providers of employee and government benefits, helping approximately 50 million Americans access the care and coverage they need. Through employers, industry partners, and government programs, they offer a portfolio of benefits and services including dental, vision, disability, absence management, life, supplemental health, medical stop‐loss insurance, and healthcare navigation. With more than 6,400 employees and associates across partner dental practices nationwide, Sun Life is dedicated to making life brighter for its customers, partners, and communities. Visit our website to discover more.

Sun Life embraces a hybrid work model that balances in‐office collaboration with virtual work flexibility. Team members and leaders are expected to be present in the office at least 2 days per week.

We’re looking for a Senior Business Intelligence Analyst with strong data engineering skills who is eager to expand into data analysis. This role sits at the intersection of data infrastructure and business insight—roughly 50% building robust data pipelines and infrastructure, and 50% transforming that data into actionable intelligence for a growing healthcare organization. If you thrive in both structured technical environments and open‐ended analytical challenges, this opportunity is for you.

Salary: $97,400 - $146,100

Key Responsibilities

• Build and maintain data pipelines that extract, transform, and load data from diverse sources including databases, APIs, XML, and flat files.
• Develop data models to support analytics and decision-making across departments.
• Design and deliver reports, dashboards, and visualizations using a BI visualization tool.
• Collaborate with business stakeholders to understand needs, gather requirements, and deliver insights.
• Monitor and enhance the business intelligence infrastructure while identifying opportunities for automation and optimization.
• Support data governance and data auditing efforts.
• Present findings and recommendations to stakeholders, including senior leadership.
• Contribute to continuous improvement by evaluating new tools, methods, and approaches.

Required Qualifications

• Bachelor’s degree in Information Systems, Computer Science, or a quantitative field (Mathematics, Economics, Finance), or equivalent experience.
• 3 years of experience in business intelligence, data engineering, or data analysis.
• Proficiency in SQL and working with relational databases.
• Experience with business intelligence databases, pipelines, and infrastructure.
• Strong communication skills with the ability to translate data into business impact.
• Demonstrated capability to work in a hybrid work environment.
• Willingness to travel occasionally.
• Authorization to work in the U.S.

Preferred Qualifications

• Comfortable with cloud infrastructure (Azure preferred).
• Experience in healthcare or dental analytics.
• Familiarity with scripting or analytical languages (e.g., R or Python).

Benefits & Perks

• Comprehensive benefits including generous vacation and sick time.
• Market-leading paid family, parental, and adoption leave.
• Medical coverage, company-paid life and AD&D insurance, disability programs, and a partially paid sabbatical program.
• 401(k) employer match, stock purchase options, and an employer-funded retirement account.
• A flexible, inclusive, and collaborative work environment that supports career growth.
• Recognized as a Proudly Great Place to Work® and acknowledged among top employers.