FINANCIAL ANALYST, Offshelf

The Home Depot

About The Position

With a career at The Home Depot, you can be yourself and also be part of something bigger. Do you have a learning mindset and a passion for data-driven decision-making? Do you thrive in a dynamic environment where you can leverage technology to uncover efficiencies? Would working in a highly collaborative and relationship driven company that values respect for everyone excite you? Look no further than Home Depot Canada. We are trusted financial partners, working collaboratively to identify challenges, uncover efficiencies, and drive impactful results. As a Financial Analyst – Offshelf & Events, you will act as the technical bridge between Finance, Merchandising, Marketing and Operations. You will not only manage the tracking and forecasting of Offshelf programs but also design and develop the BI infrastructure that supports them. In this role, you will move beyond static reporting to build scalable data solutions, automating complex workflows to provide "the why" behind the numbers—delivering predictive insights and actionable narratives to optimize SKU productivity and event profitability. At the Home Depot the Financial Analyst is responsible for: Design, develop, and maintain advanced Tableau dashboards, leveraging complex calculations (LODs) and parameters to visualize real-time sales trends and inventory flow, ensuring timely updates and driving actionable insights. Produce weekly financial performance decks and executive summaries that highlight sales results, comps, units, inventory, and variance drivers. Provide in-depth post-mortem analysis for major high-traffic events to inform future strategy. Own the validation of data for sales, units, and inventory; maintain event shells and ensure correct mapping of articles/SKUs across systems Lead the financial forecasting process for Offshelf & Event (OE) programs. Partner with Canadian stakeholders and US-based finance groups to build accurate projections, utilizing statistical modeling to validate merchant submissions against sales trends. Construct complex, variable-based financial models in Excel (using Power Query/Pivot) to test scenarios such as event duration changes, load-in timing, and inventory elasticity. Act as the primary analytics partner to Merchandising, Replenishment, and Marketing. Translate complex datasets into clear, non-technical business narratives and present insights during alignment meetings to influence strategy. Proactively identify opportunities to refactor legacy processes and simplify assortments. Use automation tools to reduce manual rework, optimize low-productivity SKUs, and increase speed-to-insight for leadership teams. Lead special projects and provide real-time insights to support testing, new initiatives, and ad-hoc leadership requests.

Requirements

Bachelor’s or Master’s degree in Finance, Business Analytics, Data Science, or a related quantitative field.
3–5 years of experience in Financial Analysis, Business Intelligence, or FP&A.
Advanced proficiency in Tableau is required, with the ability to build dashboards from scratch, blend data sources, and optimize performance for end-users.
Strong experience with GBQ/SQL (writing complex queries, joins, and aggregations) and/or Alteryx (building workflows for data cleansing and blending) is essential.
Expert-level proficiency in Excel, including experience with Power Query, Power Pivot, complex formula auditing, and the ability to build complex financial models and scenarios.
Proven ability to manage, cleanse, and analyze large datasets with a high degree of accuracy.
Experience troubleshooting data discrepancies in a data warehouse environment.
A focus on building repeatable, scalable solutions rather than one-off fixes.
Ability to bridge the gap between technical data findings and business strategy, presenting clear insights to Directors and VPs.
A flexible, solution-oriented mindset with the ability to manage competing priorities in a fast-paced retail environment.

Nice To Haves

Retail experience with high-volume transactional data is highly preferred.
Internal candidates must meet minimum time-in-position (1 year) and performance management requirements (M+ rating or higher).

Responsibilities

Design, develop, and maintain advanced Tableau dashboards, leveraging complex calculations (LODs) and parameters to visualize real-time sales trends and inventory flow, ensuring timely updates and driving actionable insights.
Produce weekly financial performance decks and executive summaries that highlight sales results, comps, units, inventory, and variance drivers.
Provide in-depth post-mortem analysis for major high-traffic events to inform future strategy.
Own the validation of data for sales, units, and inventory; maintain event shells and ensure correct mapping of articles/SKUs across systems
Lead the financial forecasting process for Offshelf & Event (OE) programs.
Partner with Canadian stakeholders and US-based finance groups to build accurate projections, utilizing statistical modeling to validate merchant submissions against sales trends.
Construct complex, variable-based financial models in Excel (using Power Query/Pivot) to test scenarios such as event duration changes, load-in timing, and inventory elasticity.
Act as the primary analytics partner to Merchandising, Replenishment, and Marketing.
Translate complex datasets into clear, non-technical business narratives and present insights during alignment meetings to influence strategy.
Proactively identify opportunities to refactor legacy processes and simplify assortments.
Use automation tools to reduce manual rework, optimize low-productivity SKUs, and increase speed-to-insight for leadership teams.
Lead special projects and provide real-time insights to support testing, new initiatives, and ad-hoc leadership requests.