Senior Data Solutions Engineer in Toronto

Why you’ll love working here:

• High-performance, people-focused culture.
• Commitment to equity, diversity, and inclusion as fundamental to our work environment and business success.
• 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:

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

What you will do:

• Evolve the investment data warehouse, pipelines, and enterprise data model supporting HOOPP's investment book, market data, and downstream business processes.
• Own the Detect -> Respond -> 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.
• Execute and enhance governance activities, including production release reconciliations, Quarterly Access Reviews, entitlement management, and privileged-access oversight.
• Maintain and improve runbooks, monitoring, knowledge assets, enterprise job schedules, and operational workflows.

What you will bring:

• 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.
• Strong SQL, data analysis, critical thinking, and creative problem-solving skills.
• 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.
• 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.
• Comfortable working across teams, with strong communication skills.

Benefits and Compensation:

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.

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.