01 Nov
|
Manulife/John Hancock
|
London
01 Nov
Manulife/John Hancock
London
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.
- Robust 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.
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
Expected to be between: $54,600.00 CAD - $76,050 CAD
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.
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 fost
📌 Operations & Data Analyst Co-op (8 Months) (London)
🏢 Manulife/John Hancock
📍 London