OSL Retail Services logo for Data Engineer job on DevsUnite

Data Engineer

OSL Retail Services

Actively HiringFull-time
Apply
Location

Mississauga, Ontario, Canada

Experience

3+ years

Role

Data Engineer

Salary

Competitive

Share this job

Know someone who'd be a great fit?

Job Description

Role Overview

Data Engineer role reporting to the Manager, Data Systems, focused on developing business intelligence solutions, executing data queries, and delivering reports and visualizations in a collaborative, fast-paced environment.

Responsibilities

  • Translate business needs into technical specifications working directly with stakeholders.
  • Design, build, and automate data flows from varied sources (APIs, SaaS, flat files, operational databases) into Postgres, handling incremental loads, deduplication, and schema drift.
  • Move and model data into the warehouse, building analytical structures (OLAP cubes, semantic models) enabling stakeholder self-serve.
  • Maintain and support existing data workflows and reporting.
  • Write and optimize complex SQL queries to answer business questions directly.
  • Unit-test pipelines and troubleshoot failures by interpreting error logs.
  • Collaborate with engineering, analytics, and business teams on system integrations.
  • Apply strong analytical skills to collect, organize, analyze, and disseminate significant information with attention to detail and accuracy.
  • Demonstrate excellent organizational skills.
  • Maintain strong written and verbal communication skills.

Requirements

  • 3+ years 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 frameworks.
  • Experience with Apache Airflow and Spark.
  • Experience creating complex SQL queries and with SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS).
  • Knowledge of various 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 considered an advantage.
  • Analytical mind with proven problem-solving aptitude.
  • BSc/BA in Computer Science, Engineering, or relevant field with experience.
  • Familiarity with data visualization tools.
  • Proven abilities to take initiative, be innovative, and collaborate.
  • Positive and supportive work ethic and attitude.

Required Skills

PythonSQLApache AirflowPostgreSQLData Warehouse

Ready to apply for Data Engineer?

See how you stack up at OSL Retail Services before you apply, or go straight to the application.

Apply Anyway