Analyst, Investment Data and Technology Full Time

Business Function: Pension Investment

Primary City: Toronto

Other Location(s): GTA

Province: Ont. – GTA

Employment Type: Full-Time

Employment Status: Permanent

Language Requirement: English Essential

Employee Class and Level: UPCET01

Number of Vacancies: 1

Job Closing Date (YYYY/MM/DD): 2026-04-24

Job Description

Reporting to the Manager, Pension Investment Technology, the Analyst, Investment Data and Technology assists in designing, maintaining, and advancing the in-house IT structure of Pension Investment. The Analyst works with cross-functional teams, supporting the development and maintenance of data architecture, models, and integration services. The Analyst leverages their skills to transform key data from various business domains into insights. Utilizing their IT and finance experience, the Analyst enables efficient data management, insightful analytics, and provides robust support for issue resolution, facilitating informed decision making and ensuring no interruptions to workflow. The Analyst offers flexible IT support as the Pension Investment team grows, technology needs changing, and new needs arise.

Job Responsibilities

Below are the main job requirements and responsibilities for the Analyst, Investment Data and Technology:

• Develops scripts to automate reports for the Pension Investment team. Ensures reporting automation is meeting clients’ needs, correcting any reporting issues that arise. Thinks critically, does research, and analysis to provide resolutions for issues related to reporting, escalating to the Manager when necessary.
• Assists in the design and implementation of high-quality, well-tested data pipelines and systems using the latest technologies. Researches and recommends new technologies relevant to data warehousing, cloud computing, AI, etc.
• Utilizes Python programming and various data visualization tools for the development of automated solutions in data processing, analysis, and presentation.
• Integrates with internal and external investment systems, leveraging modern cloud technologies and tools on an event-driven architecture. Supports day-to-day issue resolution.
• Works closely with Investment and Risk teams and Data Management to assist in designing and strategizing reporting solutions. Helps build new trade feeds and portfolio hierarchies for Investment and Risk applications, adapt and adopt vendor-based solutions and APIs, and blend internal development with those vendor solutions. Coordinates with Pension Investment teams to ensure accuracy with daily trade movement and data management and reporting.
• Act as an IT support liaison for the Pension Investment department, handling a variety of IT-related issues, including hardware and software challenges. When necessary, coordinates interactions between users and IT support teams (submitting support tickets, setting up meetings) ensuring timely resolutions.

Job Responsibilities (continued)

• Manages smaller-scale IT projects, coordinating with stakeholders to determine the business needs. In consultation with the Manager, completes the applicable development and supports the project deployment.
• Interacts with clients to gather information, explore gaps in current services, gain new perspectives, consider best practices, and explore new strategies. Collaborates with management to communicate needs and findings, negotiate business cases, and to influence the best courses of action for reporting automation.
• Contributes to the development of new internal guides, documents, and information sources, and revises existing documents, based on team needs.
• Stays abreast with technological trends, continually enhancing technical skills through research and experimentation. Troubleshoot and resolve operational issues in both development and production environments.
• Networks with industry professionals from external pension plan groups to remain up to date on industry trends and maintain a network of other IT professionals.

Qualifications

Education

• A bachelor’s degree preferably in computer science or related subject OR a combination of equivalent professional experience and training.

Experience

• 1 to 3 years of relevant development experience, including experience with needs assessment, solution design, implementation, and ongoing support/evolution.
• Demonstrated experience with AWS, SnowFlake, or similar cloud platforms.
• Experience with technologies such as Jira, GitHub.

Other Candidate Requirements

• IT generalist knowledge of systems and programs.
• Working knowledge of trading lifecycle and investment workflow with experience in investment data flows, operational processing requirements, and management of data assets is an asset.
• Strong understanding of data management, integration, and warehousing concepts, with experience in relational and multi-dimensional database structures.
• Strong proficiency in Python is essential for developing automated data processing solutions and advanced data visualizations.
• Proficient in SQL with experience querying large datasets from multiple sources.
• Proficiency in data engineering tools and frameworks, including Airflow, Docker, Spark, PySpark, and ETL/ELT processes an asset.
• Exposure to various software development methodologies and practices like Test-Driven Development, Automation, Continuous Delivery, Containerization.
• Exemplary communication and coordination skills.
• Knowledge of general finance and pension investment applications, capital markets, and trading environment is considered an asset.

Other Information

Essential Requirements:

Knowledge

• ETL Processes: Proficiency in Extract, Transform, Load (ETL) processes and tools.
• Data Management: Expertise in data management and database administration.
• Trading Lifecycle & Investment Workflow: In-depth knowledge of the trading lifecycle and investment workflow. A CFA designation is considered a strong asset.
• Investment Applications: Familiarity with investment applications such as Bloomberg, SimCorp, and similar platforms.

Skills And Abilities

• Programming: Strong proficiency in Python programming and SQL.
• Cloud Solutions: Experience with cloud solutions such as Snowflake, AWS, and Azure.
• Data Visualization: Proficiency in data visualization tools, including Power BI and Python-based libraries.

Personal Suitability

• Communication and Coordination: Excellent communication and coordination skills.
• Initiative and Problem-Solving: Demonstrated self-initiative and strong problem-solving abilities.

Canada Post’s values and behaviours

Our Values – Trust, Respect and Deliver represent our fundamental promise to ourselves, our expectations of one and another and our shared duty to our country.

Our behaviours – Make the call, Know the destination, Deliver for others, Ignite our pride; embody our values, bringing them to life and guiding our actions.

We’re committed to living these values and practicing these behaviours every day. Learn more about the values and behaviours by visiting the Canada Post website.