Data Engineer

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

Job summary

OSL Retail Services Inc. in Mississauga, Ontario, is seeking a Data Engineer for a 12-month contract. You will build and maintain BI solutions, move data from APIs, SaaS, and files into Postgres, and develop analytical structures on top of our data warehouse.

The role requires strong SQL, ETL, and data modeling skills, experience with Airflow and Spark, and the ability to collaborate across engineering and analytics teams in a fast-paced environment.

Qualifications

• Experience as data developer, analyst, engineer, or data scientist.
• Background in data warehouse design and dimensional modeling.
• Understanding of DBMS and ETL frameworks.
• Experience with SQL and reporting tools (SSRS/SSIS).
• Experience with SQL/NoSQL data sources, Python or R, XML, REST APIs.
• Familiar with open-source tooling.
• BSc/BA in CS/Engineering or relevant field.
• Familiarity with data visualization tools.
• Proactive, innovative, collaborative mindset.

Responsibilities

• Translate business needs into technical specs with stakeholders.
• Design and automate data flows into Postgres.
• Model data in warehouse with OLAP cubes.
• Maintain and support data workflows and reporting.
• Write and optimize complex SQL.
• Unit-test pipelines and troubleshoot errors.
• Collaborate with engineering, analytics, business teams.
• Strong analytical, organized, and communicative.

Skills

SQL proficiency

Analytical skills

Communication skills

Organizational skills

Problem solving

Education

BSc/BA in CS/Engineering

Tools

Airflow

Spark

SSRS

SSIS

Python

REST API

JavaScript

PostgreSQL

SQL

NoSQL

Linux

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: 12-month contract

Reporting to the Manager, Data Systems, the Data Engineer is 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.

Location: Mississauga (CANADA)

What you’ll do:

• Translate business needs into technical specifications, working directly with stakeholders.
• Design, build, and automate data flows that land data from varied sources (APIs, SaaS platforms, flat files, operational databases) into Postgres, handling incremental loads, deduplication, and schema drift.
• Move and model data into our warehouse and build the analytical structures on top of it (OLAP cubes, semantic models) that let stakeholders’ self-serve.
• Maintain and support our existing data workflows and reporting.
• Write and optimize complex SQL and run the analyses that answer questions directly.
• Unit-test your pipelines and troubleshoot failures by reading and interpreting error logs.
• Collaborate with engineering, analytics, and business teams on system integrations.
• 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

What you’ve done:

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

The salary for this role is $65K to $90K. Your final compensation will reflect your years of experience and beyond the numbers, we’re proud to offer a holistic package that includes:

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

Interview Steps:

• Step 1: If your profile is a match, we will invite you for a first conversation with the recruiter.
• Step 2: The next step is an in-person interview with the hiring manager.
• Step 3: The final step is an in-person interview with the hiring manager and extended team.

If this sounds like you and you’re excited to be a member of our team,

We thank all interested applicants; however, only qualified candidates will be contacted. This position requires successful completion of a criminal background check.

Disclaimer: As part of our recruitment process, we utilize artificial intelligence (AI)-based tools to assist with certain stages, including initial resume screening and skills-matching assessments. These tools are designed to help our hiring team identify candidates whose experience and qualifications align closely with the requirements of the role. Please note that all final hiring decisions are made by our recruitment team. The preceding job description has been designed to indicate the general nature and level of work performed by employees within this job. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities and qualifications required of employees assigned to this job. In compliance with Ontario’s Bill 190, we confirm that this posting represents a current existing vacancy within our organization.