Consultant, Business Insights

Socket.dev; Toronto; On-site; CAD 77,000 - 102,000; Full time

Job summary

McDonald's Canada is seeking a Consultant, Business Insights based in Toronto. You will develop, maintain, and improve reporting, dashboards, and performance analysis to enable accurate internal decision-making.

You will leverage Power BI and Co-pilot for automation, data validation, and scalable reporting solutions, collaborating with cross-functional partners and senior leadership 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 business users.
• Able to work 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.

Responsibilities

• 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.
• 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.
• 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.

Skills

Power BI

SQL

Excel

Power Query

AI tools

Data analysis

Stakeholder management

Education

Bachelor's degree in data analytics or business

Tools

Tableau

Alteryx

Python

R

Microsoft Office

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 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