Data Engineer- Head Office

OpenRoad Auto Group; Richmond; On-site; CAD 80,000 - 110,000; Full time

Job summary

OpenRoad Auto Group is looking for a Full-Time Data Engineer. In this role, you will be responsible for creating and managing data pipelines, ensuring data quality, and collaborating with teams on data needs. With a focus on innovation, you will leverage cloud technologies to enhance our data processing capabilities and support analytics efforts.

Benefits

Discounted Vehicle Purchasing Program

Employee Referral Program

Employer RRSP Matching

Comprehensive Extended Health and Dental plan

Training & Development opportunities

Recognition and Engagement Events

Qualifications

• 3+ years of experience in data engineering and warehouse management.
• Excellent programming skills in Python and familiarity with big data tools.
• Experience in CI/CD practices and relational databases.

Responsibilities

• Design and maintain scalable data pipelines for processing data.
• Collaborate with stakeholders to meet data needs.
• Ensure data integrity and quality across various sources.

Skills

Data Engineering

Python

Apache Spark

ETL

SQL

Google Cloud Platform

Education

Bachelor's degree in Computer Science

Mathematics/Statistics

Tools

Apache NiFi

Apache Beam

Docker

Google Kubernetes Engine

Job description

Location : Head Office Richmond - 100% in office

Department : Information Technology

We believe in doing good for our customers and for ourselves. Whether it’s launching the most anticipated model of the year or purchasing a vehicle for your next adventure, great people and relationships are at every turn with OpenRoad.

We are proud of our forward-thinking culture developed over 40 years of continuous improvement initiatives. OpenRoad is one of the largest and fastest-growing automotive retail groups in the country (representing 20 automotive brands across 25 locations) with a shared vision to become the national automotive leader in customer experience. As one of Canada’s Best Employers and Best Managed Companies, we are looking for team players who are excited to continually learn, work hard, and take ownership of their roles.

If you love the idea of joining an organization with unlimited possibilities to accelerate your career, then apply to OpenRoad and grow with us today!

A Career at OpenRoad Means You’ll Enjoy :

• Opportunity to work with a variety of OEM BRANDS : Acura, Audi, BMW, Genesis, Honda, Hyundai, Infiniti, Jaguar, Land Rover, Lexus, Mazda, Mercedes-Benz, MINI, Porsche, Rolls-Royce, Subaru, Toyota, Volkswagen
• Amazing Incentives include but not limited to Discounted Vehicle Purchasing Program, Computer Rebate Program, Employee Referral Program, Employer RRSP Matching
• Internal and External, Training & Development opportunities for skill development and growth
• Be part of a collaborative, friendly and progressive work culture with an emphasis on transparency, innovation, relationship, and empowerment
• Comprehensive Extended Health and Dental plan; tailored towards Associate wellness
• Recognition and Engagement Events!

OpenRoad Auto Group is currently seeking to expand our team with a Full-Time Data Engineer at OpenRoad Auto Group. The Data Engineer is responsible for implementing & maintaining methods to improve data reliability and quality by combining raw data from different sources to create consistent and machine-readable formats for the usage of Data Analysts, Data Scientists, and relevant stakeholders within cloud-based data ecosystem.

ROLE & RESPONSIBILITIES :

• Design, build and maintain highly scalable data pipelines (end-to-end) for large volumes of complex data processing and analysis within a cloud-based ecosystem.
• Build pipelines to and from external sources like FTP / SFTP servers, API’s and Web to GCP BigQuery, GCS, SQL server, Cloud based database systems.
• Design, develop, and maintain robust and scalable data pipelines using Python, PySpark, ETL (Extract, Transform, Load) and ELT (Extract, Load, Transform) techniques to ingest and transform data from various sources.
• Ensure high data integrity, security, and quality from various data sources that are aligned to industry best practices.
• Proficient in the Apache stack, including Spark, NiFi, and Beam, to design and implement robust data pipelines that drive our analytics.
• Experience with Docker, Google Container Registry and Google Kubernetes Engine for running and orchestrating containerized applications on GCP.
• Build, develop and maintain large data warehouses, high-performance data processing pipelines, and ETL tools.
• Experience in CI / CD practices using Google Cloud Build, Cloud Source Repositories, Cloud Run, and Artifact Registry to automate and streamline our deployment processes.
• Collaborate with multiple stakeholders to fulfill their needs.
• Document data engineering processes, data flows, and best practices for knowledge sharing
• Explore new technologies to improve current data stacks.
• Explore existing and new data sources and facilitate the integration to the Data Warehouse.
• Develop data definition and metrics and maintain consistency across Data team.

KNOWLEDGE, SKILLS, AND ABILITIES REQUIRED :

• Graduates of Computer Science and Information Technology. Mathematics / Statistics or other related fields is a plus.
• 3 years or more of work experience related to data engineering, data warehouse management, database developer and architecture.
• Experience with multiple programming languages including Python.
• Experience with Apache Stack (Spark, NiFi & Beam) for big data processing.
• Knowledge CI / CD, Git, Release Management
• Solid experience with relational SQL (PostgreSQL, MySQL) and NoSQL.
• Solid experience and knowledge on Google Cloud Platform (knowledge also on AWS is a plus) for data management : Cloud Composer (Apache Airflow), Dataflow (Apache Beam), Cloud Build, Kubernetes, Google Cloud Storage, Dataflow, BigQuery, and Dataprep, SSIS or equivalent.
• Experience in designing and standing up APIs and services.
• Quick learner with the ability to pick up new ideas and concepts quickly.
• Previous work experience in the Automotive Industry and knowledge about DMS and CRM would be an added asset.

Internal Candidates MUST apply by filling out the Internal Endorsement Form on the Intranet. Failure to complete the form will cause a delay in your application.

https : / / orag.bamboohr.com / careers / 4114

We are an equal opportunity employer that embraces diversity. We stand behind the growth of our associates to help them achieve their vision and goals.

JOIN US AND GROW WITH US!

We thank all those that have applied. Only those considered for the position will be contacted.