Hybrid Data Engineer — Pipelines, ETL & Warehousing

Lithia UK; Nottingham; Hybrid; GBP 34,000 - 57,000; Full time

Benefits offered by this job

Pension

Life Assurance

33 days holiday (incl. BH)

Salary sacrifice car scheme

Volunteer day

Long service milestones

Career training & development

Cycle to work

Discounts & perks

Job summary

Lithia UK is recruiting a Data Engineer to design, build and optimise data pipelines and data warehouses. You will transform raw data into reliable, high-quality information to enable reporting and analytics.

The role combines hands-on data engineering with collaboration across teams in a hybrid setup at our Nottingham area hub. You will leverage SQL and NoSQL databases, Python/Java/Scala, and Azure Data Factory/Databricks to deliver scalable data solutions, while ensuring data quality and

Qualifications

• Proven experience as a Data Engineer or similar role.
• Full UK Driving Licence.
• Strong SQL skills with relational and NoSQL databases.
• Experience with data pipeline and ETL tools (e.g. Azure Data Factory, Azure Logic Apps, Databricks, APIs).
• Understanding of different data environments (Data Lakes, Synapse, Delta Lakes).
• Proficiency in programming languages such as Python, Java, or Scala.
• Sound knowledge of data modelling, database design principles, data warehousing and data visualisation tools.
• Excellent attention to detail and collaboration skills.

Responsibilities

• Develop and maintain robust data pipelines to ingest, process, and transform data from various sources, while ensuring data reliability and quality.
• Implement seamless data integration processes supporting the continuous flow of information across the organisation.
• Design, optimise and manage databases to proficiently oversee data retrieval and storage, prioritising performance, availability and scalability.
• Craft efficient ETL processes transforming raw data into usable formats, including data cleaning, aggregation, and enrichment, streamlining data processing for enhanced efficiency.
• Build and maintain data warehouses for structured data storage, ensuring it is organised for easy retrieval, reporting and analysis.
• Implement stringent data quality checks and validation processes to ensure high accuracy, proactively monitoring and rectifying data integrity issues.
• Optimise data pipelines and databases for performance and scalability, anticipating future growth and evolving business needs.
• Enforce robust data security measures to uphold privacy regulations and safeguard against unauthorised access, ensuring data asset protection.
• Maintain comprehensive documentation for data pipelines, processes, and models, ensuring seamless knowledge transfer and ongoing support.
• Collaborate closely with cross-functional teams, fostering a data-driven culture by understanding requirements and delivering effective solutions together.

Skills

SQL

Relational databases

NoSQL databases

Python

Java

Scala

Data modelling

Tools

Azure Data Factory

Azure Logic Apps

Databricks

APIs

Data Lakes

Synapse

Delta Lakes

Job description

Lithia UK is recruiting a Data Engineer to design, build and optimise data pipelines and data warehouses. You will transform raw data into reliable, high-quality information to enable reporting and analytics.

The role combines hands-on data engineering with collaboration across teams in a hybrid setup at our Nottingham area hub. You will leverage SQL and NoSQL databases, Python/Java/Scala, and Azure Data Factory/Databricks to deliver scalable data solutions, while ensuring data quality and