Shape investment data quality at HOOPP with SQL, advanced Excel, and reconciliation design. Support reliable information across investment applications and governance tools.

The Investment Data Governance Analyst translates business quality requirements into checks, validations, and reconciliations. Reporting to the Director, you will support Finance, IT partners, Data Owners, Data Stewards, and Data Custodians. Your work helps maintain governance standards, investigate exceptions, and support accurate data use.

Key Responsibilities:

- Interpret requirements and build data quality validations
- Investigate governance exceptions and coordinate remediation through resolution
- Administer KPI and metric reports on program health
- Publish data assets and review data contracts for completeness




- Support users through governance tool training and ongoing assistance

Requirements:

- Three or more years with data governance, analytics, or quality tools
- Intermediate SQL including joins, unions, pivots, and aggregate functions
- Advanced Excel formulas, auditing, and debugging capabilities
- Experience with Python and business intelligence tools
- Solid communication across business and technical development teams

Bring data quality, SQL, Excel, and stakeholder communication skills to HOOPP’s investment governance function.

📌 Investment Data Quality Analyst (Canada)
🏢 Healthcare of Ontario Pension Plan Trust Fund
📍 Canada