Operations & Data Analyst Co-op (8 Months)

Manulife John Hancock; Southwestern Ontario; On-site; CAD 55,000 - 76,000; Full time

Job summary

Manulife John Hancock offers a student internship focused on building a structured P&P data catalog, mapping vendors to applications and document types, and preparing data for Power BI reporting.

You will work with multiple data sources, validate data, and document assumptions, aiming to improve reporting and drive operational insights within Finance and Operations.

Qualifications

• Strong Excel skills and comfort with structured data.
• Exposure to Power BI or similar dashboard/reporting tools preferred.

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

Power BI

Data analysis

Attention to detail

Education

3rd/4th year undergraduate (Co-op/Intern)

Tools

Power BI

Data catalogs

Job description

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

Target Student Profile

Year of study: 3rd or 4th year undergraduate (or equivalent co‑op / intern student).

Preferred programs: Business Analytics, Finance, Data Analytics, Accounting, Operations Management, Business Administration, Information Systems, Industrial Engineering / Process Improvement, Related business, analytics, or operations program

Strong Excel skills and comfort working with structured data.

Strong attention to detail and analytical mindset.

Interest in finance, operations, reporting, analytics, and process improvement.

Exposure to Power BI or similar dashboard / reporting tools is preferred but not mandatory.

Non-Negotiables

• Strong Microsoft Excel skills.
• Comfort working with multiple data sources, including vendor data, invoices, and operational data.
• Strong attention to detail and ability to validate accuracy of data.
• Ability to maintain confidentiality and follow internal data-handling standards.
• Strong communication skills, including a willingness to ask clarifying questions.

Supervision and Coaching Model

Primary hiring manager and day-to-day supervisor: Tadios Abebe, Manager, P&P Financial Operations.

Secondary support and exposure: Across P&P leadership, including: Production Operations, Vendor & Production Operations, Vendor Governance, Head of P&P

Aligned with Manulife's intern / co‑op program expectations, including coaching, structured feedback, performance evaluation, and student development.

Regular check‑ins with the manager to support development and progress.

Skills and Competencies to Be Developed

Technical and analytical

• 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

Business and operational

• Understanding of Print & Post operations and vendor-supported production processes
• Exposure to financial reporting, cost tracking, and invoice validation concepts
• Process documentation and issue identification

Professional and soft skills

• Stakeholder communication
• Critical thinking and asking effective clarifying questions
• Documentation discipline
• Time management and prioritization
• Working with ambiguity
• Collaboration across Finance, Operations, Vendor Governance, and business partners

Expected Outcomes / Deliverables

By the end of the term, the student should produce:

• A structured P&P data catalog covering applications, vendors, document types, materials, and key reporting inputs.
• Vendor-to-application and vendor-to-document mapping tables .
• Inventory / material mapping tables (where applicable).
• Cleaned, validated data files that can support Power BI reporting and financial analysis.
• A documented summary of data gaps, naming inconsistencies, missing fields, and validation issues.
• A summary of manual reporting processes and recommended areas for simplification or automation.
• A short final summary or presentation of work completed, findings, issues, and recommendations.

Why This Role Exists

The P&P function is moving toward a stronger, more structured operating model for 2027, including better financial reporting, vendor visibility, Power BI reporting, and improved data quality. This role provides meaningful, hands‑on support to help convert fragmented data into structured, usable information that can be relied on for reporting, reconciliation, vendor management, and operational decision‑making.

The role also gives the student practical exposure to finance, operations, vendor management, and transformation work in a real‑world environment.

Salary range is expected to be between:

$54,600.00 CAD - $76,050 CAD

The role being advertised is an existing vacancy.

We use data and analytics technologies, such as artificial intelligence (AI), and automated processing tools, to analyze and process the information you provide to us or third parties in the application process. For more information, please refer to our personal information collection statement .

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