Senior Performance Systems Analyst: Data & Automation

Healthcare of Ontario Pension Plan Trust Fund Company; Toronto; On-site; CAD 103,000 - 153,000; Full time

Benefits offered by this job

Full health and dental benefits

Mental health coverage

Parental leave top-up

Wellness programs

Job summary

Healthcare of Ontario Pension Plan (HOOPP) is seeking a technical professional to support its P&L system (Ortec Pearl) operations, data warehousing, and automated/investment reporting solutions. You will work across IT, Front, Middle and Back Offices to deliver reliable data and reports, while improving data flows and governance.

The role emphasizes SQL-based data reconciliation, development of automated solutions, and collaboration with multiple teams to meet client needs and drive process

Qualifications

• Bachelor-level degree in finance, IT, mathematics or information systems.
• Postgraduate degree is an asset.
• 3+ years in a technical, business-focused role in investment industry.

Responsibilities

• Monitor P&L system jobs and related data flows.
• Analyze data quality for official releases to the Enterprise Data Platform.
• Build and maintain cross-functional reports and automation solutions using BI tools.

Skills

SQL

Python

Power BI

Qlik

Spreadsheet proficiency

Education

Undergraduate degree in technical or related fields

Post graduate degree would be an asset

Tools

Snowflake

Oracle

SAP Hana

Job description

Healthcare of Ontario Pension Plan (HOOPP) is seeking a technical professional to support its P&L system (Ortec Pearl) operations, data warehousing, and automated/investment reporting solutions. You will work across IT, Front, Middle and Back Offices to deliver reliable data and reports, while improving data flows and governance.

The role emphasizes SQL-based data reconciliation, development of automated solutions, and collaboration with multiple teams to meet client needs and drive process