Data Engineer

Lithia UK; Nottingham; Hybrid; GBP 47,000; Full time

Job summary

A leading company in the automotive retail sector is seeking a Data Engineer to develop and maintain data pipelines, ensuring data quality and efficiency. The role requires strong SQL skills and experience with ETL tools, offering a competitive salary and comprehensive benefits. Join a culture that champions personal growth and innovation.

Benefits

33 days annual leave

Extra day off on your birthday

Paid day to volunteer

Cycle to work scheme

High street discounts

Qualifications

• Proven experience as a Data Engineer or similar role.
• Strong SQL skills with relational and NoSQL databases.
• Proficiency in programming languages such as Python, Java, or Scala.

Responsibilities

• Develop and maintain robust data pipelines to ingest, process, and transform data.
• Implement seamless data integration processes supporting continuous flow of information.
• Design, optimise and manage databases for data retrieval and storage.

Skills

SQL

Python

Data modelling

ETL processes

Data quality

Tools

Azure Data Factory

Databricks

Job description

Data Engineer

Hybrid - requirement to work from the office once every 2 weeks with additional ad hoc travel as required.

Salary of up to £47,000, pension, critical illness, life assurance, family health care, 33 days holiday (including bank holidays), exclusive company discounts on used car purchases, leasing deals and aftersales services.

As a Data Engineer, you will be responsible for developing and maintaining data pipelines, optimising databases, creating ETL processes, designing data models and ensuring data quality. Reporting into the Lead Data Engineer, you will use your expertise in data engineering to derive valuable insights from our data assets and shape data excellence at Pendragon.

If you're looking for a role that's a blend of being fast-paced and challenging, with a culture that enables you to be yourself and enjoy the ride, you'll feel right at home:

Your Journey as a Data Engineer:

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

Are you ready to embrace the challenge? We're looking for someone who has:

1. Proven experience as a Data Engineer or similar role.
2. Strong SQL skills with relational and NoSQL databases.
3. Demonstrated experience with data pipeline and ETL tools (e.g., Azure Data Factory, Azure Logic Apps, Databricks, APIs).
4. Understanding of different data environments (Data Lakes, Synapse, Delta Lakes).
5. Proficiency in programming languages such as Python, Java, or Scala.
6. Sound knowledge of data modelling, database design principles, data warehousing, and data visualisation tools.
7. Excellent attention to detail and creativity to design, develop and inform overall business strategy.
8. Ability to work collaboratively and is open to new ideas whilst appreciating the difference each person makes.

Why Lithia UK?

• Enjoy 33 days annual leave (including bank holidays), giving you more time to relax, recharge, and do what you love.
• Celebrate your special day with an extra day off on your birthday.
• Our industry-leading Family Leave Policies ensure you're supported when it matters most.
• Take a paid day to volunteer and give back to a cause close to your heart.
• We believe in recognising dedication and loyalty, that's why we celebrate long service milestone anniversaries.
• Unlock your potential with tailored training and endless career growth opportunities.
• Commute for less with our cycle to work scheme.
• Access high street discounts to make the everyday a little more rewarding.
• Know someone perfect for Lithia UK? Earn rewards through our internal referral scheme.

At Lithia UK, our growth is powered by our people:

As one of the largest automotive retailers globally, we're passionate about transforming the future of personal transportation and setting new standards for exceptional customer experiences. Our values—Earn Customers for Life, Improve Constantly, Take Personal Ownership, and Have Fun!—fuel everything we do. Join us, and you'll be part of a team that embraces innovation, champions personal growth, and celebrates success together. If you're ready to make an impact in an environment that empowers you to drive change, we'd love to have you with us on this journey.