Keyloop bridges the gap between dealers, manufacturers, technology suppliers and car buyers.
We empower car dealers and manufacturers to fully embrace digital transformation. How? By creating innovative technology that makes selling cars better for our customers, and buying and owning cars better for theirs. We use cutting-edge technology to link our clients’ systems, departments and sites. We provide an open technology platform that’s shaping the industry for the future. We use data to help clients become more efficient, increase profitability and give more customers an amazing experience. Want to be part of it?
Job Summary: As a Data Engineer at Keyloop you will work within the Analytics Engineering team and be responsible for maintaining and developing our Data Lake and existing Data Pipelines, as well as continually exploring, analysing and proposing improvements to existing processes and tooling. You will also be required to contribute to scoping and discovery exercises being conducted elsewhere in the business, leveraging your expert knowledge of the data and business intelligence offering and the associated data requirements. You will therefore be working in a busy and multi-functional team, planning and prioritising a variable workload and delivering to deadlines. You will report to the Lead Analytics Engineer, and you may provide mentorship to other analysts and data engineers in Analytics Engineering where appropriate to support their knowledge and skills growth.
Key Responsibilities:
- Design, build and maintain scalable and robust ETL/ELT pipelines using various data integration tools and programming languages (e.g. Python, SQL)
- Collaborate with Analytics Engineers to design and implement optimised data models within our data warehouse, ensuring data quality, consistency and ease of use for analytics
- Manage and optimise our data warehouse including cost optimisation and ensuring data governance best practices
- Implement robust data validation, monitoring and alerting mechanisms to ensure accuracy and completeness of our data
- Work closely with Analytics Engineers to understand their data requirements, provide technical guidance and ensure the efficient delivery of data products
- Pre and post release communications where necessary to relevant stakeholders
- Documenting processes (or SOPs) for commonly performed tasks to assist with the training of other Data Engineers, or to aid business continuity as a general theme
- Fully understanding the data landscape in databases, analytics and applications and all the front-end and back-end products in the global portfolio
- Understanding of data compliance and laws, as well as the full data collection to output technology stack
Technical Competencies:
- Experience with Amazon Web Services cloud platform and with knowledge in particular of data related services they offer
- SQL for data manipulation, transformation and query optimisation
- Experience in Python for data engineering tasks
- Hands-on experience with a modern data warehouse platform (e.g. Amazon Redshift)
- Solid understanding of data warehousing concepts, dimensional modelling (star schema approach), and ETL/ELT principles
- Experience with data pipeline orchestration tools
- Familiarity with version control systems (e.g. Git)
- Understanding of data governance principles and tools
Behavioural & Personality Competencies:
- Analytical and logical mindset
- Time management skills
- High standard of problem-solving skills and attention to detail
- Good communication and listening skills
- Team player and collaborative
- Ability to manage multiple different projects
- Organised & self-sufficient
- Logical, methodical approach to problem and issue solving
- Numerate, innovative and critical thinking
Desirable Skills:
- Familiarity with JIRA software
- Experience, or an interest in, the automotive industry
- Experience of Agile/SCRUM delivery environment
