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 HOOPP's Information Technology teams deliver innovative technology solutions to help build a stronger financial future for the healthcare community. As a Senior Data Solution Engineer, you will help keep HOOPP's investment data ecosystem reliable, governed, and ready to evolve toward a shared enterprise data model. Our DTS Operations team supports the investment data warehouse and the governed data models and transformation logic that represent HOOPP's investment book, positions, transactions, valuations, and market data.

As a Senior Data Solution Engineer, reporting to the Senior Manager, Investment Data Operations, you will own outcomes from first detection through root-cause closure, helping ensure data is reliable for trading, investment operations, risk management, valuation, performance, and analytics. This role is well suited to someone who combines technical depth with curiosity, sound judgment, product thinking, systems thinking, and a willingness to test new ideas. You will look beyond immediate symptoms, identify underlying needs,



and develop solutions that are secure, sustainable, and valuable in delivering the pension promise.

Evolve the investment data warehouse, pipelines and enterprise data model supporting HOOPP's investment book, market data, and downstream business processes. Prevent cycle across the platform stack, resolving incidents, completing root-cause analysis, and driving preventive actions to closure. Investigate investment data issues across positions, transactions, securities, pricing, valuation, and market data, tracing end-to-end flows from source platforms to downstream consumers.

Create and validate changes to data models, business logic, and data feeds, while protecting data integrity, lineage, auditability, and ICFR controls. Design and extend AI-assisted projects using Python, Jupyter notebooks, PowerShell, and alternative AI tools, with clear human validation and approval points. Lead projects and provide long-term solutioning by solving the root cause of a problem and partnering with investment, risk, finance, operations, data management, and technology teams to deliver reliable data solutions, operational readiness, and sustainable production support.

Investigate platform, data pipeline and scheduling challenges using logs, scripts, execution reports, and system diagnostics. Maintain and improve runbooks, monitoring, knowledge assets, enterprise job schedules, and operational workflows. 5+ years of professional software development experience using languages such as Java, Python, C#, or C++. Technical fluency across data platforms and operational systems, including Snowflake, Python, SAP HANA, PowerShell, AWS GLUE, and REST APIs, with knowledge of data pipelines, databases, job scheduling, columnar technologies, and production support.

Solid SQL, data analysis, critical thinking,



and creative problem-solving skills to investigate issues, test assumptions and hypotheses, identify root causes, validate results, and develop sustainable solutions. Knowledge of investment products, investment strategies, portfolio theory, valuation models, risk models, and finance theory is an asset. Proven experience creating AI agents, skills, or intelligent automation solutions, combined with the ability to think strategically, challenge existing approaches, solve complex problems, and translate emerging AI capabilities into practical business outcomes.

Sound judgment to determine next steps, engage the right stakeholders, and balance urgency and quality with governance, compliance, and long-term reliability. Accountability for outcomes and a continuous-improvement mindset, with the discipline to carry work through implementation, validation, documentation, and closure. Comfortable working across teams, with strong communication skills and the ability to translate complex technical concepts into clear, non-technical language.

The expected annual base salary range for this role is: $103,000 - $153,000 CAD. 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.

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 building a powerful design… #

📌 Senior Data Solutions Engineer (Toronto)
🏢 Healthcare of Ontario Pension Plan Trust Fund
📍 Toronto