Business Analytics Specialist

Manulife; Southwestern Ontario; Hybrid; CAD 83,000 - 134,000; Full time

Job summary

A leading financial services provider in Southwestern Ontario is seeking a Business Analytics Specialist to drive data-driven solutions within the Group Benefits organization. The role involves collaborating with Agile teams and transitioning data operations to Azure Databricks and Power BI. Candidates should have over 3 years of experience in analytics, advanced SQL skills, and strong communication abilities. This position offers a hybrid work environment and a competitive salary range between CAD 83,400 and CAD 133,400.

Benefits

Health and dental benefits

Short and long-term disability coverage

Generous paid time off program

Qualifications

• 3+ years of experience in a Business Analytics / Business Analyst role.
• Experience with SSIS and SSRS support and development.
• Capable of adapting quickly, managing multiple demands & competing priorities.

Responsibilities

• Become a data domain subject matter expert.
• Investigate & analyze new data sources and their connection to existing models.
• Collaborate within Agile Kanban squads to deliver the Data Value Stream roadmap.

Skills

Analytical mind with problem-solving aptitude

Advanced proficiency in SQL

Strong communication skills

Education

University/College in computer science, information technology, math, or related field

Tools

Microsoft BI stack

SSIS

SSRS

Azure Databricks

Job description

The Data Value Stream team is responsible for providing accurate data and business analytics across the Group Benefits organization and our customers. The Business Analytics Specialist will play a key role in defining data‑driven solutions to tackle business area problems, tracking down & understanding new data sources, while having the opportunity to collaborate with members of Agile Kanban Business Analytics squads. They will support and transition from SQL Server data technologies, including Stored Procedures, SSIS packages, and SSRS reports to Azure Databricks Platform and Power BI reporting. The Business Analytics Specialist will be accountable for understanding the business across Group Benefits, translating requirements into agile stories and data views. They will be actively engaged in our analytics development cycle from an ideation/requirements/testing perspective, while also investigating data issues and answering data inquiries from our business partners.

Position Responsibilities:

• Become a data domain subject matter expert while expanding Group Benefits business acumen
• Investigate & analyze new data sources and how they connect to existing data models
• Collaborate/coordinate within Agile Kanban squads and business partners to deliver the Data Value Stream roadmap
• Support steady‑state Microsoft SQL Server datasets, SSIS packages and SSRS reports
• Transition data and reporting to Azure Databricks/Power BI reports
• Develop and update technical documentation
• Support adhoc requests for data & visualization when required

Required Qualifications:

• 3+ years of experience in a Business Analytics / Business Analyst role
• University/College in computer science, information technology, math, or a related field
• Advanced proficiency in SQL
• Experience with SSIS and SSRS support and development
• Experience with Microsoft BI stack (including Analysis Services, Paginated Reports, Data Gateway, Power Pivot & Azure SQL)
• Analytical mind with a problem‑solving aptitude
• Capable of adapting quickly, managing multiple demands & competing priorities, while delivering to deadlines
• Strong communication skills with the ability to collaborate effectively with cross‑functional teams and stakeholders

Preferred Qualifications:

• Experience and business knowledge in Financial Services and/or Group Benefits is a valuable asset
• Experience with RLS & Embedded Power BI is an asset

When you join our team:

• We’ll empower you to learn and grow the career you want.
• We’ll recognize and support you in a flexible environment where well‑being and inclusion are more than just words.
• As part of our global team, we’ll support you in shaping the future you want to see

#LI-hybrid

About Manulife and John Hancock

Manulife Financial Corporation is a leading international financial services provider, helping people make their decisions easier and lives better. To learn more about us, visit https://www.manulife.com/en/about/our-story.html.

Manulife is an Equal Opportunity Employer

At Manulife/John Hancock, we embrace our diversity. We strive to attract, develop and retain a workforce that is as diverse as the customers we serve and to foster an inclusive work environment that embraces the strength of cultures and individuals. We are committed to fair recruitment, retention, advancement and compensation, and we administer all of our practices and programs without discrimination on the basis of race, ancestry, place of origin, colour, ethnic origin, citizenship, religion or religious beliefs, creed, sex (including pregnancy and pregnancy‑related conditions), sexual orientation, genetic characteristics, veteran status, gender identity, gender expression, age, marital status, family status, disability, or any other ground protected by applicable law.

It is our priority to remove barriers to provide equal access to employment. A Human Resources representative will work with applicants who request a reasonable accommodation during the application process. All information shared during the accommodation request process will be stored and used in a manner that is consistent with applicable laws and Manulife/John Hancock policies. To request a reasonable accommodation in the application process, contact [e-mail].

Referenced Salary Location

Toronto, Ontario

Working Arrangement

Hybrid

Salary range is expected to be between

$83,400.00 CAD - $133,400.00 CAD

If you are applying for this role outside of the primary location, please contact [e-mail] for the salary range for your location. The actual salary will vary depending on local market conditions, geography and relevant job‑related factors such as knowledge, skills, qualifications, experience, and education/training. Employees also have the opportunity to participate in incentive programs and earn incentive compensation tied to business and individual performance.

Manulife offers eligible employees a wide array of customizable benefits, including health, dental, mental health, vision, short‑ and long‑term disability, life and AD&D insurance coverage, adoption/surrogacy and wellness benefits, and employee/family assistance plans. We also offer eligible employees various retirement savings plans (including pension and a global share ownership plan with employer matching contributions) and financial education and counseling resources. Our generous paid time off program in Canada includes holidays, vacation, personal, and sick days, and we offer the full range of statutory leaves of absence. If you are applying for this role in the U.S., please contact [e-mail] for more information about U.S.-specific paid time off provisions.