Consultant, Business Insights (12-month contract)

McDonald's; Toronto; On-site; CAD 77,000 - 102,000; Full time

Benefits offered by this job

Diversity & inclusion

Accommodations on request

Job summary

McDonald’s Canada is seeking a Consultant, Business Insights in Toronto to develop and refine reporting, dashboards, and performance analytics. You will support recurring processes, data validation, and automation using Power BI and AI tools to enable accurate internal decision-making.

The role requires strong analytical skills, experience with data sources, and the ability to build scalable, reliable reporting solutions for cross-functional teams.

Qualifications

• Five to seven years of experience in data analysis, reporting, business intelligence, or related analytics.
• Undergraduate degree with a data, analytics or business focus.
• Experience building, maintaining, validating, and enhancing dashboards and reports for internal users.
• Able to work in a fast-paced, agile environment with multiple priorities.
• Strong analytical thinking, problem-solving, and stakeholder management skills.
• Advanced proficiency in Power BI, SQL, and Microsoft Office (Excel/PowerPoint); AI experience is a plus.

Responsibilities

• Prepare recurring reporting outputs and business updates that summarize key performance trends.
• Consolidate data inputs, validate results, investigate variances, and maintain reporting processes.
• Monitor business trends and translate performance changes into internal insights and leadership presentations.
• Design, test, enhance, and document dashboards and reporting solutions (data models, measures, refreshes).
• Leverage Power BI and Power Query to optimize data formatting and visualization.
• Produce and distribute recurring dashboards for internal users and ensure accuracy and relevance.

Skills

Analytical thinking

Stakeholder management

Communication

Data validation

Documentation

Education

Undergraduate degree in data/analytics or business

Tools

Power BI

SQL

Excel

PowerPoint

Tableau

Alteryx

Python

R

Job description

At McDonald's, we are committed to being the best, and that starts with finding the best people. We have built a team of extraordinary people from around the world. We are problem solvers, risk takers, innovators, and thought leaders that take our work seriously, but have fun doing it. We challenge ourselves to get smarter and sharper every day, we value personal and professional growth, and believe in rewarding and celebrating our successes.

The Opportunity

Company Description:

At McDonald's, we are committed to being the best, and that starts with finding the best people. We have built a team of extraordinary people from around the world. We are problem solvers, risk takers, innovators, and thought leaders that take our work seriously, but have fun doing it. We challenge ourselves to get smarter and sharper every day, we value personal and professional growth, and believe in rewarding and celebrating our successes.

The Opportunity

The Consultant, Business Insights is responsible for developing, maintaining, and improving reporting, dashboards, and business performance analysis for the Business Insights team. Based in Toronto, the candidate will support recurring reporting processes, data validation, dashboard enhancements, documentation, and technical analysis that enable accurate internal decision-making. This role is best suited to someone with strong analytical skills, technical reporting experience, and a focus on building scalable, reliable reporting solutions while leveraging Power BI and Microsoft Co-Pilot.

Who you are

You are a detail-oriented, fact-based problem solver with a technical mindset. You have applicable experience working with various data sources, and establishing relationships between multiple datasets. You have strong capabilities in dashboarding tools such as PowerBI, and able to leverage AI tools like co-pilot. You proactively look for ways to improve accuracy, efficiency, and automation. You thrive in a fast-paced environment and enjoy building reporting solutions that help teams make informed decisions.

Duties

In addition to following McDonald’s policies and procedures, principal accountabilities include, but are not limited to:

Business Updates

• Prepare recurring reporting outputs and business updates that summarize key performance trends accurately and consistently.
• Consolidate data inputs, validate results, investigate variances, and maintain reporting processes across monthly, daily, and ad hoc deliverables.
• Monitor business trends and translate performance changes into clear internal insights and reporting outputs and presentation to senior leadership team as needed.

Technical Reporting and Dashboard Support

• Support regional and national reporting through data pulls, tracking files, competitive outlet reporting, product mix reporting, incentive reporting, and ad hoc analysis.
• Design, test, enhance, and document dashboards and reporting solutions, including data models, measures, refreshes, and reporting views.
• Utilize Power Query and Power BI to optimize data formatting and visualize reporting.

Reporting

• Produce, maintain, and distribute recurring dashboards and reports for internal business users.
• Clarify reporting requirements with internal partners and ensure solutions are accurate, relevant, and fit for purpose.
• Improve reporting accuracy, automation, efficiency, and scalability by resolving data discrepancies, dashboard issues, refresh failures, and reporting gaps.
• Leverage Co-pilot to summarize findings and automate communication routines.

Qualifications

The ideal candidate will possess the following skills and qualifications:

• Work experience: Five to seven years’ experience in data analysis, reporting, business intelligence, or a related analytics function.
• Education: An undergraduate degree with a data, analytics or business focus.

• Experience building, maintaining, validating, and enhancing dashboards and reports for internal business users.
• Experienced and capable of working in a fast-paced, agile, and sometimes high-pressure environment while managing recurring timelines and multiple priorities.
• Strong analytical thinking, technical problem-solving, communication, documentation, and stakeholder management skills.
• Advanced proficiency in Power BI, SQL, and Microsoft Office, specifically Excel and PowerPoint
• Proficiency and experience in leveraging AI
• Experience with data modelling, visualization design, refresh management, and automation; Tableau, Alteryx, Python, or R is an asset.
• Detail-oriented self-starter with sound data validation practices and the ability to support weekly, monthly, quarterly, and ad hoc reporting.

.

Salary Range

The expected salary range for this role is $77,000 - $102,000 per year
The above represents the expected salary range for this job requisition. Ultimately, in determining your pay, we may also consider your experience, and other job-related factors. This is for an existing role.

Additional Information:

McDonald’s Canada and Owner/Operators are committed to a diverse and inclusive workplace for all. Our workplaces have a long-standing policy of providing fair, equitable, and accessible opportunities for all employees and prospective employees. Accommodations during the application process are available upon request.
We do not use artificial intelligence (AI) or automated tools to screen, assess, or select applicants during our recruitment process