Data & Reporting Business Analyst

Job Description

Sun Life embraces a hybrid work model that balances in-office collaboration with the flexibility of virtual work. Our team members and leaders are expected to foster connection and teamwork by being present in the office at least 2 days per week.

About the role

The Data & Reporting Analyst is responsible for developing, maintaining, and optimizing reporting solutions that provide actionable insights to business leaders in the Stop Loss Claims team. This role supports data-driven decision making across operations by identifying anomalies, automating manual processes, and enabling business leaders with evidence-based insights to optimize operations and reduce costs.

Responsibilities

• Data Analysis & Insights
• Develops and deploys SQL-based reporting and statistical models using Power Query, VBA, Excel and Python
• Analyze large datasets to identify trends, anomalies, and opportunities for operational improvement
• Support business decision-making through ad hoc analyses and structured reporting
• Translate complex data into clear, actionable insights for leadership
• Reporting & Dashboard Development
• Partners with the COE Reporting team to enhance and improve Stop Loss Claims dashboard
• Ensures data accuracy, dashboard uptime, and data freshness across all reporting systems
• Completes timely reporting and analysis requests with rigorous data quality validation
• Documents methodologies and maintains comprehensive records of reporting processes
• Data Management & Quality
• Validate, cleanse, and maintain data integrity across multiple sources
• Support data governance and ensure adherence to data standards and definitions
• Partner with IT and data teams to resolve data issues and improve data pipelines
• Process Improvement & Automation
• Identify opportunities to automate manual reporting processes and streamline workflows
• Implement data solutions that improve efficiency and reduce redundancy
• Support continuous improvement initiatives through analytics and performance tracking
• Stakeholder Collaboration
• Work closely with business leaders to define reporting needs and requirements
• Provide ongoing support for reporting tools and troubleshoot user issues
• Present findings and recommendations to leadership in a clear and concise manner
• Engage with leadership, IT teams, and business teams to facilitate data interpretation, present evidence-based recommendations, and resolve technical and operational constraints
• Escalate significant data and reporting inaccuracies, anomalies, and strategic requests requiring new data sources or system integration to management

Requirements

• Bachelor's degree in a quantitative field (Computer Science, Data Science, Statistics, Mathematics, Engineering, Economics, Actuarial Science, or Business Analytics) OR equivalent professional experience demonstrating competency in data analysis and analytics
• 2–3 years of experience in data analysis, business intelligence, or analytics
• Demonstrated proficiency with SQL including query optimization, complex joins, and performance tuning
• Proficiency with at least one programming language (Python, R, or similar)
• Experience building dashboards or reports using visualization tools (Tableau, Excel)
• Familiarity with statistical analysis and forecasting concepts
• Advanced Excel skills including complex formulas, pivot tables, and data manipulation
• Expertise in data visualization and self-service dashboard development
• Knowledge of statistical foundations including forecasting methodologies, regression, and time-series analysis

Qualifications

• Preferred: Insurance and claims operations business acumen
• Understanding of inventory management and demand planning principles
• Ability to translate technical findings for non-technical stakeholders
• Strong analytical thinking and problem-solving capabilities
• Attention to detail and commitment to data accuracy
• Effective communication and stakeholder collaboration skills

Skills

• SQL
• Programming languages (Python, R, or similar)
• Data visualization tools (Tableau, Excel)
• Statistical analysis and forecasting concepts
• Data management and quality assurance
• Process improvement and automation
• Stakeholder collaboration and communication

Benefits

At our company, we are committed to pay transparency and equity. The salary range for this role is competitive nationwide, and we strive to ensure that compensation is fair and equitable. Your actual base salary will be determined based on your unique skills, qualifications, experience, education, and geographic location. In addition to your base salary, this position is eligible for a discretionary annual incentive award based on your individual performance as well as the overall performance of the business. We are dedicated to creating a work environment where everyone is rewarded for their contributions.

Pay

Salary Range: $60,400 - $90,600

Schedule

Hybrid work model that balances in-office collaboration with the flexibility of virtual work. Our team members and leaders are expected to be present in the office at least 2 days per week.