Consultant, Business Insights (Contract)

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

Job summary

A leading company in the fast-food industry is seeking a Business Insights Consultant to provide reporting and analysis support. The ideal candidate will have 5-7 years of experience in data analysis, strong business acumen, and expertise in building dashboards with tools like Tableau and Power BI. This role offers an opportunity to collaborate with various stakeholders while contributing to the overall performance strategy of the business.

Qualifications

• 5-7 years’ experience in a data analysis or reporting position.
• Experience in building dashboards and reports with various KPIs.
• Strong communication and presentation skills.

Responsibilities

• Provide analysis on category business performance.
• Design, develop, and test new reporting solutions.
• Conduct sophisticated analytics for deeper insights.

Skills

Data analysis

Communication

Presentation

Business acumen

SQL

MS Office

Dashboard building

Tableau

Power BI

Education

Undergraduate degree with a data, analytics or business focus

Tools

Tableau

Power BI

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

The Business Insights Consultant 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& 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.