IT Specialist, Enterprise Applications - Data Engineering …, Halton Regional Municipality …

Overview

The Data Engineer, Enterprise Analytics is responsible for designing, building, and supporting scalable, secure, and high-performance analytics solutions on the Microsoft Fabric platform. This role combines strong technical depth with business acumen to translate evolving business needs into trusted data products. The individual will play a key role in shaping and executing Saputo’s modern BI and analytics strategy, leveraging Microsoft Fabric capabilities.Key Contributions

Partner closely with stakeholders to translate business requirements into Fabric-based data models, pipelines, and analytical solutions Contribute to the end-to-end design and evolution of a scalable enterprise analytics architecture using Microsoft Fabric Collaborate with Business SMEs and technical teams (Infrastructure, SAP, Non-SAP systems) to design and deliver sustainable, governed analytics solutionsPreparation and facilitation of design workshops with documented outcomes (requirements, design, data models) Contributes to work effort estimation for new and enhanced analytics solutions Ensure solutions are scalable, secure, cost-effective, and aligned with BI strategy Design and develop high-performance data engineering components capable of processing large volumes of structured and semi-structured dataBuild reusable, enterprise-grade data models (Lakehouse and semantic models) aligned with architectural standards and best practices Contribute to administration, governance, and operational health of the Microsoft Fabric platform Define and execute test strategies, including data validation, performance tuning, and data profilingMonitor Fabric pipelines, data refreshes, and workloads, proactively troubleshoot and resolve issues Own incident resolution and day-to-day sustainment of Fabric analytics solutions Utilize Microsoft Analytics tools for seamless integration and efficient user interface development to enhance overall user experienceOptimize SQL, Spark, and DAX queries for performance and scalability Coach and mentor analytics, functional and business teams on Microsoft Fabric capabilities, patterns, and best practices Operate independently while ensuring alignment with enterprise BI and analytics strategy Capable of leading technical delivery, including design, build, test, and deployment phasesOversee project and support activities such as troubleshooting, enhancements, capacity planning, upgrades, and migrations Effectively manage multiple initiatives in parallel within a complex, fast-paced environment Communicate clearly and collaborate effectively with cross-functional and geographically distributed teamsQualifications

Bachelor’s degree in Information Systems, Computer Science, Software Engineering, or equivalent experience 6+ years of hands‑on experience delivering enterprise analytics and data engineering solutions on Microsoft platforms Strong experience engineering solutions on Microsoft Fabric and modern Azureanalytics services, with understanding and working knowledge of other industry-standard analytics and data engineering toolsMicrosoft Azure / Fabric certifications (nice to have) Bilingual English/French (nice to have) Strong foundation in data ingestion and integration, data transformation and orchestration, data storage, data lakes, lakehouse architectures, data warehousing and dimensional modeling Experience with CI/CD, DevOps, and source control (Azure DevOps, GitHub)Understanding of administration, security, and governance for Microsoft analytics platforms Experience with enterprise delivery methodologies (Agile/Waterfall) and estimation practices Robust understanding of optimization techniques to improve ingestion process Experience in developing reusable template for ingestion processExperience in building real‑time solutions end‑to‑end Experience in ingesting data from SaaS, on‑prem, PaaS, SharePoint and different file formats Understanding of advanced AI technologies like ML, Agentic AI – nice to have Strong written and verbal communication skills, especially for technical design documentationAbility to operate effectively across complex, interdependent workstreams, teams, and geographies Up‑to‑date knowledge of industry trends and best practices in data engineering and analytics Technical Requirements

Strong hands‑on experience as a Data Engineer on Microsoft Fabric and Azure platforms, including Fabric Lakehouse/Warehouse/Event House/Materialized Lake view Fabric Ingestion (Data Factory, Pipelines, Dataflow Gen1, Dataflow Gen2, Copy Job, Notebooks, EventStream, Spark Job Definition, Spark streaming)Fabric Orchestration (Apache Airflow) Fabric Data Engineering Languages (Py‑Spark, Spark SQL, KQL) Experience with Azure analytics services: Azure Data Factory, Azure Synapse Analytics, Azure Data Lake Storage, Azure Databricks (where applicable) Development using Python and Spark notebooks Understanding of data modeling skills, including dimensional modeling (Kimball/star schema) types such as import, direct lakeAdvanced SQL skills for analytical workloads Good understanding of Power BI Workspace, security, and capacity management Solid understanding of DevOps/GitHub for version control and CI/CD Practical understanding of Microsoft Fabric governance, security (One Lake Security, SQL security), and workload managementBenefits

Generous and complete benefit coverage with group insurance Group retirement plan with employer contribution Telemedicine and assistance program for employees and their families Employee Share Ownership Plan with an employer match Paid Parental Leave program Paid time off: Sick days, floater days and volunteer day offOpportunity to contribute to a collective RRSP&TFSA Training and development programs Saputo Flex Program, flexible work environment (schedule/location/time off) according to department needs Organized activities for employees and their families Advantageous discounts on Saputo products Salary

Salary offers will vary commensurate with experience, education, skills, and training. AI Statement

All applications are carefully considered by our Talent Acquisition team. Artificial Intelligence tools may be used in screening applications. Artificial Intelligence is not used to assess or select applications. Equal Opportunity Employer

Saputo is an equal opportunity employer. This statement includes information regarding job skill requirements, qualifications, and preferences. The company values diversity and inclusion. Welcome to candidates from all backgrounds. Accommodations up to the point of undue hardships are available on request.

#J-18808-Ljbffr