Job Description
Referral Level: 1 Mackenzie Investments IGM Financial Inc. is a leading wealth and asset management company in Canada, managing approximately$310billionin assetsas of December 31, 2025. It offers financial planning and investment services to over two million Canadians through IG Wealth Management and Mackenzie Investments. Mackenzie Investments, founded in 1967, is a key part of IGM's business model, serving as a comprehensive asset-management partner for Canadian financial advisors and their clients. At Mackenzie Investments You Can Build Your Career with Confidence. We are proud to be recognized as one of Canada’s Top 100 Employers for the fourth consecutive year and one of Canada’s Best Diversity Employers. Experience the best of both worlds with our hybrid work environment, where you spend three days a week in the office, connecting, collaborating, and enjoying quality time with your amazing colleaguesReporting to the Director, Portfolio Analytics, the Senior Portfolio Analyst will be a key contributor on the team responsible for delivering timely, accurate and scalable portfolio analytics, reporting and data solutions. This role combines core portfolio analytics, reconciliation and data quality responsibilities with a stronger focus on automation, dashboard development, Python and SQL, and AI-enabled ways of working. The successful candidate will help modernize reporting processes, improve control and transparency, and build reusable tools that support business partners across Mackenzie and Investors Group. Portfolio analytics, reporting and reconciliation: Support the production, validation and delivery of investment performance, portfolio characteristics, analytics and related reporting outputs. Data validation and quality control:



Ensure accurate validation of daily accounting, holdings, returns and analytics data; investigate discrepancies, outliers and data breaks; Automation and process improvement: Design, build and maintain Python, SQL and other automation scripts to streamline recurring reporting, reconciliation, data extraction, exception monitoring and quality control processes. Build and enhance dashboards and self-serve reporting solutions that improve visibility into portfolio analytics, data quality, reconciliation status, operational metrics and business trends. Use approved AI tools to support analysis, documentation, script development, testing and process improvement, while applying appropriate judgement, review and control standards. Research and resolve complex data, reporting and systems issues, including identification of root causes, procedural weaknesses and opportunities for automation. Control and documentation: Maintain clear process documentation, control evidence, data lineage notes, test cases and change records for automated solutions and recurring deliverables. Quality review: Review and verify work completed by others for accuracy, completeness, consistency and adherence to control standards. Project support: Contribute to project work, including requirements gathering, data analysis, user acceptance testing, dashboard prototyping and implementation support. University degree in business, finance, computer science,



data analytics or a related discipline. ~2-5 years of relevant experience in portfolio analytics, performance measurement, investment operations, data analytics, reporting automation or a related function. ~ Strong portfolio accounting knowledge and demonstrated analytical skills. ~ Practical experience with SQL for data extraction, validation, reconciliation and analysis. ~ Practical experience with Python or a comparable programming language for automation, data manipulation, reporting or workflow improvement. ~ Experience building dashboards, management reporting or self-serve analytics using tools such as Power BI, Looker, Tableau or similar platforms. ~ Robust problem-solving skills with the ability to investigate data discrepancies, identify root causes and recommend scalable solutions. ~ High attention to detail and the ability to balance accuracy, control, timeliness and responsiveness. ~ Excellent written and verbal communication skills, including the ability to explain data issues, analytics outputs and technical concepts to business stakeholders. ~ Self-motivated, flexible, adaptable and able to demonstrate initiative in a changing setting. Working towards or completion of a professional designation such as CFA or CIPM. Well-versed in performance measurement principles, including time-weighted returns, money-weighted/internal rates of return, chain linking and annualized returns. Good understanding of derivative instruments, multi-asset portfolios and complex investment products. Experience with FactSet, Eagle, Bloomberg or similar investment data and analytics platforms. Experience with SAP HANA, data warehousing, data modelling or enterprise reporting environments. Exper

📌 Senior Investment Analyst (Canada)
🏢 Mackenzie Investments
📍 Canada