Data Engineer

OSL Retail Services Inc.; Mississauga; On-site; CAD 70,000 - 85,000; Full time

Job summary

An innovative company is searching for a Data Engineer to join their dynamic team. In this role, you will develop and maintain business intelligence solutions, translating complex business needs into technical specifications. You will design and automate data flows, conduct analyses, and create insightful visualizations to support decision-making. This position offers a competitive salary, RRSP matching, and a supportive workplace culture. If you thrive in a fast-paced environment and are passionate about data, this opportunity is perfect for you to grow your career and make a meaningful impact.

Benefits

Competitive base salary

RRSP matching program

Vacation plus additional flex days

Comprehensive health, dental and life benefits

Training and development opportunities

Supportive workplace culture

Employee development programs

Qualifications

• Experience with data warehouse design and ETL frameworks.
• Strong background in database management and complex SQL queries.

Responsibilities

• Develop and maintain business intelligence solutions.
• Translate business needs into technical specifications and automate data flows.
• Create visualizations and reports for data analysis.

Skills

Analytical Skills

Problem-Solving

Communication Skills

Data Analysis

Collaboration

Attention to Detail

Education

BSc/BA in Computer Science

Relevant Field Experience

Tools

Postgres Database

Apache Airflow

Spark

SQL Server Reporting Services (SSRS)

SQL Server Integration Services (SSIS)

Data Visualization Tools

Linux OS

Job description

Overview

It’s an exciting time to be at OSL Retail Services, working for a people focused company that’s at the top of its game. The momentum we’ve generated in recent years with our commitments to client customers, innovation, business results, and an entrepreneurial spirit has created energy, enthusiasm, and engagement among our employees that is pushing us to new heights. And we’re on the lookout for talented people who share our vision and values and want to join us in this journey. At OSL, our culture is our foundation. Passionate employees, great customer service and long-term relationships are all built upon that foundation. We value people, passion, honesty, respect, and integrity.

The Company:

OSL was established in 2012 in Mississauga, Ontario, to provide clients with customized designed sales solutions in retail, direct sales, merchandising and customer acquisition.

About the role:

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

What you’ll do:

• 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

What you’ve done:

• Experience working with Postgres Database
• 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

What’s in it for you:

• Competitive base salary $70-85K + bonus
• RRSP matching program
• Vacation plus additional flex days
• Comprehensive health, dental and life benefits
• Training and development opportunities to grow your career
• Named one of Canada’s Best Managed Companies
• A supportive workplace culture and work environment
• Employee development programs

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

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

Disclaimer: 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.

OSL is committed to an inclusive workplace that does not discriminate against race, nationality, religion, age, marital status, physical or mental disability, sexual orientation, gender, or gender identity. We believe in diversity and encourage any qualified individual to apply.