Analyst, Investment Data and Technology

Canada Post / Postes Canada; Toronto; On-site; CAD 60,000 - 80,000; Full time

Job summary

A national postal service seeks an Analyst for Investment Data and Technology in Toronto. The role involves developing automated reporting solutions and integrating data systems. Candidates should have a relevant degree and skills in Python, SQL, and cloud technologies like AWS. This position requires strong analytical abilities and communication skills, fostering efficient data management for informed decision-making.

Qualifications

• 1 to 3 years of relevant development experience with solution design and support.
• Strong understanding of data management and warehousing concepts.
• Knowledge of trading lifecycle and investment workflow.

Responsibilities

• Develop scripts to automate reports for the Pension Investment team.
• Assist in designing and implementing data pipelines and systems.
• Integrate with investment systems using cloud technologies.
• Act as IT support liaison for the Pension Investment department.

Skills

Python programming

Data visualization

SQL proficiency

Communication skills

AWS knowledge

Problem-solving

Education

Bachelor's degree in Computer Science or related field

Tools

AWS

SnowFlake

Jira

GitHub

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.

Job Responsibilities

• Develops scripts to automate reports for the Pension Investment team. Ensures reporting automation is meeting clients’ needs, correcting any reporting issues that arise.
• Assists in the design and implementation of high-quality, well-tested data pipelines and systems using the latest technologies.
• 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.
• Works closely with Investment and Risk teams and Data Management to assist in designing and strategizing reporting solutions.
• Act as an IT support liaison for the Pension Investment department, handling a variety of IT-related issues.
• Manages smaller-scale IT projects, coordinating with stakeholders to determine the business needs.
• Interacts with clients to gather information, explore gaps in current services, gain new perspectives, consider best practices, and explore new strategies.
• 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.
• Networks with industry professionals from external pension plan groups to remain up to date on industry trends.

Qualifications

• A bachelor’s degree preferably in computer science or related subject OR a combination of equivalent professional experience and training.
• 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.
• 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.
• Exemplary communication and coordination skills.
• Knowledge of general finance and pension investment applications, capital markets, and trading environment is considered an asset.

Other Information

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.

We’re committed to living these values and practicing these behaviours every day.