Analyst, Investment Data and Technology

Canada Post; Toronto; On-site; CAD 70,000 - 90,000; Full time

Job summary

A leading company is seeking an Analyst in Investment Data and Technology to enhance and maintain their IT structure supporting Pension Investment. Responsibilities include developing automated reporting solutions, managing IT projects, and collaborating with cross-functional teams. The ideal candidate has a strong background in data management, proficiency in Python and SQL, and familiarity with cloud technologies like AWS and Snowflake. This full-time position is based in Toronto and offers opportunities for professional growth in a committed and inclusive workplace.

Qualifications

• 1 to 3 years of relevant development experience required.
• Experience with AWS, Snowflake, or similar cloud platforms necessary.
• Proficient in SQL and Python programming.

Responsibilities

• Develop scripts to automate reports for the Pension Investment team.
• Assist in designing and implementing high-quality data pipelines.
• Act as IT support liaison for the Pension Investment department.

Skills

Python

SQL

Data Management

Data Visualization

Cloud Solutions

Education

Bachelor's degree in computer science or related subject

Tools

AWS

Snowflake

Docker

Airflow

Jira

GitHub

Job description

Select how often (in days) to receive an alert:

Analyst, Investment Data and Technology

Location:

Toronto, ON, CA

Job Requisition Id: 191973
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: 2
Job Closing Date (YYYY/MM/DD): 2025/07/15

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

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 .

All qualified candidates will be considered however preference will be given to Indigenous People (First Nations, Metis or Inuit) or Persons with disabilities. This is a special measure employment equity initiative and candidates from this group who wish to qualify for preferential consideration must self-identify.

Accessibility

Canada Post is committed to fostering an equitable, respectful, and caring workplace where everyone is welcome and has equal opportunity, where diversity is valued and celebrated and where we work together to remove barriers and promote accessibility. If you are contacted regarding a job opportunity, please advise if you require an accommodation. All information received in relation to accommodation will be kept confidential.

Employment Equity

Canada Post is committed to creating a safe workplace that embraces and celebrates everyone. We are committed to employment equity and encourage applications from Indigenous Peoples, Persons with disabilities, Members of visible minorities, and Women.

Disability is defined as a persistent or episodic physical, sensory, or mental health condition and/or functional limitation. Disability includes both visible and hidden conditions and/or limitations that may impact vision, hearing, mobility, flexibility, dexterity, pain, learning, developmental, mental/psychological, and memory.

Information on our Equity, diversity & inclusion national strategy and our Indigenous reconciliation strategy can be found at the following links:

A conflict of interest is when an employee’s interests (personal, financial or business) or relationships (family or close personal relationships) interfere, or appear to interfere, with the interests of Canada Post. To know if a conflict exists, please refer to the Canada Post's code of conduct.