Insight Analyst/Senior Insight Analyst

The Home Depot Canada

Toronto

On-site

CAD 80,000 - 100,000

Full time

22 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Semi-annual bonuses
Deferred Profit-Sharing Program
Comprehensive benefits
15% stock purchase discount
Merit-based salary increases

Job summary

The Home Depot Canada is seeking an Insights Analyst or Senior Insights Analyst to own reporting and insights for finance and merchandising leaders. You will manage weekly reporting, build dashboards, and drive data-driven recommendations across sales, margin, and store performance.

You will lead data quality, automate workflows from Alteryx to SQL/Python, and explore AI-enabled solutions to improve partner decision-making. Strong SQL/Tableau skills preferred.

Qualifications

  • Education: Bachelor's degree in Business Analytics, Finance, Economics, Statistics, Computer Science, Engineering.
  • Experience: 2–4 years for Insights Analyst or 4–6 years for Senior Insights Analyst in analytics, BI, or related field.
  • Certifications (Bonus): Tableau or Alteryx certifications.

Responsibilities

  • Own weekly and period-end reporting for sales, margin, and performance.
  • Build and maintain Tableau dashboards and store/district scorecards.
  • Explain drivers behind results and provide actionable recommendations.
  • Perform ad hoc and deep-dive analyses on trends and shifts.
  • Own data quality, automate reports, and explore AI-enabled workflows.

Education

Bachelor's degree in Business Analytics / Finance / Economics / Statistics / Computer Science / Engineering

Tools

SQL
Tableau
Alteryx
BigQuery
Python
Power Query
Excel

Job description

Pay Range: $80,000 - $100,000

At The Home Depot Canada, we want you to feel valued and supported. The pay range you see represents base salary only. In addition, your total rewards may include: semi-annual bonuses tied to business performance; Deferred Profit-Sharing Program to assist with retirement savings; comprehensive paid benefits; a 15% discount on Home Depot stock purchases; and merit-based salary increases. We are committed to recognizing your efforts and supporting your growth with us.

At The Home Depot Canada, we want you to feel valued and supported. The pay range you see represents base salary only. In addition, your total rewards may include: semi-annual bonuses tied to business performance; Deferred Profit-Sharing Program to assist with retirement savings; comprehensive paid benefits; a 15% discount on Home Depot stock purchases; and merit-based salary increases. We are committed to recognizing your efforts and supporting your growth with us.

At The Home Depot Canada, we want you to feel valued and supported. The pay range you see represents base salary only. In addition, your total rewards may include: semi-annual bonuses tied to business performance; Deferred Profit-Sharing Program to assist with retirement savings; comprehensive paid benefits; a 15% discount on Home Depot stock purchases; and merit-based salary increases. We are committed to recognizing your efforts and supporting your growth with us.

Pay Range: $80,000 - $100,000

At The Home Depot Canada, we want you to feel valued and supported. The pay range you see represents base salary only. In addition, your total rewards may include: semi-annual bonuses tied to business performance; Deferred Profit-Sharing Program to assist with retirement savings; comprehensive paid benefits; a 15% discount on Home Depot stock purchases; and merit-based salary increases. We are committed to recognizing your efforts and supporting your growth with us.

At The Home Depot Canada, we want you to feel valued and supported. The pay range you see represents base salary only. In addition, your total rewards may include: semi-annual bonuses tied to business performance; Deferred Profit-Sharing Program to assist with retirement savings; comprehensive paid benefits; a 15% discount on Home Depot stock purchases; and merit-based salary increases. We are committed to recognizing your efforts and supporting your growth with us.

At The Home Depot Canada, we want you to feel valued and supported. The pay range you see represents base salary only. In addition, your total rewards may include: semi-annual bonuses tied to business performance; Deferred Profit-Sharing Program to assist with retirement savings; comprehensive paid benefits; a 15% discount on Home Depot stock purchases; and merit-based salary increases. We are committed to recognizing your efforts and supporting your growth with us.

Position Purpose:

Can you look at last week's numbers and tell a business leader what moved, why it moved, and what to do about it? That's everyday work for our Decision Analytics team in Finance. We build the data products, scorecards, and AI tools that finance and merchandising leaders across The Home Depot Canada rely on. And we do it in a company built on strong relationships and respect for all people.

In this role, you will own the reporting and insights that finance and merchandising leaders use to track business performance, from sales and margin results to store and district scorecards. You will run and automate the weekly reporting cycle, explain what is driving the numbers, and turn results into recommendations leaders act on. We're hiring at the Insights Analyst or Senior Insights Analyst level, depending on experience; senior hires work more independently and lead product ownership.

Key Responsibilities And Tasks Key Responsibilities Tasks
Business Performance Reporting & Insights
  • Business Performance Reporting: Own the weekly and period-end reporting that leaders use to track sales, margin, and comp performance, including the complex workflows behind it, and keep it accurate, documented, and on time.
  • Metric Ownership: Own the definitions and business rules behind the metrics you report, and keep them consistent as merchandise hierarchies, stores, and plans change. Know how partners read each metric and which decisions it feeds.
  • Scorecards & Dashboards: Build and maintain Tableau dashboards, including store and district scorecards, that business users trust and can read at a glance.
  • Performance Insights: Explain what drove the results, not only what changed, and lead with recommendations partners can act on.
  • Ad Hoc & Deep-Dive Analysis: Answer leaders' questions quickly, and dig into emerging trends, such as economic and consumer shifts, when the weekly view isn't enough.
Data Quality, Automation & AI Innovation
  • Root-Cause Troubleshooting: Own data quality in your reports end to end. Trace a wrong number back to its cause, fix what's in scope, and hand analytics engineering a clear diagnosis rather than a symptom.
  • Workflow Modernization: Lead the automation of the reporting you own, moving legacy workflows, including Alteryx, to SQL- and Python-based processes, with support from analytics engineering on pipelines and scheduling.
  • AI Integration: Use enterprise AI tools such as Gemini, Copilot, and NotebookLM to automate workflows and build AI agents or assistants for partner teams.
Cross-Functional Collaboration & Business Impact
  • Product Ownership: Act as the business-side owner for analytics tools, writing requirements and acceptance criteria, validating what analytics engineering builds, and driving adoption.
  • Business Partnership: Build working relationships with finance, merchandising, and operations partners, including the teams that depend on your reports. Learn how they use your work, ask for feedback, and spot where better reporting or AI could help.
  • Communication: Present insights and recommendations to technical and non-technical audiences, and explain technical issues and their impact in plain language.
Nature and Scope
  • Position reports to manager or above.
  • This position has no direct reports.
  • Typically does not require travel.
  • Weekly reporting requires an early start on Monday mornings.
Minimum Requirements
Education & Experience
  • Education: Bachelor's degree in Business Analytics, Finance, Economics, Statistics, Computer Science, Engineering, or a related quantitative field.
  • Experience: 2–4 years for Insights Analyst or 4–6 years for Senior Insights Analyst, in analytics, business intelligence, or a related field. Retail experience is highly beneficial.
  • Certifications (Bonus): Relevant certifications are an asset, such as Tableau or Alteryx certifications.
Technical Proficiency
  • SQL (Must-Have): Writing complex SQL in a cloud warehouse (BigQuery preferred) and finding why a query returns the wrong number.
  • Tableau (Must-Have): Building and maintaining dashboards that business users rely on.
  • Troubleshooting (Must-Have): Tracing a wrong number to its source and telling data, logic, and business-rule issues apart.
  • Automation (Must-Have): Taking a manual, recurring report and automating it end to end, from data pull to delivery.
  • AI Fluency (Must-Have): Using AI tools daily, checking their output, building with them, and knowing what data stays out.
  • Microsoft Office (Must-Have): Using advanced Excel, such as Power Query, XLOOKUP, dynamic array formulas, and scenario models, and building PowerPoint presentations for business partners.
  • Python (Asset): Transforming data and automating workflows; reading and explaining others' code.
  • Legacy Workflows (Asset): Running, documenting, and migrating workflows built by others; Alteryx experience preferred.
  • Requirements (Asset): Writing requirements and acceptance criteria analytics engineers can build from.
  • Statistics & Forecasting (Asset): Using statistical methods or simple forecasts to explain trends and project results.
Skills & Competencies
  • Financial Acumen (Must-Have): Strong understanding of retail financial performance drivers, including comp sales, sales to plan, traffic and ticket, run rates, margin, and profitability. Connects metrics across the business and can explain underlying performance drivers and trade-offs.
  • Business Insight: Applies knowledge of the retail business, market dynamics, and financial performance to identify opportunities, solve problems, and support informed decision-making.
  • Consultative Partnership: Influences decisions through insight, curiosity, and constructive challenge while empowering partners to own solutions and outcomes.
  • Drives Results: Delivers high-quality outcomes, maintains accountability, and consistently executes against commitments, even in complex or challenging situations.
  • Action Oriented: Embraces new opportunities and tackles challenges with urgency, initiative, and a bias for action.
  • Collaborates & Communicates Effectively: Builds strong partnerships across functions and communicates clearly and appropriately to diverse audiences, fostering alignment and shared success.
  • Customer Focus: Keeps internal and external customer needs at the centre of decisions and delivers solutions that create value.
  • Planning & Prioritization: Effectively plans, prioritizes, and aligns work to meet commitments and support organizational objectives.
  • Continuous Improvement & Process Optimization: Seeks opportunities to improve processes, eliminate inefficiencies, and enhance effectiveness through continuous improvement.
  • Learning Agility & Self-Development: Demonstrates curiosity, learns quickly from experience, and actively pursues opportunities for personal and professional growth.

In our commitment to efficiency, consistency, and a fair hiring experience for all candidates, The Home Depot Canada usesArtificial Intelligence (AI) technology to assist with the screening and assessment of applicants for this position. Our process is designed to ensure human oversight is maintained throughout the selection process.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Insight Analyst/Senior Insight Analyst
Insight Analyst/Senior Insight Analyst

The Home Depot, Inc. • Toronto

On-site
CAD 80,000 - 100,000
Semi-annual bonuses
Deferred Profit-Sharing Program
Comprehensive paid benefits
+2
ANALYSTE PRINCIPAL, PERSPECTIVES COMMERCIALES, FINANCES
ANALYSTE PRINCIPAL, PERSPECTIVES COMMERCIALES, FINANCES

The Home Depot Canada • Toronto

On-site
CAD 70,000 - 79,000
Sr Analyst, Reporting and Analytics
Sr Analyst, Reporting and Analytics

The Home Depot • Toronto

On-site
CAD 85,000 - 115,000
Semi-annual bonuses
Deferred Profit-Sharing
Benefits
+2
Senior Financial Analyst, Hardlines
Senior Financial Analyst, Hardlines

The Home Depot Canada • Toronto

On-site
CAD 80,000 - 100,000
Semi-annual bonuses
Profit-sharing
Benefits
+2
Senior Financial Analyst, Contractor Services
Senior Financial Analyst, Contractor Services

Home Depot • Toronto

On-site
CAD 70,000 - 100,000
Semi-annual bonuses
Deferred Profit-Sharing Program
Comprehensive benefits
+2
Manager, Data Analytics
Manager, Data Analytics

The Home Depot • Vaughan

On-site
CAD 73,400 - 85,700
Analyst, Online Customer Experience (6 month contract)
Analyst, Online Customer Experience (6 month contract)

Home Depot • Toronto

Hybrid
CAD 60,000 - 90,000
Stock purchase discount
Merit-based raises
Analyst Online Customer Experience (Contract) – Future Opportunities
Analyst Online Customer Experience (Contract) – Future Opportunities

Home Depot • Toronto

On-site
CAD 60,000 - 90,000
BUSINESS ANALYST (6 month contract)
BUSINESS ANALYST (6 month contract)

The Home Depot Canada • Toronto

On-site
CAD 60,000 - 90,000
Semi-annual bonuses
Deferred Profit-Sharing Program
Comprehensive benefits
+2
Senior Insights Analyst: AI-Powered Finance Analytics
Senior Insights Analyst: AI-Powered Finance Analytics

The Home Depot Canada • Toronto

On-site
CAD 80,000 - 100,000
Semi-annual bonuses
Deferred Profit-Sharing Program
Comprehensive benefits
+2