IT Specialist, Enterprise Analytics Full-time Job

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 collaborate 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 modelling, Dimensional modelling - Kimball methodology (star schema)

• Strong SQL kills

• 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 families

• Saputo products at a discounted price

 

Salary Range: $97,155 - $127, 520

Making Good Food Is Our Passion, and we do it responsibly. Our caring teams process about 11 billion litres of milk annually into a diversified range of dairy and dairy alternative products sold in over 60 countries. With 65 manufacturing facilities and over 19,500 employees, we operate our leading business in Canada, the USA, Australia, Argentina, and the United Kingdom.
All dairy processors have access to the same raw material and equipment; what distinguishes us is our can-do spirit and our diverse, inclusive work culture that empowers employees to grow in their own way.