Senior Data Solutions Engineer - Investment Data & AI

hoopp; Toronto; Hybrid; CAD 120,000 - 180,000; Full time

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,

Qualifications

• 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 to investigate issues, test assumptions and hypotheses, identify root causes, validate results, and develop sustainable solutions.

Responsibilities

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

Skills

Software development

Java

Python

C#

C++

SQL

Data analysis

Critical thinking

Problem solving

Tools

Snowflake

PowerShell

AWS Glue

REST APIs

SAP HANA

Job description

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,