Sr. Manager, Systems

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 Linked In 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

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

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