Sr. Manager, Performance Systems

Healthcare of Ontario Pension Plan Trust Fund Company; Toronto; On-site; CAD 110,000 - 150,000; Full time

Benefits offered by this job

100% company-paid extended health and

Dental benefits and fertility/mental‑h

LinkedIn Learning and growth programs

Job summary

Healthcare of Ontario Pension Plan (HOOPP) seeks a senior technical lead to operate HOOPP's P&L system (Ortec Pearl), manage data warehousing, and deliver automated investment reporting. You will work with IT, front, middle and back offices to ensure data quality and scalable analytics.

The role requires deep investment data understanding, strong SQL and BI skills, and mentoring ability within the Performance Systems team. Office-based in Toronto with inclusion and learning opportunities.

Qualifications

• 7+ years in a business-focused technical role in investment industry.
• 5+ years configuring middle office systems with SQL and databases.
• Experience with BI tools and reporting; strong analytical skills.

Responsibilities

• Lead operation of HOOPP's P&L system (Ortec Pearl) across environments.
• Coordinate data flows, warehousing, and automated reporting solutions.
• Validate calculations and ensure data accuracy for reports.
• Mentor Analysts within the Performance Systems team.
• Collaborate with IT, Front/Middle/Back Offices on cross-functional projects.
• Support data architecture decisions related to investment reporting.

Skills

SQL proficiency

Data warehousing

Python scripting

Qlik / Power BI

ETL / data quality

Stakeholder communication

Education

Undergraduate degree in technical or related fields

Post graduate degree asset

Tools

Snowflake

Oracle

SAP Hana

Job description

Why you'll love working here:

High-performance, people-focused culture our commitment that equity, diversity, and inclusion are fundamental to our work environment and business success, which helps employees feel valued and empowered to be their authentic selves learning and development initiatives, including workshops, Speaker Series events and access to LinkedIn Learning, that support employees' career growth membership in HOOPP's world class defined benefit pension plan, which can serve as an important part of your retirement security competitive, 100% company-paid extended health and dental benefits for permanent employees, including coverage supporting our team's diversity and mental health (e.g., gender affirmation, fertility and drug treatment, psychological support benefits of $2,500 per year, parental leave top-up, and a health spending account). optional post-retirement health and dental benefits subsidized at 50% yoga classes, meditation workshops, nutritional consultations, and wellness seminars the opportunity to make a difference and help take care of those who care for us, by providing a financially secure retirement for Ontario healthcare workers

Job Summary

Reporting to the Director, Investment Performance System and Compliance Solutions, this position is responsible for leading the operation of HOOPP's P&L system (Ortec Pearl), associated data flows and warehousing, and solutioning for automated and ad-hoc investment reporting. This role will require a detailed understanding of HOOPP's investment products & strategies, trade flow and data lifecycle processes as well as underlying systems, data structures and IT architecture. The ability to configure and reconcile production systems, navigate data warehouses, and code reporting / automations will be critical. While the focus of this role is on the Performance System and associated processes, it will also have broader responsibilities related to the larger Investment Reporting & Analytics group. The individual will have considerable interaction with various departments within HOOPP's IT, Front, Middle, and Back Offices and will be assisting on cross-functional projects and solutioning (investment reporting, automations, data analysis, modeling, validation, and QA).

What you will do:

• Steward Investment Performance data lifecycle and warehousing. Ensure data integrity and processes are optimized for official release to organization through Enterprise Data Platform.
• Lead the configuration, maintenance, troubleshooting, and upgrades of P&L system across multiple environments. Recommend and implement optimizations and solutions.
• Verify system logic and work directly with vendor.
• Lead analysis, integrations, and testing of new products / functionality as part of cross functional teams e.g. operational readiness for new investments / strategies, testing and validation of upstream and downstream changes.
• Build and maintain cross-functional reports and automation solutions using a range of reporting tools and technologies like Qlik, Python, Snowflake, Excel, Power BI, SAP Hana.
• Develop a deep understanding of the Portfolio and Deal Structures within HOOPP including all the securities that make up those strategies.
• Contribute to the decisions related to HOOPP's Data Architecture as it relates to Investment Reporting, Data Governance & Valuations.
• Analyze, monitor and confirm the methodologies and the accuracy of the calculations impacting reports developed and/or supported by the team.
• Design and implement automated solutions used for data quality monitoring, evaluation, and exception-based handling, and otherwise manage risk associated with data quality and governance.
• Coordinate with other teams the completion of various projects, capture and document requirements, communicate them effectively and precisely to implementation teams (IT, IDM), advise on preferred solutions, and ultimately validate and accept related deliverables.
• Communicate effectively and work closely with internal clients to make sure their requirements are met, and delivered solutions validated and accepted.
• Lead and mentor Analysts/Senior Analysts within the Performance Systems team.
• As a self-starter, continuously looking for outside-of-the-box process improvements and new, value-add initiatives for the Business Intelligence, Performance Systems and Analytics group.
• Interface various internal systems, to analyze data transformation and flows within said systems.
• Analyze the use of data and make recommendations to improve data flow and data transformation.
• Collaborate with IT teams to help deliver robust, well-designed automated solutions while mitigating implementation risks.
• Learn and keep current in the understanding of the key processes supported by or having an impact on the team.

What you bring:

• Undergraduate degree in technical or related fields (e.g. Finance, IT, Mathematics, Information Systems).
• Post graduate degree would be an asset.
• 7+ years in a business-focused technical role within the Investment industry with working knowledge of diverse asset classes (Fixed Income, Equities, Derivatives and Alternatives).
• 5+ years configuring and maintaining middle office systems, including expert proficiency with SQL, spreadsheets, and database applications (e.g. Snowflake, Oracle, SAP Hana).
• 5+ years leading projects.
• Working knowledge of SaaS concepts, SDLC, and DevOps processes.
• Proven ability to perform requirement analysis, author documentation, communicate with stakeholders, and drive UAT execution and implementation.
• Working knowledge of Python and/or some other general-purpose programming language would be an asset.
• Experience developing reports using a range of Business Intelligence Tools (e.g. Qlik, Power BI) including the design, development, and maintenance of any underlying data models.
• Keen eye for detail and accuracy.
• Professional designations would be an asset e.g. CFA, FRM, CPA.
• A commitment to demonstrating HOOPP values Diligent with strong troubleshooting and problem-solving skills.
• Ability to think conceptually, creatively, always looking for new ways of doing work.
• Lead initiatives to develop and implement improvements.
• Able to work independently with minimal direction as well as part of a team.
• Works well under pressure handles concurrent tasks, and meets prescribed deadlines.

The actual base salary offered to the successful candidate may vary based on multiple factors including, but not limited to, individual's expertise and level of experience applicable to the role they are being offered. This role is eligible to participate in discretionary incentive plan(s), subject to the terms and conditions of the applicable incentive plan text.

About HOOPP

Founded in 1960 by the Ontario Hospital Association, the Healthcare of Ontario Pension Plan (HOOPP) is one of Canada’s strongest and most stable defined benefit pension plans. For over 65 years, HOOPP has delivered on its pension promise to Ontario’s healthcare workers, now serving more than 504,000 members and 870 employers across the province. With offices in Toronto and London, HOOPP manages a global, diversified multi-asset portfolio. One of Canada’s Maple 8 pension plans, HOOPP oversees $132 billion in assets and remains fully funded, supported by strong risk-adjusted returns, stable contribution rates for more than 20 years and independent governance. Our strength is powered by our people who bring HOOPP’s mission, vision and values to life and play a crucial role in helping us succeed. We are a purpose-driven organization committed to building an equitable, diverse and inclusive workplace where different perspectives drive better outcomes. We look for talented, forward-thinking individuals who want their work to have real impact on the lives of others. We believe an equitable, diverse and inclusive (EDI) workplace is integral to cultivating a positive culture. We integrate fair and inclusive practices into our programs and processes, creating equal opportunity and establishing a consistent employee experience across our organization.

If you need accommodation at any point in our recruitment process, please advise your recruiter or email us at [e-mail] and we will be happy to consult with you so that arrangements can be made for reasonable accommodation.