Senior Investment Data Governance Analyst

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, and newly extended maternity/parental leave top of 26 weeks)

• optional post-retirement health and dental benefits subsidized at 50%

• yoga classes, meditation workshops, nutritional consultations, and wellness seminars

• access to an annual wellness reimbursement program for health and wellness-related expenses for permanent and temporary employees

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

Reporting to the Associate Director of Data Governance, the Senior Investment Data Governance Analyst is responsible for ensuring that investment applications provide accurate and complete information to business users on a daily basis. The role also involves supporting a wide range of Data Governance activities across all Finance groups. Key responsibilities include maintaining data integrity and availability within investment applications, data reconciliation, data quality, pricing integrity, managing the integrity of security master, reference and market data, and overseeing trade capture within and across investment applications.
 

In addition to these responsibilities, the Senior Investment Data Governance Analyst will design and implement data quality controls and contribute to the development of best practices for data governance. They will also create processes and controls for the Investment Book of Record (IBOR) views, which support investment management decision-making.
 

The ideal candidate will have strong analytical skills, a solid work ethic, and sharp business acumen, along with experience in managing investment data, investment operations, business or project management, and systems implementation. This role requires a highly motivated, technically proficient individual who is capable of managing financial data and systems independently.

What you will do:

1. Data Governance Standards, Integrity, and Compliance

• Develop and enforce best practice standards and models for data governance, ensuring compliance.

• Execute and enhance data integrity reporting, ensuring controls are in place for consistent data management.

• Administer KPI reports to assess the health and maturity of the data governance program, manage Quarterly Access Review process for data governance solutions and other activities related to Data Governance and Compliance as required (i.e. ICFR, IT GRC, etc).
   

2. Data Quality, Tools, and Automation

• Design, develop, and implement Data Quality checks, identifying opportunities to automate quality control and synergies across the organization.

• Maintain metadata repositories (e.g., data dictionary, data catalog, business glossary) and provide ongoing support for data governance solutions.

• Proactively validate data using exception handling tools and develop processes to enhance data quality tools.
   

3. Collaboration, Mentorship, and Stakeholder Engagement

• Be a leader in socializing and educating on data governance best practices.

• Partner with stakeholders and data stewards to capture and manage metadata, evolve the business glossary, and ensure proper data access.

• Coordinate cross-functional projects, leading efforts that involve multiple stakeholders and dependencies.
   

4. System Development, Support, and Operations

• Participate in all phases of system development projects, focusing on data governance during requirements definition, design, and implementation.

• Support Master Data Management processes to ensure governed ‘fit-for-purpose’ data.

• Monitor and maintain data governance tools, ensuring system health and compliance with data access and security standards.

• Primary backup for the Investment Data Governance Analyst
   

5. Documentation, Process Management, and Knowledge Development

• Document and update processes, workflows, and procedures, ensuring they remain current and accessible to stakeholders.

• Develop and maintain knowledge of the Fund Portfolio Structure and investment characteristics, supporting the governance of captured data.

• Create operational documentation for new data governance solutions, regularly updating procedures for relevance and accuracy.

What you bring:

• 7+ years in investment and financial systems administration, implementation or investment data management with a minimum of  2+ years of experience in data governance

• Post-secondary training in finance or equivalent experience.  Completion of Canadian Securities Course.  Enrolment or completion of relation professional training (e.g. CFA) – is not required though may be an asset.

• Knowledge in data governance technology, business process modelling, metadata, data lineage, data classification, data quality and enterprise implementation of data governance tools and solutions.

• Knowledge of investment management principles and practices with exposure to marketable securities, derivatives, private placements and real estate.

• Highly analytical with strong consulting and problem-solving ability.  Tenacity to identify the root cause of problems is essential.

• Team player with excellent interpersonal and communication (written and verbal) skills are essential to deal with all levels of staff and outside contacts.

• Comprehensive understanding of middle and back-office processes and technical applications.

• An understanding of, and an ability to comprehend, the nature and workflows of a multi-investment system environment and the data usage by various user groups.

• An understanding of the accounting and performance responsibilities and reporting requirements will be an asset to this position.

• Develop a strong proficiency with computer applications being utilized for the Investment business (Snowflake, SimCorp Dimension, Precisely Data360 DQ+, SS&C Net, AIM, SAP HANA, SAP Data Services, Bloomberg, Vendor Based Front Office Trading Tools, etc.).

• Understanding and/or previous experience using data quality tools and procedures. A thorough understanding of the interdependencies between relational database tables. Good understanding of report development concepts.  Proficiency with MS SQL Server Tools, SQL language and/or Transact-SQL language, ETL Tools is a definite asset.   Competence with database report writers, business intelligence tools and basic PC and Windows skills with a strong proficiency in Excel.

• Solid knowledge of valuation pricing methodology across all asset classes.

• Experience in Master Data Management is a requirement.

• Prior Business Analysis skills are an asset.