Analyst, Investment Data and Systems (Contract)

About UTAM

University of Toronto Asset Management (“UTAM”) is the investment manager of the University of Toronto’s endowment and short-term working capital assets. We are a high-performing, collaborative organization committed to delivering value to the university. We invest globally across various asset classes, applying a clear set of responsible investing principles. Please refer to UTAM for more information about us.

The Position:

Title: Analyst, Investment Data and Systems

Type: Contract until December 31, 2027

Reports to: Senior Manager, Investment Data and Systems

Location: Toronto, ON (hybrid working options currently available)

Summary

Reporting directly to the Senior Manager, Investment Data and Systems, you will play a key supporting role in maintaining and developing the team’s investment data infrastructure. The investment data infrastructure is represented primarily by an internally developed investment database (the “database”) that feeds multiple downstream processes. Under the direction of the Senior Manager, you will work closely with other analysts in the daily maintenance of the database and associated import/export protocols. You will also support other team members in the consolidation of investment data, automation of standard reporting functions and related production cycle and integrity checks and output, as well as support internal creators and consumers of data, as necessary, to ensure that investment data assets are available and fit for purpose for downstream systems and reporting functions.

You are the first line of defense for data monitoring, data quality assurance, and loading and delivering information to downstream internal systems and teams for consumption. In addition, you will provide support/backup for several key business processes that the team undertakes.

Please note this is a fixed-term position with an end date of December 31, 2027.

Responsibilities

Data Management

Develop and maintain a hands-on knowledge of data management processes with an emphasis on the following work areas:

• Monitor and troubleshoot processes to ensure the receipt, accuracy, and completeness of data flow from external/internal source systems/providers to the database.
• Engage with internal and external parties to validate and ensure data integrity, and to resolve data quality discrepancies.
• Assist in identifying and implementing solutions to address data integration needs on investment data platforms such as MS SQL Server and other tools.
• Support the development of Extract, Transform, and Load (ETL) processes that interact with the database, new external/internal feeds (onboarding process), and the data orchestration that delivers information to data reporting tools (e.g., Power BI) to facilitate self-serve report delivery and visualization.
• Respond to business users’ queries for data and build/run reports using approved reporting tools (e.g., MS SQL Server, Power BI, Power Queries, DAX).
• Execute and monitor existing processes currently established for day-to-day operations and recommend process improvements.
• Create, update, and maintain data design and data process documentation.
• Other duties as assigned.

Business Processes

• Participate in the monthly production of performance results for all levels of the portfolios, including (but not limited to) fund level, composite level, and benchmark returns.
• Prepare and validate input/output files, which will often require engagement with third-party providers.
• Reconcile asset-mix and performance reporting output, resolve and escalate issues as necessary.
• Support developing and maintaining process documentation related to performance measurement and investment risk management.
• Support portfolio rebalancing and currency hedging processes, including validating data used/output reports; running and validating asset-mix and trade reports as required; and participating in rebalancing and currency hedging review meetings.
• Support the development, maintenance, and operational workflow for generating, validating, and reporting investment risk data.
• Support the preparation of risk proxy data and the import and export of risk metrics/results into the internal database for downstream analysis and reporting purposes.
• Other duties as assigned.

Requirements and Experience

• Relevant university degree and/or data management certifications.
• Proven success in a collaborative, team-oriented environment.
• Strong Excel skills with the ability and willingness to learn other analytical tools.
• Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
• Strong written and oral communication skills.
• Familiarity with data models, database design and development, data normalization, and ETL tools.

Familiarity with Microsoft SQL Business Intelligence Technology stack, such as:

• MS SQL Server (e.g., automating scheduled jobs, writing functions and procedures in MS SQL Server).
• SQL Server Integration Services (including familiarity with scripting languages).
• SQL Server Analysis/Reporting Services / Power BI.

The following attributes are considered an asset:

• Prior experience, including internships, in a data management role.
• Knowledge of programming languages such as Python and VB.net.
• Experience with the investment management industry, prior work with custodial data files and market index providers.

Personal Characteristics

• Unquestionable ethics and integrity.
• Motivated and hardworking.
• Detail-oriented and organized.
• Eager to learn.

Compensation

Expected compensation is within the range of $50,000 to $65,000 per annum, prorated for the duration of the fixed-term employment. Placement within the range will be based on factors such as internal equity and the candidate’s experience, skills, and qualifications relevant to the role.

Diversity Statement

UTAM is strongly committed to diversity and especially welcomes applications from racialized persons/persons of colour, women, Indigenous/Aboriginal Peoples of North America, persons with disabilities, LGBTQ2S+ persons, and others who may contribute to the further diversification of ideas. Our values regarding equity and diversity are linked with our unwavering commitment to excellence in pursuing our mission.

Accessibility Statement

UTAM is committed to the principles of the Accessibility for Ontarians with Disabilities Act (AODA). As such, we strive to make our recruitment, assessment, and selection processes as accessible as possible and provide accommodation as required for applicants with disabilities. If you require any accommodations at any point during the application and hiring process, please contact humanresources@utam.utoronto.ca.

Artificial Intelligence (AI)

UTAM does not currently use AI to evaluate candidates.

Vacancy

This job is for an existing vacancy.

To Apply

All qualified candidates are encouraged to apply; however, Canadians and permanent residents will be given priority. Submit your resume and a cover letter explaining how your qualifications and experience make you a suitable candidate for this position to careers@utam.utoronto.ca. Include “Your Name – Analyst, Investment Data and Systems” in the subject line.