Consultant, Business Insights

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

Job summary

McDonald’s Canada is seeking a data analytics professional to develop and maintain dashboards and reporting solutions. You will work with Power BI, SQL, and Excel to deliver insights for regional and national stakeholders.

The role requires 5–7 years of BI experience, an undergraduate degree in data analytics or business, and the ability to thrive in a fast-paced environment. Hybrid work options and competitive compensation are offered.

Qualifications

• Five to seven years’ experience in data analysis, reporting, or business intelligence.
• Undergraduate degree with a data, analytics or business focus.
• Experience building and maintaining dashboards for internal users.
• Ability to work in a fast-paced, agile environment with multiple priorities.
• Strong analytical thinking, problem-solving, communication, and stakeholder management.

Responsibilities

• Prepare recurring reporting outputs and business updates summarizing key performance trends.
• Consolidate data inputs, validate results, investigate variances, and maintain reporting processes.
• Monitor business trends and translate performance changes into insights for senior leadership.
• Design, test, enhance, and document dashboards and reporting solutions using Power BI.
• Use Power Query and Power BI to optimize data formatting and visualization.
• Produce and distribute recurring dashboards and reports for internal users and partners.
• Leverage AI tools to summarize findings and improve communication routines.

Skills

Power BI

SQL

Excel

PowerPoint

AI

Data modelling

Tableau

Alteryx

Python

R

Education

Undergraduate degree in data analytics or business

Tools

Power BI

SQL

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