Business Analytics Consultant

Business Analytics Consultant

In today’s rapidly evolving financial services landscape, operational resilience is paramount. It encompasses the ability of an organization to anticipate, prepare for, respond to, and adapt to incremental change and sudden disruptions. As financial institutions face increasing threats from cyber incidents, natural disasters, and regulatory changes, maintaining operational resilience is crucial to safeguarding critical operations and ensuring business continuity.

We are seeking an individual contributor to support the Operational Resilience program team residing in our Toronto office for the following responsibilities.

This job description does not represent a comprehensive listing of job duties that are required of the employee performing this role. We reserve the right to change duties or assign additional duties at any time with or without notice.

Position Responsibilities

• Perform various levels of data analysis, data clean-up, and data collection to support the production of pre-established Key Performance Indicators (KPIs) or Key Risk Indicators (KRIs).
• Participate in process improvement opportunities and support program management teams in head office on data ingestion, clean-up, and mapping (e.g., data analysis, data clean-up, validation, creating and maintenance of reports and dashboards).
• Build and maintain dashboard reporting of pre-established KPIs and KRIs across different workstreams.
• Research and document business issues involving workflow procedures and processes as directed by program management teams.
• Analyze data and work with management to develop creative solutions.
• Coordinate recommended process changes and enhancements.
• Assist in the generation of monthly, quarterly, or ad-hoc reports, ensuring accuracy in metrics being reported.
• Support data governance initiatives by ensuring compliance with data quality standards, privacy regulations, and internal policies.
• Develop and maintain documentation for data sources, data definitions, and reporting methodologies to ensure transparency and reproducibility.
• Participate in stakeholder meetings to present findings, gather feedback, and align analytics efforts with business goals.

Required Qualifications

• Knowledgeable in financial services and insurance with 5-7 years of business experience, including progressive business analysis experience.
• Proficient in Power BI and Power Platform for creating interactive dashboards, automating workflows, and developing custom applications.
• Skilled in dashboard design with a focus on UI/UX.
• Experience in big data analysis, including the use of Azure and Databricks to process and interpret large datasets.
• Knowledgeable in database schemas, data modeling, and EDL processes.
• Strong organization, communication, and interpersonal skills.
• Strong reporting skills, with attention to detail and ability to work under tight deadlines with accuracy.
• Highly organized individual with strong time management and organizational skills.
• Self-starter with the ability to work independently.
• Excellent collaborative and relationship building skills; showing tact and diplomacy in dealing with others.
• Ability to learn quickly and be comfortable with adjusting to ad-hoc changes in workflow.
• High-level written and verbal communication skills; able to clearly and accurately translate business requirements into non-technical and lay terms and in communicating insights to team members and management.
• Understanding of data governance and control concepts (e.g., data retention, access management).

Preferred Qualifications

• Skilled in translating complex issues into actionable business solutions through data visualization, analytical insights, process optimization, and compelling presentations.
• Strong technical skills on analytics and data transformation tools.
• Intermediate to advanced Power BI, Power Query, Excel, SQL, and Power Automate/VBA.
• Basic knowledge and working experience in using Jira, Power Apps, and Python.
• Thorough understanding of data governance and control concepts (e.g., risk mitigation concepts, access right control).
• High-level written and verbal communication skills; able to clearly and accurately translate business requirements into non-technical and lay terms and in communicating insights to team members and management.

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 recruitment@manulife.com.

Working Arrangement

Hybrid

Key skills/competency

• Data Analysis
• Power BI
• Power Platform
• Dashboard Design
• Azure
• Databricks
• SQL
• Data Governance
• Financial Services
• Process Improvement