Analyst, Investment , Analytics & Reporting; SQL, Power BI, Python - Remote

Analyst, Investment Performance, Analytics & Reporting (SQL, Power BI, Python) - Remote across Canada

Job Description : Our client is looking for Analyst, Investment Performance, Analytics & Reporting (SQL, Python, Power BI) - Remote across Canada!

• Bachelor’s degree in finance, business or a quantitative field such as mathematics, computer science with a finance component is preferred.
• Demonstrates a clear ability to analyze, interpret and articulate financial data.
• Strong problem‑solving skills and thrives under pressure and deadlines.
• Strong relationship building, communication and writing skills. Proven attention to detail and eye for accuracy.
• Demonstrates a strong commitment to AIMCo’s core values of excellence, transparency, humility, integrity and collaboration, while inspiring the same in others.

• 2 years of experience in pension, investment management, or investment reporting is a strong asset.
• Knowledge of institutional investments, portfolio management, pension and endowment financing is desirable.
• Advanced skills in Excel, PowerPoint, Publisher and Word are desirable.
• Ability to translate investment data information into meaning client commentary is desirable.
• Pursuing Investment‑related designations such as CFA, FRM, CIPM, CAIA etc. is desirable.
• Knowledge of SQL querying and data science is desirable.
• Investment knowledge and experience with SQL, Python and Power BI tools are desirable.

• Work with other members of the team to bring new ideas into fruition.
• Gather various data and commentary from internal stakeholders to produce monthly and quarterly investment reports for clients and consultants.
• Provide reporting to Company's Executives and Board members.
• Improve checks and reduce manual processes through automation.
• Responding to inquiries from clients and client consultants in a consultative and timely manner.
• Learn and understand Company's investment pools and client asset mandates to provide excellent service to our clients.
• Participate in the implementation of reporting and operational enhancement requests.
• Fulfill ad hoc external client and consultant inquiries, including working with various internal stakeholder teams to gather the appropriate information.
• Learn and understand performance methodologies and systems to improve productivity, increasing the value of performance results.
• Assist in the development of client‑centric contribution and attribution commentary to supplement investment reports.
• Participate in new projects relating to Investment Performance, Analytics and Reporting including Btx.

Contact:

• Software
  • Must have at least 2 years of experience with/in PowerBI
• Databases
  • Experience in at least 2 years of experience with/in Database MySQL, Oracle, SQL, PL/SQL