Data Engineer

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: in office 5 days

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:

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

What you've done:

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

What's in it for you:

1. Competitive base salary $70-80K + bonus
2. RRSP matching program
3. Vacation plus additional flex days
4. Comprehensive health, dental, and life benefits
5. Training and development opportunities to grow your career
6. Named one of Canada's Best Managed Companies
7. A supportive workplace culture and work environment
8. 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