Analytics Data Specialist

Job summary

Design, build, and maintain scalable data products, Lakehouse and Warehouse architectures, semantic models, and automated pipelines across Microsoft Fabric and Azure. Ensure data quality and governance, and collaborate with analytics teams to deliver trusted enterprise data products that support reporting and business decisions.

Job details

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. 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.

What you’ll do

Design, build, and maintain scalable data products, Lakehouse and Warehouse architectures, semantic models, and automated pipelines across Microsoft Fabric and Azure. Ensure data quality and governance, and collaborate with analytics teams to deliver trusted enterprise data products that support reporting and business decisions.

Requirements

Requires a bachelor’s degree in a related field and at least five years of experience in data analytics, data engineering, or a related role. Candidates should have strong cloud data platform, programming, ETL/ELT, data architecture, governance, and end-to-end analytics experience, along with communication and prioritization skills.

Benefits

• Annual Bonus Program
• Health Insurance
• Dental Insurance
• Vision Insurance
• Paramedical Coverage
• Disability Coverage
• Out-of-Country Travel Insurance
• Life Insurance
• Employee Family Assistance Program
• Defined Contribution Pension Plan With Company Match
• Group RRSP
• Corporate Retail Store Discount
• Home and Auto Insurance Discounts
• Vacation Time
• Personal and Sick Time
• Employee Discount Program

Listed skills

• Microsoft Azure · Preferred
• Power BI · Preferred
• SQL · Preferred
• CI/CD · Preferred
• Machine learning · Preferred
• Python · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• Microsoft Fabric
• Azure
• Data Engineering
• Data Analytics
• PySpark
• SQL
• Python
• R
• Azure Synapse
• Azure SQL
• Power BI
• ETL/ELT
• Data Modeling
• Data Governance
• CI/CD
• Machine Learning

Job areas

• Data & Analytics
• Technology
• Software
• Retail

More jobs from Home Hardware Stores Limited