Analytics Data Specialist

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

Benefits offered by this job

Health, Dental, Vision

Pension plan with company match

Group RRSP

Employee discounts at corporate store

Vacation, personal and sick time

Job summary

Home Hardware in Canada’s St. Jacobs area is seeking an Analytics Data Specialist to design, build and maintain enterprise data products within Microsoft Fabric and Azure. You will enable scalable analytics and trusted data for reporting and decision-making across the business.

The role requires a minimum of five years in data analytics or engineering, strong SQL/PySpark/Python/R skills, and experience with Power BI and CI/CD pipelines. This hybrid role is onsite three days a week at the St.

Qualifications

• Bachelor’s degree in data field required.
• 5+ years in data analytics/engineering.
• Experience with Fabric, Synapse, and SQL.
• Strong SQL, PySpark, Python, R skills.

Responsibilities

• Design, build, and maintain scalable data products in Fabric and Azure.
• Develop Lakehouse and Warehouse architectures for analytics.
• Create semantic models for consistent reporting.
• Develop automated data pipelines using Fabric Data Factory and Azure services.
• Ensure data quality, governance, and lineage tracking.

Skills

Analytical thinking

Cross-functional communication

Problem solving

Adaptability

Learning mindset

Education

Bachelor’s degree in data science/analytics/engineering

Analytics certifications

Tools

Microsoft Fabric

Azure Synapse

Azure SQL

Power BI

SSIS

Azure DevOps

GitHub

PySpark

Job description

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.

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.