Consultant, Business Insights

McDonald's Canada; Toronto; On-site; CAD 70,000 - 90,000; Full time

Job summary

A leading fast food chain is seeking a Business Insights Consultant for an 8-month contract in Toronto. The role involves providing reporting and analysis support to enhance business performance understanding and inform future strategies. The ideal candidate has 5-7 years of experience in data analysis, can build dashboards, and possesses strong SQL and MS Office skills. This position offers an opportunity to work in a dynamic, fast-paced environment with a commitment to diversity and inclusion.

Qualifications

• 5-7 years’ experience in data analysis or reporting position.
• Experience in building dashboards and reports with various KPIs.
• Knowledge of SQL and proficiency in MS Excel and PowerPoint.

Responsibilities

• Provide regular updates and analysis on category business performance.
• Collaborate with team to consolidate inputs for monthly results.
• Execute consumer regional-focused reporting.

Skills

Data analysis

Reporting

Communication skills

SQL

MS Office proficiency

Dashboard building

Presentation delivery

Education

Undergraduate degree in data, analytics or business

Tools

Tableau

Power BI

Job description

The Opportunity

The Business Insights Consultant 8 month contract role is responsible for providing reporting and analysis support for the Business Insights team. Based in Toronto, the candidate will build reporting solutions to help the regional and the field team understand what drives our business’ current performance and help inform strategy of what will drive performance in the future. The successful candidate will also provide analysis on channel performance and regional marketing promotions. This position is an excellent match for someone with strong business acumen and passion for data insights.

Duties

Business Updates:

• Provide regular updates and analysis on category business performance, including product performance, sales/financial impacts, and market share.
• Support quantifying marketing program performance including program sales/financial impacts and market share.

• Collaborate with team to consolidate inputs to feed into monthly results.
• Support national/regional Operator teams - planning, forecasting and results
• Communicate national/regional business cases and post-analysis information to Owner/Operator community

• Conduct sophisticated analytics to gain deeper cause-and-effect insight into business performance and initiatives, including operations and menu category activities.
• Share and present results to regional stakeholders, including external owner-operators, across the country.

Reporting

• Execute regular consumer regional-focused reporting.
• Collaborate with various stakeholders to gather requirements to understand the needs of the business.
• Design, develop, and test new reporting solutions or enhancements to existing reports.
• Create and launch new reports that provide insights into key performance indicators.

Qualifications

The ideal candidate will possess the following skills and qualifications:

• Work experience: 5-7 years’ experience in data analysis or reporting position in a marketing, business, research or analytics department.
• Education: An undergraduate degree with a data, analytics or business focus
• Experience in building dashboards and reports with various KPIs for a wide range of stakeholders.
• Experienced and capable in working in face-paced, agile, and sometimes high-pressure environment.
• Strong communication and presentation delivery skills and drive for success
• Knowledge of SQL and MS Office proficiency (specifically Excel, PowerPoint) is essential.
• Advanced skills in Tableau, Power BI and/or other similar dashboarding tools
• Dedicated self-starter who can work independently to provide timely support for weekly, monthly, quarterly and ad-hoc reporting.

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.