Senior IT Programmer (SQL/bi) - Temp

Position Summary
Reporting to the Director of Data Performance, the Senior IT Programmer (SQL/BI) plays a crucial role in steering the BI and reporting systems while advancing Sofina's data environment to ensure its relevance and modernization. This role involves shaping Sofina's data landscape and enhancing insights to support strategic decision-making. Effective cross functional collaboration, proficient project management, and finding the right balance between maintaining current systems and driving innovation are key elements for success in this position.

Duration: One year

Key Responsibilities:

• Collaborate with leadership to execute a comprehensive business intelligence strategy that addresses both the current SQL Server environment and the creation of a progressive data landscape.
• Drive the implementation of a unified data model that encompasses multiple ERP systems to elevate data quality and data literacy across Sofina.
• Manage the implementation of efficient ETL processes from various data sources including ERP / OT systems and third party data
• Design, develop, and maintain SSAS multidimensional and tabular models to support efficient and accurate data analysis and reporting.
• Develop visually engaging reports and dashboards utilizing SSRS and Power BI, delivering essential insights to finance, sales, supply chain and other reporting stakeholders.
• Monitor and enhance the performance of BI solutions, ensuring streamlined operations for both the current and forward-looking environments.
• Take the lead on end-to-end BI projects, managing resources, timelines, and stakeholder expectations to deliver successful outcomes.
• Collaborate with cross-functional teams to understand business requirements and translate them into efficient and scalable database and integration solutions.
• Guide, mentor, and empower a proficient team of BI developers and analysts, cultivating a culture of teamwork, creativity and ongoing development.
• Develop, implement and enforce standardized practices and guidelines for data modeling, ETL processes, and reporting ensuring alignment with industry best practices.

Requirements:

• Bachelor's degree in Computer Science, Information Technology, or related work experience.
• Minimum 2 years experience using Microsoft SQL Server, with hands-on experience in writing complex queries, stored procedures, and performance optimization.
• Proficient in the Microsoft BI Stack (SSIS, SSAS, SSRS, Power BI)
• In-depth knowledge of database development concepts and best practices, including relational database modeling and performance tuning.
• Experience in database administration, encompassing database design, optimization, maintenance and performance tuning.
• Experience working with code repositories such as Azure DevOps, Git, GitHub, etc.
• Experience developing and implementing standardized practices and guidelines for BI development.
• Experience working with Azure or other cloud technologies is an asset.
• Experience working with SQL Master Data Service (MDS) is an asset.

Sofina Foods Inc. is committed to providing accessible employment practices that are in compliance with the Accessibility for Ontarians with Disabilities Act ('AODA'). Applicants are asked to make their needs/requirements, for the purpose of accommodation under AODA, known to Human Resources when they are contacted for an interview.