Tags: jd OpenRoadAutomotiveGroup DataEngineer
Data Engineer OpenRoad? Auto Group · Richmond, BC 1 week ago · 50 applicants
- On-site Full-time
- 1,001-5,000 employees
About the job Position: Data Engineer Status: Full-Time
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 a highly scalable pipeline (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 to GCP Bigquery, GCS, SQL server, Cloud based database systems.
- Design, develop, and maintain robust and scalable data pipelines using Python, PySpark?, and ETL (Extract, Transform, Load) techniques to ingest and transform data from various sources.
- Build and develop large data warehouses, high-performance data processing pipelines, and ETL tools.
- Maintain current ETL processes and data pipelines ensuring data security and performance.
- Ensure high data integrity and quality from various data sources that are aligned to industry best practices.
- 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 the 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.
- 5 years or more of work experience related to data engineering, data warehouse management, database developer and architecture.
- Experience with multiple programming languages including Python.
- Knowledge CI/CD, Git, Release Management
- Solid experience with relational SQL(PostgreSQL?) and NoSQL?.
- Solid experience and knowledge on Google Cloud Platform (knowledge also on AWS is a plus) for data management: Cloud Composer (Apache Airflow), 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 Automotive Industry and knowledge about DMS and CRM would be an added asset.