IT Specialist, Enterprise Analytics

At Saputo, we bring good to the table by making high-quality products, investing in our people, and supporting communities around the world. As a top 10 global dairy processor, we value contributions that matter and strive to foster an inclusive, growth-driven work environment. Ready to bring your best?

**Overview of The Role**

The IT Specialist, Enterprise Analytics is a data engineer who provides reporting and analytic solutions to meet evolving business needs and drives through both strong technical and functional skills and experience with Microsoft Analytics tools and platforms. This individual will help define and update our evolving BI strategy and deployment of the latest Analytics software platforms at Saputo.

**How You Will Make Contributions That Matter**:

- Strong business acumen to work with business users and interpret business requirements into data models and analytic solutions with a focus on Microsoft Azure technologies (Fabric & Power BI)
- Assist with the end to end design of a scalable BI architecture that supports efficient creation of BI solutions
- Direct interaction with business SMEs and technical groups (Infra, SAP, Non-SAP) to design and implement sustainable analytic solutions
- Preparation and facilitation of design workshops with documented outcomes (requirements, design, data models).
- Contributes to work effort estimates when building new or enhanced BI solutions on the Azure platform
- Ensure designs are scalable, on strategy, and deliver the expected business outcome
- Development of complex solution components with exceptional performance capable of processing large volumes of data
- Design and develop scalable, reusable data models using Azure development in line with architectural standards and best practices
- Ownership, Administration & Governance of the MS Fabric platform
- Define test plans and conduct performance tuning and data profiling
- Ownership of incident resolution and day to day sustainment of MS Fabric BI solutions
- Utilize Microsoft Analytics tools for seamless integration and efficient user interface development to enhance overall user experience
- Troubleshoot and optimize SQL queries to ensure top performance of analytic processes
- Coach and mentor Business Analytics and Functional teams on MS Fabric technologies and processes

**Supervision**
- Works independently ensuring alignment to our BI Strategy
- Capable of directing a team
- Oversee project activities (design, develop, test deploy)
- Support activities (troubleshoot, enhance, capacity plan, upgrade, migration).
- Ability to multi-task and manage multiple projects/initiatives simultaneously
- Ability to successfully communicate and collaborate with colleagues and functional SME’s.

As part of his duties, the incumbent will have to communicate and collaborat e in English, both orally and in writing with colleagues or other stakeholders in Quebec as well as in the rest of Canada or in North America.

**You Are Best Suited for The Role If You Have the Following Qualifications**:

- Bachelor’s Degree in Information Systems or Software Engineering
- 8+ years of hands on project and support experience in Microsoft Analytics with Azure developments;
- Microsoft Azure certifications - nice to have;
- Bilingual - English and French (nice to have);
- Proficient in Data ingestion and integration, Data transformation, Data storage and management, Data Warehousing, Data Modeling and Analysis
- Solid understanding of system administration for Microsoft Analytics platforms
- Experience in data lake/data warehousing concept and methodologies
- Power BI administration - Workspace management, Security management
- Tabular model - Power BI Dataset development
- Experience with enterprise estimating tools and delivery methodologies;
- Strong written and verbal technical design skills;
- Ability to operate in complex, fast pace project environment with interdependencies spanning multiple work-streams, teams, business divisions, geographies, time zones, & language.
- Up-to-date knowledge of industry trends and best practices in data analytics

**Technical Requirements**
- Proficient Data Engineer with experience in Azure Data factory, Azure Synapse Analytics, Azure Data Lake Storage, Azure Data bricks
- Azure development with ADF pipelines
- Azure development with notebooks (Python/Spark)
- Data modeling, Dimensional modeling - Kimball methodology (star schema)
- Strong SQL skills
- Basic Power BI skills (including DAX)
- Understanding of MS Fabric tools

**We support and care for our employees and their families by providing**:

- Competitive salaries
- A hybrid work environment with the possibility to work from home 2 days a week
- Advantageous corporate agreements
- Full range of group insurance benefits
- Group retirement pension plan with employer contribution
- Purchase option of company stocks
- Group RRSP
- Health and wellness program in the workplace
- Assistance program for employees and their