Back to jobs

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

Markham, 100 Commerce Valley Dr W, Markham, Ontario, Canada; Greater Toronto Area, ON, Canada

Live, first seen by us 11 days ago
Pay
CAD 64,393–90,082/year · BaseAnnual period assumed. Not guaranteed — pay source
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. Please note that the expected hiring range provided is derived from a group of like roles within Sofina. The final offer amount for this role will be dependent on geographical region, applicable experience, skillset of the candidate and internal equity. This position is currently an active vacancy
Read the full posting
Work setting
Not stated
Employment
Not stated

What you’ll work on

Full posting
  • Design, build and maintain ETL processes from ERP, OT and third-party data

  • Develop and maintain SSAS multidimensional and tabular models

  • Build SSRS and Power BI reports and dashboards for finance, sales and supply chain

  • Create a unified data model across multiple ERP systems

  • Monitor and improve performance of BI solutions

From the employer’s posting
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
Develop visually engaging reports and dashboards utilizing SSRS and Power BI, delivering essential insights to finance, sales, supply chain and other reporting stakeholders.
Develop and implement a unified data model that encompasses multiple ERP systems
Monitor and enhance the performance of BI solutions

What you’ll bring

All qualifications

Core experience

  • Bachelor's degree in Computer Science, Information Technology, or related work experience.
  • 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
Qualification wording
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
Education & alternatives
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. Please note that the expected hiring range provided is derived from a group of like roles within Sofina. The final offer amount for this role will be dependent on geographical region, applicable experience, skillset of the candidate and internal equity. This position is currently an active vacancy
Apply at Sofina Foods

Posting record

Report an error
Status in our records
Live
First seen by us
Nov 10, 202611 days ago
Recorded sightings
12
Last seen by us
Nov 21, 2026
Reposted
once since Oct 2, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications. We count a repost when the same title and location comes back as a new listing within 60 days of the last one coming down. Some hiring systems expire listings on a schedule, so repost rates vary by system.

How this job compares

Time since we first saw it

Day 11

Similar jobs usually come down between day 6 and day 56.

From 14,771 similar postings that came down. Coming down is not always a hire.

Sofina Foods is hiring

1 open job

Open jobs by the week we first saw them, last 12 weeks.

  • 100% of open jobs were reposted
Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • Python
  • SQL
  • Azure
  • Power BI
  • SQL Server
  • SSAS
  • SSIS
  • SSRS
Where the posting names them
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. Please note that the expected hiring range provided is derived from a group of like roles within Sofina. The final offer amount for this role will be dependent on geographical region, applicable experience, skillset of the candidate and internal equity. This position is currently an active vacancy
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
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:

Your next step

Complete your application on jobs.dayforcehcm.com. The employer’s form will show what is required.

Applying through Dayforce

  • The application asks you to sign in to the employer’s Dayforce candidate portal, or create an account there.

Already applied? Track this application

Job description

View original posting ↗

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. Please note that the expected hiring range provided is derived from a group of like roles within Sofina. The final offer amount for this role will be dependent on geographical region, applicable experience, skillset of the candidate and internal equity. This position is currently an active vacancy

Demand for Data Engineer roles

New Data Engineer postings at the employers we follow are up 13% over the last 6 weeks compared with the 6 before.

Weekly new Data Engineer postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 845, the most 1,344, and the latest week had 1,007.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Data Engineer, by the work the posting describes.

Data engineers build and run the pipelines that copy data out of apps and outside services into a warehouse or lake, and fix them when a source changes or a load fails.

Expect SQL, Python, a cloud platform, a scheduler such as Airflow, and often tools for large data such as Spark or Kafka.

An analytics engineer works one step later, turning the raw data a data engineer lands into clean tables people can query.

US government figures for database architects

Median yearly pay, May 2025
$139,500
Expected change, 2025 to 2035
9.4% more jobsagainst 3.5% for all jobs

The government has no code for data engineers, so these figures are for the closest group, database architects, which includes data integration and data warehousing specialists.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

This passage needs a closer read in the full description.

Location & working pattern

Markham, 100 Commerce Valley Dr W, Markham, Ontario, Canada; Greater Toronto Area, ON, Canada

Working pattern and location restrictions need checking in the full posting.

Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.