Analytics Data Specialist

Role overview

Data products and architecture

• Design, build, and maintain business-ready data products in Microsoft Fabric and Azure.
• Develop and maintain Lakehouse and Warehouse architectures and structured data layers for enterprise analytics.
• Design and optimize business-aligned semantic models for consistent reporting and analytics.

Pipelines, quality, and governance

• Develop automated pipelines and integrated workflows using Fabric Data Factory, notebooks, and Azure services.
• Standardize data transformations and curation for analytics consumption.
• Maintain data quality, integrity, and reliability through validation, monitoring, and cleansing.
• Support governance and master data management practices by applying standards and tracking lineage.

Qualifications and experience

• Bachelor's degree in Data Science, Data Analytics, Data Engineering, or a related field; additional analytics certifications are an asset.
• At least five years of experience in data analytics, data engineering, or a related analytics role.
• Strong experience with Microsoft Fabric, Azure Synapse, Azure SQL, PySpark, SQL, Python, and R.
• Experience with SQL Server, PowerShell, SSIS, ETL/ELT, Azure DevOps, and GitHub.
• Understanding of medallion, dimensional, and semantic data models and data governance.
• Experience delivering end-to-end analytics from ingestion and transformation through semantic modeling and Power BI reporting.

Additional qualifications

• Strong analytical, problem-solving, communication, and cross-functional collaboration skills; ability to diagnose distributed-platform issues.
• Ability to manage priorities and deadlines, adapt, and interact confidently with senior leaders.
• Data mining, predictive analytics, machine learning, and Scrum or Kanban experience are assets.
• Able to work onsite three days a week at the St. Jacobs corporate office as part of the hybrid model.

Work arrangement

• Hybrid working model with three onsite days per week at the corporate office in St. Jacobs.

Compensation and benefits

• Expected starting salary range is $85,800–$128,600; final offer reflects relevant skills and experience.
• Eligible for an annual bonus program, comprehensive benefits, pension and group RRSP, retail and insurance discounts, vacation, personal and sick time, and WorkPerks.