Senior Data Solutions Engineer

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:

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.

We cultivate a culture that emphasizes innovation, collaboration, practicality, and the courage to challenge the status quo. 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. Success in this role requires the ability to navigate ambiguity, ask thoughtful questions, and turn emerging technologies into practical solutions that deliver measurable business impact.

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, with knowledge of data pipelines, databases, job scheduling, columnar technologies, and production support.
• Strong 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