Analyst, Investment Data and Technology

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

Job summary

A leading postal service provider in Canada is seeking an Analyst, Investment Data and Technology. The ideal candidate will have a background in IT and finance, with strong skills in Python and data management. Responsibilities include developing automated reporting solutions, managing IT projects, and ensuring efficient data integration. The role offers the opportunity to work with cross-functional teams and advance technology solutions within the Pension Investment department.

Qualifications

• 1 to 3 years of development experience in IT.
• Experience with cloud platforms like AWS and Snowflake.
• Strong understanding of data management and warehousing.
• Experience in investment data flows and capital markets is a plus.

Responsibilities

• Develop scripts to automate reports for the Pension Investment team.
• Assist in the design and implementation of high-quality data pipelines.
• Utilize Python and data visualization tools for automated solutions.
• Act as an IT support liaison for the Pension Investment department.
• Manage smaller-scale IT projects, ensuring stakeholder needs are met.

Skills

Proficiency in Python

SQL experience

Data visualization

Strong problem-solving abilities

Communication skills

Data management knowledge

Familiarity with AWS

Familiarity with ETL processes

Programming skills

Education

Bachelor’s degree in computer science or related field

Tools

AWS

Snowflake

Power BI

Jira

GitHub

Airflow

Docker

Spark

PySpark

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.

The Analyst will also:

• Manage 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.
• Interact 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.
• Contribute to the development of new internal guides, documents, and information sources, and revises 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 other IT professionals.

Qualifications

The ideal candidate will have:

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

The candidate should also have:

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

We are committed to living our values and practicing our behaviours every day, which include Trust, Respect, and Deliver, as well as Making the call, Knowing the destination, Delivering for others, and Igniting our pride.