Reporting Analyst

Manulife; Waterloo; Hybrid; CAD 61,000 - 103,000; Full time

Job summary

Manulife seeks a Reporting Analyst to leverage insurance data for strategic insights and sales reporting. The role emphasizes developing analytics deliverables and requires a solid background in Business Intelligence tools. Join a diverse environment that promotes personal and professional growth.

Benefits

Customizable health and dental benefits

Retirement savings plans with employer matching

Paid time off program including holidays and sick days

Employee assistance programs

Qualifications

• 2 years’ experience in data analysis or reporting.
• Exceptional query knowledge required.
• Strong team player with high commitment to quality work.

Responsibilities

• Complete sales reporting for the individual insurance business.
• Conduct ongoing needs assessment interviews to refine reporting.
• Develop ad hoc solutions based on business consultations.

Skills

SQL

Excel

Business Intelligence

Communication

Education

University degree in Business, Economics, or Mathematics

Tools

Power BI

Salesforce

MS Office

Job description

This is a unique position at Manulife and 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 the businesses. This role will appeal to individuals with a real passion for discovering insights and solving problems using data.

Reporting into Field Compensation and Sales Reporting umbrella, the Reporting Analyst has these areas of responsibility: Complete sales reporting for our individual insurance business, Develops and generates insights for the Insurance Leadership and Sales teams. Provide in-depth analysis of data used for strategy and sales initiatives. The Reporting Analyst provides insights and analysis specifically in support of product development, digital transformation, underwriting and sales. Understanding of respective business strategies is critical in order to produce relevant and meaningful analysis and insights to support business goals and objectives.

Position Responsibilities:

Key Responsibilities

Development of data driven insights and analytics deliverables

• 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.

• Following solutions standards will be monitored to ensure expected customer satisfaction:

  • Relevancy, Accuracy, Timeliness, Visual Appeal, Compliant with privacy and confidentiality guidelines

• Reports will be used for the following purposes:

  • Strategic planning and goal setting, Tactical decisions, Recognition

  • Conduct ongoing needs assessment interviews with customers to determine reporting requirements and test/validate all developed solutions. Look for opportunities to streamline and consolidate reporting effectiveness.

  • Additional functions include building, executing and maintaining queries and spreadsheets.

  • Act as a central information resource and liaison for internal and external business partners for sales and MIS.

  • A “roll up your sleeves” attitude and willingness to perform tasks with a range of difficulty from routine tasks to preparing analysis for senior management.

  • This role is required to participate in projects that support new data projects.

  • Transfer knowledge to the other teams and departments through coaching/consulting.

  • Review requirements with the requestor to ensure a full understanding of the needs to build the solution in an accurate and timely manner. Negotiate delivery dates with Clients based on the complexity of the requirements.

Provide in-depth analysis of data used for strategy and initiatives

• Prepare in-depth analysis and commentary for major initiatives such as:

  • Trend analysis and prediction, Segmentation and personas, and correlations

  • This role will need to 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

  • Partners 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.

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.

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

$61,350.00 CAD - $102,250.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.