Data and DevOps Engineer

OSL Retail Services Inc•Mississauga, ON

8d•CA$65,000 - CA$90,000•Onsite

About The Position

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.

Requirements

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

Nice To Haves

Linux OS background would be an added advantage.

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