Consultant, Business Insights (12-month contract)

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

Job summary

McDonald’s Canada is seeking a data analytics professional to join our Toronto team. You will build and optimize dashboards using Power BI, harness AI-assisted insights, and partner with stakeholders to translate data into actionable business updates.

The role requires 5–7 years in data analytics, a data-focused undergraduate degree, strong SQL/Excel skills, and the ability to manage multiple priorities in a fast-paced environment.

Qualifications

• Five to seven years’ experience in data analysis, reporting, business intelligence, or a related analytics function.
• Undergraduate degree with a data, analytics or business focus.
• Experience building, maintaining, validating, and enhancing dashboards and reports for internal users.
• Fast-paced, agile environment with multiple priorities and deadlines.
• Strong analytical thinking, problem-solving, communication, documentation, and stakeholder management.
• Advanced proficiency in Power BI, SQL, and Microsoft Office (Excel, PowerPoint).
• Proficiency in AI usage for analytics and automation; familiarity with Tableau/Alteryx/Python/R is a plus.
• Experience with data modelling, visualization, refresh management, and automation; dashboards and reports must be scalable.

Responsibilities

• Prepare recurring reporting outputs and business updates that summarize key performance trends.
• Consolidate data inputs, validate results, investigate variances, and maintain reporting processes across monthly, daily, and ad hoc deliverables.
• Design, test, enhance, and document dashboards and reporting solutions, including data models and measures.
• Produce, maintain, and distribute recurring dashboards and reports for internal business users.

Skills

Power BI

SQL

Excel

Data analysis

AI tools

Dashboard development

Stakeholder management

Education

Undergraduate degree in data/analytics/business

Tools

Tableau

Alteryx

Python

R

Job description

Job Description:

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

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