Advisor, Investment Finance, Analytics Support

PSP Investments | Investissements PSP; Montreal; Hybrid; CAD 80,000 - 120,000; Full time

Job summary

A forward-thinking company is seeking an Advisor in Investment Finance to lead data analysis and reporting efforts. This role involves designing automated reporting models using tools like Power BI and Python, ensuring accuracy and efficiency in financial reporting. Join a dynamic team dedicated to fostering collaboration and innovation in investment management. With a commitment to employee growth and a diverse work environment, this position offers a unique opportunity to make a significant impact in the financial sector while enjoying a competitive benefits package and a hybrid work model.

Benefits

Comprehensive group insurance plans

Competitive pension plans

Unlimited access to virtual healthcare services

Gender-inclusive paid family leave policy

Vacation days available on day one

Summer Friday afternoons off

Investment in career development

Qualifications

• 7+ years of experience in finance or asset management.
• Strong knowledge of financial data and reporting.
• Experience with visualization tools like Power BI.

Responsibilities

• Design and automate reporting models and dashboards.
• Support financial reporting and analysis processes.
• Coordinate between IT and Finance for optimal execution.

Skills

Financial Analysis

Data Visualization

Python Programming

SQL

Communication Skills

Bilingualism (English and French)

Education

Bachelor’s degree in Computer Science, Finance, or Accounting

Tools

Power BI

Excel VBA

Job description

Join to apply for the Advisor, Investment Finance, Analytics Support role at PSP Investments | Investissements PSP

3 days ago Be among the first 25 applicants

Join to apply for the Advisor, Investment Finance, Analytics Support role at PSP Investments | Investissements PSP

Get AI-powered advice on this job and more exclusive features.

About Us

We’re one of Canada’s largest pension investment managers, with CAD$264.9 billion of net assets as of March 31, 2024.

About Us

We’re one of Canada’s largest pension investment managers, with CAD$264.9 billion of net assets as of March 31, 2024.

We invest funds for thepension plans of thefederalpublicservice, the Canadian Forces, theRoyal Canadian Mounted Police andthe ReserveForce. Headquartered in Ottawa, PSP Investments has its principal business office in Montréal and offices in New York, London and Hong Kong.

Capturing and leading complex global investments requires us to work as one to seize valuable opportunities, in close collaboration with some of the world’s top companies. At PSP, you’ll join a team of motivated and engaged professionals, dedicated to propelling our organization further than ever before.

Experience The Edge

At PSP, we encourage our employees to grow, forge powerful relationships, contribute and fuel inspired investment launchpads. We are committed to a culture that fosters collaboration and allows us to think beyond, in an interconnected way. We advocate for our employees to speak-up, learn, experiment, share, and be part of an inclusive work environment where diversity is embraced.

About The Team

We are seeking an Advisor, Investment Finance, Analytics Support who will assume a leading role in the development of data, analysis and reporting for Investment Finance teams. The incumbent will analyze complex firm-wide data and develops narratives and visuals to support the “storytelling” and the different reporting views of the portfolios. The incumbent will be called upon to participate and to animate work sessions with the users, in order to clarify the business needs.

About Your Role

As an Advisor reporting to the Director, Investment Finance, Analytics Support, you will:

Reporting

• Significant contributor to the evolution of the Finance reporting platform
• Design, create and automate quality reporting models and story-telling dashboards (with Power BI) in order to facilitate consistent portfolio management reporting
• Recommend and implement improvements to increase accuracy, efficiency and productivity of Finance reporting (at the system, data, operation and procedural levels)
• Assist in leading work sessions with various teams, develop portfolio views and have a broad vision of the Finance analyses
• Provide governance for reporting (reports production, construction, consistency, user understanding) and anticipate changes
• Support the current and future financial information and management reports by ensuring accurate data collection, thorough analysis, and timely dissemination of insights
  
  

Business Operations

• Actively participate in the daily run and month-end process to support the production of the management reports and Power BI dashboards
• Act as a business subject matter expert and actively participate to the end-to-end delivery cycle of the solutions to ensure optimal coordination and effective execution (i.e. collecting business needs, performing business analysis, providing guidance/orientations to the technical delivery teams, testing the solution and providing training)
• Provide strategic guidance and support for the continuous improvements of the reporting requirements and business processes through the use of python scripts and/or excel VBA
• Coordinate collaboration between IT teams and Finance to facilitate results and efficiency gains
• Prepare adequate documentation on procedures, methodologies, process and controls for operational support
• Provide leadership skills by coaching and supporting team members
  
  

What You’ll Need

• Bachelor’s degree in computer science, finance, accounting or equivalent
• Minimum of seven (7) years of experience in a large organization, preferably in the financial industry and/or in asset management
• Experience in using financial data from investments and financial reports
• Knowledge of Power BI or other visualization tool
• Advanced knowledge of any programming language (SQL, Python, etc.)
• Good understanding of operations related to Private Market investments, an asset
• CFA designation, an asset
• Strong communication and presentation skills with the ability to translate financial concepts into business stories
• Bilingualism: English and French (frequent interactions in English with PSP employees based in our offices in Hong Kong, London and New York, and interactions in French with employees in our local offices in Montreal and Ottawa)
  
  

We offer a tailored employee experience and competitive total rewards and benefits package* designed to attract and retain global diverse talent, reward performance, and reinforce business strategies and priorities. Beyond salary and incentive pay eligibility, you have access to:

• Investment in career development
• Comprehensive group insurance plans
• Competitive pension plans
• Unlimited access to virtual healthcare services and wellness programs
• Gender-inclusive paid family leave policy: up to 26 weeks for primary caregivers, 5 weeks for secondary caregivers
• A personalized family-building support, from pre-pregnancy to menopause, with available financial assistance
• Vacation days available on day one with additional days on milestone service anniversaries, and summer Friday afternoons off
• A hybrid work model with a mix of in-office and remote days
• Benefits package may vary based on your employee type.
  
  

At PSP, we aim to provide an inclusive workplace where we leverage diversity and where everyone feels valued, safe, respected and empowered to grow. As part of this leadership commitment, we strongly encourage applications from all qualified applicants and strive to offer an inclusive and accessible candidate experience. If you require any accommodation for any part of the recruitment process, please let us know.

Visit us on www.investpsp.com/en/

Follow us on LinkedIn

Seniority level

• Seniority level

  Associate

Employment type

• Employment type

  Full-time

Job function

• Job function

  Finance and Sales

• Industries

  Investment Management, Capital Markets, and Financial Services

Referrals increase your chances of interviewing at PSP Investments | Investissements PSP by 2x

Get notified about new Investment Advisor jobs in Montreal, Quebec, Canada.

Investment Advisor, National Partnership Office

Investment Manager - Banking, Credit and Investment

Advisor, Global Strategist, Dynamic Asset Allocation and Currency Management

Advisor/Senior Advisor, Economics, Dynamic Asset Allocation and Currency Management

2025 Wealth Management, Fall Administrative Assistant (4-16 months)- EN

CIBC - Assistant, Investment Advisor - Wood Gundy - Montreal -Bilingual

Saint-Joseph-du-Lac, Quebec, Canada 18 hours ago

Business Development - Financial Security Advisor

Saint-Eustache, Quebec, Canada 4 days ago

Vaudreuil-Dorion, Quebec, Canada 2 weeks ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.