Mackenzie Investments

  • Senior Data Systems Analyst (Data Office)

    Job Location CA-ON-Toronto
    Posted Date 3 weeks ago(9/27/2018 9:26 AM)
    Reference Number
    # Positions
    Job Type
    Full Time
    Job Industry
    Financial Services and Banking
    Career Level
    Years of Experience
  • Job Description

    IGM Financial Inc. is one of Canada's premier personal financial services companies, and one of the country's largest managers and distributors of investment funds and other managed asset products, with over $156 billion in total assets under management as of March 31, 2018. Its activities are carried out principally through Investors Group Inc., Mackenzie Investments and Investment Planning Counsel Inc.


    As part of Power Financial Corporation, we are focused on the long-term strength and stability of our companies. We recognize these as core responsibilities to our clients and shareholders as we adapt and lead in an ever-changing world.


    The IS Services Division provides information technology solutions and support to the Power Financial group of companies:  Investors Group, Mackenzie Financial, Great-West Life, London Life and Canada Life. The Data Office oversees the technology management and governance of IGM’s data assets. This includes providing enterprise Data services, advancing & expanding our Data Hubs, overseeing the re-platforming of legacy assets, supporting core data intensive applications and delivering the data component of data intensive projects.


    This is a very exciting time at Mackenzie Investments, especially in the Data Office.  We are adopting extensive technological change to thrive in the new and changing Financial Services industry.  We are embracing big data, cloud computing, and high-performance data appliances in a delivery focused Agile environment. 



    The Systems Analyst maintains a “business perspective” through all phases of the project and works with the entire IS project team to assist in the planning, designing and launching of new solutions in support of our growing business needs.



    • Liaises with business stakeholders to understand industry trends and business objectives in order to design the solution that will meet their decision support 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 the transactional system data requirements and modeling the data design to match the enterprise data warehouse design.
    • Querying and reviewing large data stores to understand the transactional information and business rules that govern the data. Identifying outlying data patterns and data cleanliness issues for resolution.
    • Working with the data architecture team to understand the design of the data warehouse containers/cubes.
    • Documenting the system specifications for the software development team.
    • Ensuring the quality of the solution by testing the results of the development meets the requirements of the business.


    • Post secondary degree/diploma in a related discipline (CMA, MBA, Management Information Systems, Commerce, Business Analysis, and Computer Programmer/Analyst).
    • 5+ years experience working with business principles and a broad range of different types of business functions.
    • Strong understanding of IS Methodologies, processes and practices, and experience with data systems analysis and data warehouse design.
    • 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 considered an asset.


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

    Mackenzie Investments offers an exciting and challenging work environment, a competitive base salary, performance-based bonuses, excellent benefits, recognition for your accomplishments, and opportunities for personal and professional growth.

    Mackenzie Investments is an equal opportunity employer and is committed to providing employment accommodations in accordance with the Ontario Human Rights Code and the Accessibility of Ontarians with Disabilities Act. Please advise Human Resources if you require an accommodation.


    File #18-217


    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed