Welcome Home! We’re more than Canada’s largest independent hardware and building supplies retailer—we’re part of communities across the nation. Build Trusted Data. Empower Every Decision. As the Analytics Data Specialist, you will champion and deliver enterprise data products that turn raw data into trusted insights, enabling scalable analytics through an Analytics Centre of Excellence. As part of the team that powers enterprise reporting and decision-making, you'll empower every area of the business with trusted data and insights that drive measurable business outcomes. Led by the Manager, Data and Analytics, this opportunity suits a collaborative and detail-oriented professional who enjoys building scalable data solutions, enabling enterprise analytics, and solving complex data challenges.

Ready to make an impact in a new role? Here’s how: Design, build, and maintain scalable data products within Microsoft Fabric and Azure ecosystems that deliver trusted, business-ready data for reporting, analytics and decision making. Develop and maintain Lakehouse and Warehouse data architectures, ensuring structured high performing data layers that support enterprise analytics. Design and optimize business aligned semantic models that enable consistent reporting and analytics. Develop automated data pipelines and integrated workflows using Fabric Data Factory, notebooks and Azure services to transform and deliver data. Implement scalable data transformations that standardize how data is curated and modeled for analytics consumption. Ensure data quality, integrity and reliability through validation, monitoring and cleansing processes across all datasets. Collaborate with analytics teams to deliver high quality data solutions and enable adoption of enterprise data products. Support enterprise data governance and master data management practices by applying data standards and lineage tracking. We’re looking for: Bachelor’s degree in Data Science, Data Analytics, Data Engineering, or a related field; additional analytics certifications are an asset. A minimum of five years of experience in data analytics, data engineering, or a related analytics role. Strong experience with cloud data platforms, particularly Microsoft Fabric, Azure Synapse, and Azure SQL. Strong experience with data engineering and analytics languages (PySpark, SQL, Python, R). Experience with database technologies (SQL Server, Azure SQL), PowerShell scripting, and ETL/ELT processes (SSIS). Experience with cloud data platforms, particularly Microsoft Fabric, Azure Synapse, and Azure SQL. Experience with automation and CI/CD pipelines (Azure DevOps, GitHub) to support repeatable deployments. Strong understanding of modern data architecture, including medallion architecture (Bronze/Silver/Gold), dimensional and semantic data models, and data governance practices. Experience delivering end-to-end analytics solutions, including data ingestion, transformation, semantic modeling, and reporting (Power BI). Strong analytical and problem-solving skills, with the ability to diagnose issues across distributed data platforms. Excellent cross-functional communication skills, with the ability to build relationships and confidently interact with senior leaders. Proven ability to manage multiple priorities and meet deadlines in a fast-paced environment. Highly adaptable, with a passion for learning and evolving alongside emerging technologies such as Microsoft Fabric and AI. Experience with data mining, predictive analytics, machine learning, and Agile methodologies (Scrum, Kanban) is an asset. 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 Home Our 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: The expected starting salary range for this role is $85,800 - $128,600; the final offer will reflect relevant skills and experience. Eligible for the annual 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. Discount from our Corporate Retail Store in St. Jacobs. Home & Auto Insurance discounts. Competitive vacation time. Personal and sick time. Employee Discount Program through Venngo WorkPerks. This job posting is for an existing vacancy within our organization. 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