Data and DevOps Engineer

OSL Retail Services Inc.; Mississauga; On-site; CAD 65,000 - 90,000; Full time

Benefits offered by this job

Award-winning culture

Invested in you

Job summary

OSL Retail Services Inc. is seeking a Data and DevOps Engineer for a 12-month contract in Mississauga. You will develop BI solutions, design data flows, and build automations to deliver actionable insights.

The role requires expertise in ETL, SQL, Python, Airflow, Spark, and Linux, with a strong focus on data quality and collaboration. Ideal candidates have a data warehouse background, experience with SSRS/SSIS, and proficiency with SQL/NoSQL sources, REST APIs, and visualization tools.

Qualifications

• Experience as Data Developer/analyst/engineer or Data Scientist.
• Background in data warehouse design, dimensional modeling, and data mining.
• In-depth understanding of database management systems and ETL frameworks.
• Experience with Apache Airflow and Spark.
• Experience with Linux Operating systems skills.
• Experience with RDBMS i.e., creating complex SQL queries, SSRS and SSIS.
• Knowledge of and experience with different data sources (SQL and NoSQL), programming (Python or R), XML, REST API and JavaScript.
• Experience and comfort working with open-source tooling.
• Linux OS background would be an added advantage.
• Analytical mind with a problem-solving aptitude.
• BSc/BA in Computer Science, Engineering, or relevant field and or relevant knowledge with experience.
• Familiarity with data visualization tools.
• Proven abilities to take initiative and be innovative and collaborative.
• Positive and supportive tone, attitude, and work ethic

Responsibilities

• Translate business needs to technical specifications.
• Design, build and automate data flows.
• Maintain and support data workflows.
• Create tools to store data, e.g., OLAP cubes.
• Conduct unit testing and troubleshoot via error logs.
• Evaluate and improve existing data systems.
• Collaborate with teams to integrate systems.
• Develop and execute database queries and analyses.
• Create visualizations and reports for projects.
• Develop and update technical documentation.
• Strong analytical skills with attention to detail and accuracy.
• Excellent organizational skills.
• Strong written and verbal communication skills.

Skills

Data analysis

SQL

Python

ETL

Data visualization

Communication

Problem solving

Education

BSc/BA in Computer Science or Engineering

Tools

Apache Airflow

Spark

Linux

SSRS

SSIS

REST API

Job description

Overview

At OSL Retail Services, we believe people are the heart of everything we do, and it is an exciting time to be part of something special! Our momentum is growing, and is fueled by innovation, collaboration, and a shared entrepreneurial spirit that drives real results. Founded in 2012 in Mississauga, Ontario, OSL delivers customized sales solutions in retail, direct sales, and customer acquisition, all built on a foundation of integrity, respect, and passion. Our culture thrives on connection, purpose, and growth. If you're looking for a place where your talents are valued, your ideas matter, and your career can grow, we'd love to meet you.

About the opportunity: Contract 12-months

Reporting to the Manager, Data Systems, the Data and DevOps Engineer are responsible for developing and maintaining business intelligence solutions, crafting, and executing queries up request for data and presenting information through reports and visualization. OSL Retail Services is a collaborative, fast paced and innovative company, to be successful in this role you must thrive in a fast-moving, ever-changing environment.

Role Responsibilities:

• Translate business needs to technical specifications.
• Design, build and automate data flows.
• Maintain and support data workflows.
• Create tools to store data, example OLAP cubes.
• Conduct unit testing and troubleshooting via interpretation of error logs.
• Evaluate and improve existing Data systems.
• Collaborate with teams to integrate systems.
• Develop and execute database queries and conduct analyses.
• Create visualizations and reports for requested projects.
• Develop and update technical documentation.
• Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
• Excellent organizational skills
• Strong written and verbal communication skills

To be successful and join our team:

• Proven experience as a Data Developer, analyst, engineer, or Data Scientist
• Background in data warehouse design, dimensional modeling, and data mining
• In-depth understanding of database management systems and ETL (Extract, Transform, Load) frameworks.
• Experience with Apache Airflow and Spark
• Experience with Linux Operating systems skills
• Experience with RDBMS i.e., creating complex SQL queries, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS)
• Knowledge of and experience with different data sources (SQL and NoSQL), programming (Python or R), XML, REST API and JavaScript,
• Experience and comfort working with open-source tooling.
• Linux OS background would be an added advantage.
• Analytical mind with a problem-solving aptitude
• BSc/BA in Computer Science, Engineering, or relevant field and or relevant knowledge with experience
• Familiarity with data visualization tools
• Proven abilities to take initiative and be innovative and collaborative.
• Positive and supportive tone, attitude, and work ethic

Let's Talk Perks

The salary range for this role is $65k to $90k, your final compensation will reflect your years of experience.

• Award-winning culture: Proud to be one of Canada's Best Managed Companies for 8 years running - now a Platinum Club member.
• Invested in you: Structured employee development programs designed to help you thrive.

We're committed to supporting your success every step of the way.

This position requires successful completion of a criminal background check.