P&P Data & Operations Analyst

Manulife; Southwestern Ontario; Hybrid; CAD 55,000 - 76,000; Full time

Job summary

Manulife is offering a co-op/intern role in Canada (Ontario) focusing on building a structured data catalog for P&P, mapping vendors, and preparing Power BI inputs. The role emphasizes Excel proficiency, data accuracy, and collaboration across Finance and Operations.

You will gain hands-on experience in data analysis, reporting, and process improvement within a multinational financial services environment.

Qualifications

• Data collection, data cleanup, and structured data design.
• Excel-based analysis and reconciliation.
• Data cataloging and reference table development.
• Power BI / dashboard data preparation.
• Data validation and quality assurance.

Responsibilities

• Support the build-out of a structured P&P data catalog covering applications, vendors, document types, materials, and reporting inputs.
• Help map vendors to applications and document types; identify data gaps and inconsistencies.
• Support inventory and materials mapping where applicable.
• Prepare and clean data inputs for Power BI and broader P&P reporting.
• Support data validation, quality checking, and documentation of assumptions and sources.
• Document manual reporting processes and contribute to improvement and automation ideas.
• Support coordination tracking and fact-gathering across the P&P function.
• Help organize and structure information so it can be reused for reporting, analysis, and operational decision-making.

Skills

Excel proficiency

Attention to detail

Analytical mindset

Communication

Collaboration

Education

Business Analytics

Finance

Data Analytics

Accounting

Operations Management

Business Administration

Information Systems

Industrial Engineering / Process Improvement

Related business/program

Tools

Power BI

Job description

Manulife is offering a co-op/intern role in Canada (Ontario) focusing on building a structured data catalog for P&P, mapping vendors, and preparing Power BI inputs. The role emphasizes Excel proficiency, data accuracy, and collaboration across Finance and Operations.

You will gain hands-on experience in data analysis, reporting, and process improvement within a multinational financial services environment.