Business Insights Lead — Power BI & AI Dashboards

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

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.