Senior Data Systems Analyst

Grade:  P6

Referral Level: Level 1

Division: IGM-Tech

IGM Financial Inc. is one of Canada's leading diversified wealth and asset management companies with approximately $271 billion in total assets under management. The company provides a broad range of financial planning and investment management services to help more than two million Canadians meet their financial goals. Its activities are carried out principally through IG Wealth Management and Mackenzie Investments. 

Under IGM Financial's unique business model based on leading brands and multi-channel distribution strategy is Mackenzie Investments, founded in 1967. Mackenzie Investments is a holistic asset-management partner for thousands of Canadian financial advisors and the investors they support.   

At Mackenzie Investments You Can Build Your Career with Confidence. 

We have a vision and a strategy that will challenge the way business in this industry is done and help Canadians be successful in the ways that mean the most to them. As part of our team, you will do some of your best work, develop some of your most valuable skills and give back in ways that make a difference in the lives of Canadians.  We are proud to be recognized as one of Canada's Top Employers by Mediacorp Canada Inc. for empowering our employees with the tools to thrive, while also providing resources to ensure physical and mental wellness were put front and centre. 

Join an unstoppable team that is embedded in continuous learning, understanding, and knowledge sharing. You will thrive in our supportive environment where you can indulge your curiosity to learn, while receiving the feedback you need to refine your skills and abilities. We are dedicated to offering a hybrid work environment when applicable. 

Mackenzie Investments is a diverse workplace committed to doing business inclusively - this starts with having a representative workforce We encourage applications from all qualified candidates that represent the diversity present across Canada – including racialized persons, women, Indigenous persons, persons with disabilities, 2SLGBTQIA+ community, gender diverse and neurodiverse individuals, as well as all who may contribute to the further diversification of ideas.  

Position Summary

The Systems Analyst will analyze, design and test software solutions to meet our business objectives. They have outstanding problem-solving abilities and can communicate their ideas easily to others. They are willing to learn to technologies and eager to apply their learning's in a fast-paced environment.

 Duties Include:

• Liaises with business stakeholders and other teams to understand business objectives and design a solution that will meet their analytics and management reporting needs.
• Elicits requirements from business stakeholders through interviews, workshops, business process analysis, business scenarios, and user stories.
• Analyzes and conceptualizes the design of the data solution, working with the Systems Architect and Software Developer to achieve the client stakeholder objectives through effective deployment of technology.
• Analyzing source or target system data requirements and mapping the data to match the enterprise data platform design.
• Identifying outlying data patterns and data cleanliness issues for resolution.
• Documenting the high-level design and data flows end-to-end.
• Design of models (including dimensional models, views, table functions, etc.), ensuring alignment to standards both industry (e.g., Kimball) and internal (e.g. security, data governance).
• Ensuring the quality of the solution by creating test plans and testing the results of the development meets the requirements of the business.

Qualifications:

• Post-secondary degree/diploma in a related discipline (CMA, MBA, Management Information Systems, Commerce, Business Analysis, and Computer Science).
• 3+ years' experience working with business principles and a broad range of different types of business functions.
• Strong understanding of IS Methodologies, processes, and practices.
• Experience with data systems analysis and data warehouse design. Strong SQL skills.
• Strong analytical and problem-solving skills that rely on a structured approach to problem solving.
• Strong communication and interpersonal skills with a demonstrated ability to work effectively in a team environment.
• Effective planning and organizational skills with the ability to adapt to change and perform effectively under pressure.
• Experience in Financial Services and Wealth Management industries would be an asset.
• Experience in Tableau, Looker or SAP HANA would be an asset.

Please visit our career page by clicking on the following link:  

We thank all applicants for their interest in Mackenzie Investments; however, only those candidates selected for an interview will be contacted.  

Mackenzie Investments is an accessible employer committed to providing a barrier free recruitment experience. If you require an accommodation or this information in an alternate format at any stage of the recruitment process, please reach out to the Talent Acquisition team who will work with you to meet your needs.  

#LI-JS2 

#LI-Hybrid 

#LI-Hybrid