Operations & data analyst co-op

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

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

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

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

• 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

• 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

• 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

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.

The P&P function is moving toward a…