Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now

Tailor your resume to this Investment Data Governance Analyst role.

Rezi rewrites your resume against HOOPP (Healthcare of Ontario Pension Plan)'s job description. Free.

Resume score gauge reading 58 out of 100

Don't guess if your resume is good enough.

See how it scores against the Investment Data Governance Analyst posting at HOOPP (Healthcare of Ontario Pension Plan) — free, in seconds.

About the Role

The Investment Data Governance Analyst is responsible for a broad range of Data Governance activities supporting all groups within the Investment data space. This position requires knowledge of Data Governance best practices as they pertain to investment data, an understanding of how investment data resides within Investment Applications, and how to enable it for data-driven decision making. Familiarity with investments instruments at a macro level and the ability to quickly develop a detailed understanding of HOOPP investment Products & Strategies is also necessary. The individual will focus on implementing and enhancing Data Governance solutions, provide operational support for Data Dictionary/Catalog and Data Governance tools, and work with the Director to establish strong data governance practices across Finance, HOOPP, and promote a data governance culture.

Responsibilities

Support the development and enhancements to technology solutions around key data governance focus areas of data dictionary/catalog, metadata management, data quality management, data flows/diagrams and access management.
Interpret business data quality requirements to develop data quality checks and reconciliations within the data quality tool.
Work closely with IT partners during the development of new solutions and data governance related applications, including requirements validation and testing.
Provide ongoing support, training and education to help users navigate, maintain and effectively use for data governance tools.
Monitor data governance tools on a daily basis, perform ongoing maintenance, and validate the health of the tool.
Support the enforcement and adherence to HOOPP data governance principles and Investment Data Governance policy.
Promote data governance practices and their importance in maintaining data quality and compliance to stakeholders.
Monitor and review adherence to data governance controls, investigate exceptions and coordinate with the appropriate stakeholders to track remediation through to resolution.
Provide guidance, training and ongoing support to Data Owners, Data Stewards and Data Custodians in fulfilling their responsibilities within the Federated Data Governance framework.
Support Quarterly Access Reviews for data governance solutions, and other activities related to Data Governance and Compliance.
Administer KPI and metric reports to gauge the health and maturity of data governance program.
Understand and right size the governance of the data that is made available to end users and systems.
Publish data assets in the Enterprise Data Platform (EDP), ensuring Data Owner, Data Steward and Data Custodian roles are assigned and documented before publication.
Review data contracts submitted by teams for completeness, clarity and alignment with data governance standards, working with stakeholders to address gaps.
Support the provisioning of new data requests, to ensure adherence to standards and prevent data duplication.
Recommend data domain placement and field naming.
Facilitate users in accessing the most suitable data sources.
Partner with stakeholders and data stewards to define and instrument metadata capture and storage for the Critical Data Elements.
Evolve business glossary and facilitate the linkage between business definitions and the underlying technical metadata.
Have an in-depth understanding of how investment data flows into and is captured within Investment Applications at HOOPP.
Create process and trade flow and process diagrams.
Develop an understanding of the Fund Portfolio Structure and the rationale for its design.
Develop and maintain a deep understanding of the characteristics of all the marketable securities, derivative contracts and other investments that are contained within the various Fund Portfolios.
Create lineage diagrams, to establish confidence in the data and provide transparency to the data source.
Document and update both existing and newly developed processes and workflows, ensuring they remain current and accessible to stakeholders.
Regularly update procedures to ensure their relevance and accuracy.
Create operational documentation for new data governance solutions.

Requirements

3+ years of experience in implementing data governance, data analytics or data quality tools.
At least 2 years’ work experience in Financial Services within the Pension domain (preferred).
Completion of Canadian Securities Course.
Knowledge in data governance technology, business process modelling, metadata, data lineage, data classification, data quality and enterprise implementation of data governance tools and solutions.
Experience with tools and applications such as Snowflake, SimCorp Dimension, GoldenSource, Bloomberg, Precisely Data360 DQ+, AWS SageMaker Unified Studio, Atlan.
Experience with Python, and Business Intelligence tools.
Intermediate SQL skills.
Understanding and usage of SQL keywords, data types, constraints, pivots, sub queries, logical and comparison operators, and advanced joins (inner, outer) and unions.
Can generate complex data reports using GROUP BY and aggregate functions.
Advanced Excel Skills.
Ability to write and create advanced formulas using VLOOKUP, Arrays, Index and Match functions, debug and audit.
Proficiency in debugging error messages among various applications is essential for this role, ensuring smooth software operation and user experience.
Understanding of Cloud, architectural concepts - data lake, data warehouse, relational databases, data ingestion, ETL etc.
Excellent verbal and written communication to effectively articulate and communicate with both business and technical development teams.
A team player with a good understanding of the Agile methodology and Change management.

Skills

Data Governance
Data Dictionary/Catalog
Metadata Management
Data Quality Management
Data Flows/Diagrams
Access Management
Data Quality Checks
Reconciliations
IT Partnership
Requirements Validation
Testing
User Training
Data Governance Tools
Data Governance Principles
Investment Data Governance Policy
Data Quality
Compliance
Data Governance Controls
Remediation
Federated Data Governance Framework
Quarterly Access Reviews
ICFR
IT GRC
KPI and Metric Reporting
Data Governance Program Maturity
Data Provisioning
Data Contracts
Data Domain Placement
Field Naming
Metadata Capture and Storage
Critical Data Elements
Business Glossary
Technical Metadata
Investment Data Flow
Investment Applications
Process Diagrams
Trade Flow Diagrams
Fund Portfolio Structure
Marketable Securities
Derivative Contracts
Externally Managed Hedge Funds
Infrastructure Investments
Private Equity
Real Estate Investments
Lineage Diagrams
Process Documentation
Workflow Documentation
Operational Documentation
Snowflake
SimCorp Dimension
GoldenSource
Bloomberg
Precisely Data360 DQ+
AWS SageMaker Unified Studio
Atlan
Python
Business Intelligence Tools
SQL
GROUP BY
Aggregate Functions
Excel
VLOOKUP
Arrays
Index and Match
Debugging
Cloud Architecture
Data Lake
Data Warehouse
Relational Databases
Data Ingestion
ETL
Agile Methodology
Change Management

Location

Ontario

Work Type

Full-time

Experience Level

3+ years of experience
2 years' work experience

Education Level

Bachelor’s degree in engineering, math or a field related to information, data management, analytics, or financial services.
Completion of Canadian Securities Course.
Enrolment or completion of relation professional training (e.g., CFA) is an asset.

Salary/Compensations

$71,000 - $109,000 CAD

Benefits

High-performance, people-focused culture
Commitment that equity, diversity, and inclusion are fundamental to our work environment and business success
Learning and development initiatives, including workshops, Speaker Series events and access to LinkedIn Learning
Membership in HOOPP’s world class defined benefit pension plan
Competitive, 100% company-paid extended health and dental benefits for permanent employees
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, parental leave top-up, and a health spending account).
Optional post-retirement health and dental benefits subsidized at 50%
Yoga classes, meditation workshops, nutritional consultations, and wellness seminars
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
Eligible to participate in discretionary incentive plan(s)

About the Company

HOOPP is a pension plan that serves Ontario healthcare workers.

Equal Opportunity

HOOPP may use artificial intelligence tools to assist in screening, assessing and selecting applicants for this position. These tools support our recruitment process but do not replace human judgment and decision-making.