Data and Reporting Analyst

Welcome Home!We’re more than Canada’s largest independent hardware and building supplies retailer—we’re part of communities across the nation.  Data Driven Excellence Starts Here As a Data and Reporting Analyst, you’ll manage ad-hoc reporting across the business, providing valuable analysis to support decision-making and performance tracking. You will work cross-functionally to support reporting and analysis of store level KPIs (including sales, purchases, inventory, profitability). Led by the Manager, Data and Analytics, this opportunity suits a technically skilled analyst who enjoys problem-solving and thrives on data accuracy and report automation. Ready to make an impact in a new role? Here’s how: 

• Manage ad-hoc reporting requests, extracting data from various systems and selecting appropriate tools to develop accurate, timely reports.
• Create, test, and distribute month-end reports in collaboration with business units, pulling and integrating data from multiple sources.
• Lead the analysis and reporting of store-level KPIs, ensuring data accuracy, identifying trends, and recommending improvements or corrective actions.
• Identify opportunities to automate and enhance reporting processes using corporate tools and best practices.
• Support quality control efforts, including POS data scrubbing and vendor/item data accuracy.
• Provide subject matter expertise on corporate reporting tools and databases, acting as a go-to resource for data structure, usage, and application.
• Develop and manage Access databases as needed to support ad-hoc or stand-alone reporting requirements.
• Contribute to the corporate Data Governance process and participate in strategic initiatives, providing insights that support data-driven decision making.
• Manage and complete assigned projects within scope and timeline expectations, balancing day-to-day reporting with broader business priorities.

We’re looking for: 

• A Bachelor’s degree in Business, Information Technology, or a related field, with three years of experience in a data or reporting analyst role.
• Proven ability to manage and prioritize multiple reporting requests while delivering high-quality outputs on schedule.
• Strong analytical and problem-solving skills, with a focus on data accuracy, integrity, and continuous improvement.
• Proficiency in Microsoft Excel (including pivot tables, complex formulas, and VB coding) and Microsoft Access (query editing, macros, and linked data).
• Experience working with large datasets and multiple systems to consolidate and interpret business performance metrics.
• Excellent communication and collaboration skills to work effectively across teams and with non-technical stakeholders.
• Customer-focused mindset with a commitment to delivering insights that support strategic decision-making.
• The ability to be onsite three days a week at our corporate office in St. Jacobs, to accommodate our hybrid working model.

How we’ll make you feel at HomeOur Team Members enjoy life at Home with our strong culture of support and inclusion, excellent benefits, and a team that always has your back.  You will receive: 

• Competitive earnings opportunity. 
• Annual Incentive/Bonus Program. 
• Comprehensive Benefits Program including: 
  • Health, Dental, Vision, Paramedical, Disability coverage, Out of Country Travel Insurance, Life Insurance, Employee Family Assistance Program. 
• Defined Contribution Pension Plan with Company Match, and choice of contribution level. 
• Group RRSP. 
• Discounts from our corporate retail stores. 
• Home & Auto Insurance discounts. 
• Competitive vacation time.  
• Personal and sick time. 
• Employee Discount Program through Venngo WorkPerks. 

Bring your unique skills, thrive with interesting and challenging work, and experience what it’s like at Home. Apply today - this is a great opportunity to join a proudly Canadian company that is 100% ready to help you build your future.  Home Hardware recognizes the value of a diverse team. We believe that different perspectives, backgrounds, and experiences make us stronger as an organization. Applicants representing the full diversity of communities in Canada are encouraged to apply with confidence. Please let us know if you require accommodation during the recruitment process. 
Canadians call us Home Hardware. We call it Home.

#HP