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
- Strong 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 in Toronto employer: Healthcare of Ontario Pension Plan Trust Fund Company
At HOOPP, we pride ourselves on fostering a high-performance, people-focused culture that champions equity, diversity, and inclusion, ensuring every employee feels valued and empowered. Our commitment to learning and development, coupled with competitive benefits like a world-class pension plan and comprehensive health coverage, creates an environment where employees can thrive both personally and professionally. Located in the vibrant cities of Toronto and London, we offer unique opportunities to make a meaningful impact in the healthcare sector while enjoying a supportive and innovative workplace.
Contact Details:
Healthcare of Ontario Pension Plan Trust Fund Company Recruitment Team
