Apply on Kit Job: kitjob.ca/job/2g94le

Job Overview

Job Requisition Id:

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:

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 current needs arise.

Responsibilities

- Develop scripts to automate reports for the Pension Investment team; ensure reporting automation meets clients’ needs, correcting any reporting issues that arise; research, analyze and provide resolutions for issues related to reporting, escalating to the Manager when necessary.
- Assist in the design and implementation of high-quality, well-tested data pipelines and systems using the latest technologies; research and recommend new technologies relevant to data warehousing, cloud computing, AI, etc.
- Utilize Python programming and various data visualization tools for the development of automated solutions in data processing, analysis, and presentation.
- Integrate with internal and external investment systems, leveraging modern cloud technologies and tools on an event-driven architecture; support day‑to‑day issue resolution.
- Work closely with Investment and Risk teams and Data Management to assist in designing and strategizing reporting solutions; 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 vendor solutions; coordinate 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; coordinate interactions between users and IT support teams (submitting support tickets, setting up meetings) ensuring timely resolutions.
- Manage smaller-scale IT projects, coordinating with stakeholders to determine business needs; consult with the Manager, complete applicable development and support project deployment.
- Interact with clients to gather information, explore gaps in current services, gain new perspectives, consider best practices, and explore new strategies; collaborate with management to communicate needs and findings, negotiate business cases, and influence the best courses of action for reporting automation.
- Contribute to the development of new internal guides, documents, and information sources, and revise existing documents based on team needs.
- Stay abreast with technological trends, continually enhancing technical skills through research and experimentation; troubleshoot and resolve operational issues in both development and production environments.
- Network with industry professionals from external pension plan groups to remain up‑to‑date on industry trends and maintain a network of 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 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 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.

Essential Requirements

- 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 & 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.

#J-18808-Ljbffr

Apply on Kit Job: kitjob.ca/job/2g94le

📌 Analyst, Investment Data and Technology (Toronto)
🏢 Canada Post - Postes Canada
📍 Toronto