Analytics Data Specialist

Home Hardware Stores Limited; St. Jacobs; Hybrid; CAD 86,000 - 129,000; Full time

Benefits offered by this job

Health, Dental, Vision, Paramedical, &

Disability coverage

Life Insurance

Employee Family Assistance Program

Defined Contribution Pension Plan with

Group RRSP

Discount from Corporate Retail Store (

Competitive vacation time

Personal and sick time

Employee Discount Program

Job summary

Home Hardware Stores Limited in Ontario is seeking an Analytics Data Specialist to build scalable data products and empower enterprise analytics. You will champion data governance, design lakehouse architectures, and deliver trusted insights that drive measurable business outcomes.

The role requires 5+ years in data analytics or engineering, strong cloud experience with Microsoft Fabric, Azure Synapse, and Azure SQL, and fluency in PySpark, SQL, Python and R.

Qualifications

• Bachelor’s degree in Data Science, Data Analytics, Data Engineering, or a related field.
• Five+ years of experience in data analytics or data engineering.
• Strong experience with cloud data platforms (Microsoft Fabric, Azure Synapse, 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 platforms and automation/CI/CD pipelines (Azure DevOps, GitHub).
• Strong understanding of modern data architecture, including medallion architecture and data governance practices.
• Experience delivering end-to-end analytics solutions (Power BI, data ingestion, transformation, semantic modeling).

Responsibilities

• Design, build, and maintain scalable data products within Microsoft Fabric and Azure ecosystems.
• Develop and maintain lakehouse and warehouse data architectures for enterprise analytics.
• Design and optimize semantic models for consistent reporting and analytics.
• Develop automated data pipelines and workflows using Fabric Data Factory and Azure services.
• Implement scalable data transformations to standardize data curation and modeling for analytics.
• Ensure data quality, integrity and reliability across datasets.
• Collaborate with analytics teams to deliver high-quality data solutions and enable adoption of enterprise data products.
• Support data governance and master data management through data standards and lineage tracking.

Skills

Cloud data platforms

Microsoft Fabric

Azure Synapse

Azure SQL

PySpark

SQL

Python

R

PowerShell

ETL/ELT

Education

Bachelor’s degree in Data Science/Analytics/Engineering

Tools

Fabric Data Factory

Notebooks

SSIS

Azure DevOps

GitHub

Job description

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.
• 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.
• 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.
• Competitive vacation time.
• Personal and sick time.
• Employee Discount Program through Venngo WorkPerks.

This job posting is for an existing vacancy within our organization.

We may use Artificial Intelligence (AI) technology to assist in reviewing applications and assessing qualifications. These tools support efficiency and consistency throughout the recruitment process, but they do not replace human judgment. All hiring decisions are made by recruiters and/or hiring managers. For more information about our use of AI and how we handle candidate information, please refer to the New Applicant Privacy Notice.

Bring your unique skills, thrive with interesting and challenging work, and experience what it’s like at Home.

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.