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 Sr. Manager, Performance Systems, this position is responsible for assisting in 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 compliance reporting, automations, data analysis, modeling, validation, and QA).
What you will do:
Monitor and confirm P&L system jobs have executed successfully, along with associated up-stream and down-stream processes (Daily, Monthly, Ad-hoc); troubleshoot and re-execute as required
Analyze and confirm Performance data quality is as expected in production for official release to organization through Enterprise Data Platform
Assist in the configuration, maintenance, troubleshooting, and testing of P&L system across multiple environments. Recommend optimizations and platform integrity improvements.
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
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 will bring:
Undergraduate degree in technical or related fields (e.g. Finance, IT, Mathematics, Information Systems). Post graduate degree would be an asset.
3+ years in a business-focused technical role within the Investment industry with working knowledge of diverse asset classes (Fixed Income, Equities, Derivatives and Alternatives)
Experience configuring and maintaining middle office systems, including expert proficiency with SQL, spreadsheets, and database applications (e.g. Snowflake, Oracle, SAP Hana).
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
Basic knowledge of SaaS concepts SDLC, and DevOps processes. Proven ability to perform requirement analysis, author documentation, communicate with stakeholders, and drive UAT execution including SQL based data reconciliation and verifying system logic.
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 expected annual base salary range for this role is: $103,000 - $153,000 CAD
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.
This job is for an existing vacancy.
HOOPP may use artificial intelligence tools to assist in screening, assessing and selecting applicants for this position. These tools support our recruitment process but do not replace human judgment and decision-making.
Skills Required
- Undergraduate degree in a technical or related field such as Finance, IT, Mathematics, or Information Systems
- At least 3 years of experience in a business-focused technical role within the investment industry
- Working knowledge of diverse asset classes, including fixed income, equities, derivatives, and alternatives
- Experience configuring and maintaining middle-office systems
- Expert proficiency with SQL, spreadsheets, and database applications
- Experience developing, designing, and maintaining reports and underlying data models using business intelligence tools such as Qlik or Power BI
- Basic knowledge of SaaS concepts, SDLC, and DevOps processes
- Ability to perform requirements analysis, author documentation, communicate with stakeholders, and drive UAT execution
- Ability to perform SQL-based data reconciliation and verify system logic
- Strong troubleshooting, problem-solving, analytical, and data-quality skills
- Ability to work independently, manage concurrent tasks, and meet deadlines
- Working knowledge of Python or another general-purpose programming language
- Postgraduate degree
- Professional designation such as CFA, FRM, or CPA
What We Do
Established in 1960, the Healthcare of Ontario Pension Plan (HOOPP) is a multi-employer defined benefit pension plan for Ontario's hospital and community-based healthcare sector. We serve more than 460,000 members who provide valued healthcare services at more than 670 employers across the province. At HOOPP, we exist to provide a stable and reliable pension for our members that starts in retirement and is paid for life. As one of Canada's largest and most respected pension plans, HOOPP's net assets reached $112.6 billion at the end of 2023 and our funded status remained strong at 115%. HOOPP's core values - professional, accountable, collaborative, compassionate and trustworthy - guide our every interaction with our members, employers and employees. We've become one of Canada's leading pension plans by consistently challenging ourselves and embracing innovation. From our unique investment management approach to our innovative technology and thought-provoking research, we constantly seek to push the boundaries, and we do this by hiring passionate, forward-thinking people. Our high-performance culture, which spans our head office in Toronto and our office in London (UK), is founded on collaboration, respect and belonging. HOOPP is an equal opportunity employer and we're proud of our diversity. We select applicants for employment solely on the basis of their qualifications. Should you require accommodation because of a disability during the recruitment and selection process, please contact our Human Resources team. We will be happy to consult with you so that arrangements can be made for reasonable accommodation
