Data Analytics & Automation Specialist - Asset Management Digital Solutions, AMDS

Overview

At KPMG in Canada, our people bring their unique perspectives to Canada’s most important challenges. Here, you can build momentum that reaches beyond our business, develop skills for the future, and take ownership of your career with support at every stage. Join a firm where your career can make a difference.

KPMG Asset Management Digital Solutions (KPMG AMDS) sparks innovation and fuels change to unlock value and prepare for the future. KPMG AMDS helps organizations discover opportunities through our far-reaching innovation and intelligence capabilities. The team is committed to learning and development and solving tax technology problems for the firm.

We are seeking a hands-on Data Analytics & Automation Specialist with 3+ years of relevant experience to build and scale data, reporting, and process-automation solutions.

The Specialist will work directly with business stakeholders to understand their needs and translate them into practical, reliable, and maintainable solutions using Power BI, Alteryx, Power Query, SQL, VBA, Python, and related technologies.

What you will do

• Work with business stakeholders to understand processes, reporting requirements, data challenges, and automation opportunities.
• Translate business requirements into practical data, reporting, and workflow solutions.
• Design, build, test, deploy, and maintain solutions using Power BI, Alteryx, Power Query, SQL, VBA, Python, and Excel.
• Develop interactive Power BI reports, dashboards, data models, measures, and calculations.
• Build data preparation, transformation, integration, and automation workflows.
• Use scripts and queries to clean, validate, reconcile, and analyze data.
• Scale prototypes and manual processes into reusable, documented, and supportable solutions.
• Implement appropriate data-quality checks, error handling, controls, and reconciliation processes.
• Troubleshoot data, reporting, refresh, workflow, and performance issues.
• Optimize dashboards, queries, data models, and workflows for performance and maintainability.
• Document business rules, data sources, calculations, solution designs, and operating procedures.
• Support deployed solutions and communicate progress, risks, dependencies, and technical issues to Managers and stakeholders.
• Follow applicable data security, confidentiality, governance, and compliance requirements.

AI-enabled analytics and automation

• Use approved AI tools to assist with data analysis, query and script development, workflow design, troubleshooting, testing, documentation, and technical research.
• Review and validate AI-generated SQL, Python, VBA, DAX, Power Query, analyses, and documentation before use.
• Remain accountable for the accuracy, security, reliability, and business appropriateness of AI-assisted work.
• Identify opportunities to combine AI, analytics, and automation to improve business processes and reduce manual effort.
• Apply sound judgment when evaluating AI-generated results, including their assumptions, limitations, and potential data-quality issues.
• Follow organizational and client requirements for confidentiality, data handling, security, and acceptable AI use.

What you bring to the role

• Bachelor's degree in Computer Science or Data Science or Engineering.
• Certifications - Cloud Data certifications and/or product management certifications.
• 3+ years of relevant experience in data analytics, business intelligence, reporting, automation, data solutions, or a related field.
• Hands-on experience with:
• Power BI
• Power Query
• Alteryx
• SQL
• Advanced Excel and VBA
• Working knowledge of Python for data analysis, scripting, or process automation.
• Experience developing Power BI data models, reports, dashboards, and DAX calculations.
• Understanding of data transformation, integration, modeling, validation, and reconciliation concepts.
• Experience gathering requirements and working directly with business stakeholders.
• Demonstrated ability to convert business needs and manual processes into scalable technical solutions.
• Ability to write clear, maintainable scripts, queries, calculations, and workflows.
• Strong analytical, troubleshooting, and problem-solving skills.
• Ability to manage multiple assignments and adapt to changing business priorities.
• Strong written and verbal communication skills.
• Ability to explain data and technical concepts to non-technical stakeholders.
• Experience using AI-assisted tools, or demonstrated ability and willingness to incorporate them responsibly into analytics and automation work.

KPMG Ontario Region Pay Range Information

The expected base salary range for this position is $75,500 to $125,500 and may be eligible for bonus awards. The determination of an applicant’s base salary within this range is based on the individual’s location, skills & competencies, and unique qualifications. In addition, KPMG offers a comprehensive and competitive Total Rewards program.

Providing you with the support you need to be at your best

For more information about KPMG in Canada’s Benefits and well-being, click here. 

Our Values, The KPMG Way

Integrity, we do what is right | Excellence, we never stop learning and improving | Courage, we think and act boldly | Together, we respect each other and draw strength from our differences | For Better, we do what matters

KPMG in Canada is a proud equal opportunities employer and we are committed to creating a respectful, inclusive and barrier-free workplace that allows all of our people to reach their full potential. A diverse workforce is key to our success and we believe in bringing your whole self to work. We welcome all qualified candidates to apply and hope you will choose KPMG in Canada as your employer of choice.

Adjustments and accommodations throughout the recruitment process

At KPMG, we are committed to fostering an inclusive recruitment process where all candidates can be themselves and excel. We aim to provide a positive experience and are prepared to offer adjustments or accommodations to help you perform at your best. Adjustments (informal requests), such as extra preparation time or the option for micro breaks during interviews, and accommodations (formal requests), such as accessible communication supports or technology aids, are tailored to individual needs and role requirements. You will have an opportunity to request an adjustment or accommodation at any point throughout the recruitment process. If you require support, please contact KPMG’s Employee Relations Service team by calling 1-888-466-4778.

AI Usage

We embrace the use of artificial intelligence (AI) to enhance the candidate experience and streamline our recruitment processes. AI tools may help with organizing applications or surfacing relevant qualifications. However, no hiring decisions are made using AI. Every hiring decision is made by our hiring managers and recruitment professionals, who are equipped with training that empowers them to use these tools responsibly. AI technologies used in our recruitment process undergo detailed risk assessments, including security and privacy requirements, that align with KPMG’s Trusted AI framework.

We believe technology should empower human judgment, not replace it. It’s one of the many ways we’re delivering on our vision of being a technology-first, people-driven firm.