IT Programmer (SQL/Business Intelligence) / Developer (SQL,BI, Data) / Data Engineer

Sofina Foods Canada

Markham

On-site

CAD 64,000 - 90,000

Full time

11 days ago

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Sofina Foods Canada in Markham is seeking an IT Programmer (SQL/BI) to develop BI/reporting systems and modernize the data environment. You will design ETL processes, build SSAS models, and deliver Power BI dashboards for finance, sales, and supply chain.

Join a team focused on balancing legacy systems with innovative data capabilities, applying best practices in data modeling, ETL, and reporting. Requires 3+ years with SQL Server, SSIS/SSAS/SSRS, and Power BI.

Qualifications

  • Bachelor's degree in Computer Science, Information Technology, or related work experience.
  • Minimum 3 years experience using Microsoft SQL Server, with hands-on experience in writing complex queries, stored procedures, and performance optimization.
  • Experience with 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 working with code repositories such as Azure DevOps, Git, GitHub, etc.
  • Experience developing and implementing standardized practices and guidelines for BI development.
  • Experience with Python and ML is considered an asset
  • Experience working with Azure or other cloud technologies is an asset.
  • Experience working with SQL Master Data Service (MDS) is an asset

Responsibilities

  • Design, develop and maintain 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.
  • Execute a comprehensive business intelligence strategy that addresses both the current SQL Server environment and the creation of a progressive data landscape.
  • Develop and implement a unified data model that encompasses multiple ERP systems to elevate data quality and data literacy across Sofina.
  • 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.
  • Collaborate with cross-functional teams to understand business requirements and translate them into efficient and scalable database and integration solutions.
  • Develop, implement and enforce standardized practices and guidelines for data modeling, ETL processes, and reporting ensuring alignment with industry best practices

Skills

SQL queries
Stored procedures
Performance optimization
Data modeling
ETL development
Reporting design

Education

Bachelor's degree in Computer Science or Information Technology

Tools

SSIS
SSAS
SSRS
Power BI
Azure DevOps
Git
Azure
SQL Master Data Service (MDS)

Job description

Position Summary

Reporting to the Director of Data Performance, the IT Programmer (SQL/BI) is instrumental in developing the BI and reporting systems and upgrading Sofina's data environment for relevance and modernization. This role contributes to shaping Sofina’s data landscape and improving insights to aid strategic decision-making. Success in this role relies on effective collaboration across teams, adept project management, and achieving a balance between maintaining existing systems and fostering innovation.

Key Accountabilities
  • Design, develop and maintain 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.
  • Execute a comprehensive business intelligence strategy that addresses both the current SQL Server environment and the creation of a progressive data landscape.
  • Develop and implement a unified data model that encompasses multiple ERP systems to elevate data quality and data literacy across Sofina.
  • 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.
  • Collaborate with cross-functional teams to understand business requirements and translate them into efficient and scalable database and integration solutions.
  • 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 3 years experience using Microsoft SQL Server, with hands‑on experience in writing complex queries, stored procedures, and performance optimization.
  • Experience with 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 working with code repositories such as Azure DevOps, Git, GitHub, etc.
  • Experience developing and implementing standardized practices and guidelines for BI development.
  • Experience with Python and ML is considered an asset
  • Experience working with Azure or other cloud technologies is an asset.
  • Experience working with SQL Master Data Service (MDS) is an asset
Hiring Range

CAD $64,393 - $90,082

Bonus: This position is eligible for a bonus up to 8% of base salary subject to the plan terms and conditions.

This position is currently an active vacancy

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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

IT Programmer (SQL/Business Intelligence) / Developer (SQL,BI, Data) / Data Engineer
IT Programmer (SQL/Business Intelligence) / Developer (SQL,BI, Data) / Data Engineer

Sofina • Markham

On-site
CAD 64,000 - 90,000
Annual bonus
Production Analyst
Production Analyst

Sofina Foods • Brampton

On-site
CAD 51,000 - 64,000
Bonus up to 5%
Learning and Development Specialist
Learning and Development Specialist

Sofina Foods Canada • Markham

On-site
CAD 57,000 - 75,000
Bonus up to 7% of base salary
Accessible employment practices (AODA)
Developer, BI
Developer, BI

Dollarama • Mount Royal

On-site
CAD 110,000 - 140,000
Director, Operations (Manufacturing)
Director, Operations (Manufacturing)

Sofina Foods Inc. • Brampton

On-site
CAD 120,000 - 170,000
Bonus eligibility
Director, Planning and Performance (Operations)
Director, Planning and Performance (Operations)

Sofina Foods Canada • Markham

On-site
CAD 120,000 - 170,000
Bonus program up to 17.5% of base
Director, Planning and Performance (Operations)
Director, Planning and Performance (Operations)

Sofina Foods • Markham

On-site
CAD 120,000 - 170,000
Bonus up to 17.5%
Learning and Development Specialist
Learning and Development Specialist

Sofina Foods • Markham

Hybrid
CAD 57,000 - 75,000
Bonus up to 7%
Senior Manager, Maintenance and Technical Services
Senior Manager, Maintenance and Technical Services

Sofina Foods Canada • Brampton

On-site
CAD 96,000 - 146,000
Bonus up to 16.5% of base salary
Sr. Specialist, Business Intelligence Analyst
Sr. Specialist, Business Intelligence Analyst

L3Harris Technologies, Inc. • Burlington

On-site
CAD 90,000 - 140,000