Reporting Analyst

Manulife; Southwestern Ontario; Hybrid; CAD 61,000 - 103,000; Full time

Job summary

A leading financial services provider is seeking a Reporting Analyst in Southwestern Ontario, Canada. The role involves analyzing insurance data, creating reports, and delivering insights to support strategic initiatives. Ideal candidates will have a university degree, 2 years of experience, strong skills in SQL and Power BI, excellent communication skills, and a commitment to quality work. The position offers a hybrid work arrangement and a comprehensive benefits package, including customizable health, dental and wellness benefits.

Benefits

Hybrid working arrangement

Health and wellness benefits

Generous paid time off program

Qualifications

• 2 years’ experience in data analysis or reporting.
• Exceptional query knowledge and experience with Business Intelligence tools.

Responsibilities

• Deliver effective analytics for management decision-making.
• Conduct needs assessments to understand reporting requirements.
• Build and maintain queries for data extraction.

Skills

SQL

Excel

Access

MS Office

Power BI

Salesforce

Communication

Team collaboration

Education

University degree in Business, Economics, or Mathematics

Job description

Overview

This is a unique position at Manulife in the financial industry where the incumbent will have access to insurance data with the mandate of presenting and analyzing the data to find new opportunities for businesses. The role will appeal to individuals with a real passion for discovering insights and solving problems using data. Reporting into the Field Compensation and Sales Reporting umbrella, the Reporting Analyst is responsible for completing sales reporting for our individual insurance business, developing and generating insights for the Insurance Leadership and Sales teams, and providing in‑depth analysis of data used for strategy and sales initiatives to support product development, digital transformation, underwriting and sales.

Position Responsibilities

• Consult, prepare and distribute effective and concise analytics deliverables for all levels of management in support of business objectives using various Business Intelligence tools.
• Develop ad‑hoc value‑added solutions based on consulting with management, internal and external business partners.
• Ensure solutions meet customer satisfaction standards for relevancy, accuracy, timeliness, visual appeal and compliance with privacy and confidentiality guidelines.
• Produce reports used for strategic planning and goal setting, tactical decisions and recognition.
• Conduct ongoing needs assessment interviews with customers to determine reporting requirements and test and validate all developed solutions, looking for opportunities to streamline and consolidate reporting effectiveness.
• Build, execute and maintain queries and spreadsheets; act as a central information resource and liaison for internal and external business partners for sales and MIS.
• Take on a “roll up your sleeves” attitude with willingness to perform tasks across a range of difficulty from routine tasks to preparing analysis for senior management.
• Participate in projects that support new data projects and transfer knowledge to other teams and departments through coaching and consulting.
• Review requirements with the requester to ensure a full understanding of the needs for an accurate and timely solution and negotiate delivery dates with clients based on complexity of the requirements.
• Prepare in‑depth analysis and commentary for major initiatives such as trend analysis and prediction, segmentation and personas, and correlations.
• Recognize and extract relevant information required for analysis and reporting; act as a key point of contact with business to bridge and translate business requirements to analytics and reporting needs; partner with other internal divisions (e.g. Finance, Product, Marketing Research, Strategy).

Required Qualifications

• University degree in Business, Economics, or Mathematics.
• 2 years’ experience.
• Exceptional query knowledge (SQL, Excel, Access, MS Office, etc.).
• Experience working with Business Intelligence tools (e.g. Power BI).
• Knowledge of Salesforce is required (Reports and Dashboards, DataLoader).
• Proven excellence in communication – both verbal and written.
• Solid understanding of the upstream admin systems and downstream impacts to other areas.
• Strong team player with a high commitment to quality work and service.

Preferred Qualifications

• Excellent customer service and organizational skills.
• Highly motivated, able to work independently and handle high‑volume tasks.
• Skilled in collaborating with senior management and developing positive internal relationships.
• Flexible and creative problem solver, continuously seeking improvements.
• Adapts to new technologies, designs effective reports, and maintains integrity in service.

Benefits

• Hybrid working arrangement.
• Salary range: $61,350.00 – $102,250.00 CAD.
• 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, employee/family assistance plans, pension and global share ownership plan with employer matching contributions, and financial education and counseling resources.
• Generous paid time off program in Canada with statutory leaves of absence.

About Manulife and John Hancock

Manulife Financial Corporation is a leading international financial services provider, helping people make their decisions easier and lives better.

Equal Opportunity Employer

Manulife and John Hancock embrace diversity and are committed to fair recruitment, retention, advancement and compensation without discrimination on the basis of any protected characteristic. All reasonable accommodation requests are handled in accordance with applicable laws and company policies.

Contact for Salary and Incentives

For salary range and incentive compensation details outside of Toronto, Ontario, contact [e-mail].