Data & Analytics Engineer

J C Bamford Excavators Ltd; Rocester; On-site; GBP 65,000 - 90,000; Full time

Benefits offered by this job

Gym on site

In-house doctor

In-house dentist

ULEV car scheme

Cycle to Work

33 days holiday

Company pension

Job summary

J C Bamford Excavators Ltd (JCB) is seeking a Data & Analytics Engineer to own the design, build, and optimization of data pipelines and analytics datasets on the Databricks Lakehouse. You will transform raw data into BI-ready gold models, ensure data quality, and enable fast, secure analytics.

You will work with key stakeholders and SI partners to gather requirements, deliver scalable solutions, and drive business value across a multinational landscape.

Qualifications

• Attention to detail and accuracy in data work.
• Customer-focused and able to build client relationships.
• Strong stakeholder communication and ability to translate business needs into data models.
• Documentation mindset including runbooks, catalog cards, and data contracts.
• Experience in a multinational business and complex system landscape.

Responsibilities

• Design and implement batch and streaming data pipelines (PySpark, Spark SQL, DLT, Auto Loader) across bronze, silver and gold layers.
• Implement CDC patterns, incremental loads, partition tuning, and data optimization.
• Build robust tests and observability (unit/integration tests, alerts, metrics).
• Orchestrate data workflows using Databricks Jobs.
• Collaborate on CI/CD with Platform teams (Repos, Git, deployment pipelines, IaC).
• Model curated gold datasets and semantic layers for BI tools (Tableau/PowerBI).
• Document tables with catalog cards including ownership, SLA, lineage, and data contracts.

Skills

PySpark

Spark SQL

Data modeling

CI/CD concepts

Stakeholder communication

Documentation

Tools

Databricks

Git

Terraform

CI/CD

Delta Lake

Job description

About the role:

The role calls for a self-motivated and result driven Data & Analytics Engineer to join JCB during an exciting time, as we embark on a transformational journey with our global data capabilities.

You will own the design, build, and optimisation of reliable data pipelines and well-governed analytical datasets on the Databricks Lakehouse. You will acquire & transform raw data (bronze) into high-quality, BI-ready models (gold), ensure data quality and lineage, and enable fast, secure analytics through SQL warehouses and Unity Catalogues.

The ideal candidate will work closely with key business stakeholders and our SI partners to gather requirements, optimise business processes and deliver scalable solutions that drive business value.

What does this roleinvolve day to day?

Data Engineering

• Design and implement batch/streaming pipelines (PySpark, Spark SQL, DLT, Auto Loader) across bronze, silver & gold layers.
• Implement CDC patterns, incremental loads, tune partitioning, Z Order, OPTIMIZE/VACUUM.
• Build robust tests (unit/integration), data expectations, and observability (alerts/metrics, runbooks).
• Orchestrate using Databricks Jobs.
• Collaborate on CI/CD with Platform (Repos, Git, deployment pipelines, Terraform Jobs/Infrastructure as Code).

Analytics Engineering

• Model curated gold datasets, dimensional models, and semantic layers for BI (Tableau/PowerBI).
• Optimise SQL Warehouses for performance, concurrency, and cost; maintain versioned metric definitions.
• Document tables with catalog cards (owner, SLA, lineage, data contracts); enable discoverability.

Governance & Security

• Implement access controls with Unity Catalog
• Adhere to naming conventions, tagging standards (owner, environment, cost centre, classification).
• Participate in access reviews, audit remediation, and privacy/compliance processes.

This will be suited to you if…

• Great attention to detail and excellent personal standards relating to accuracy and consistency.
• Be customerfocusedand build client relationships.
• Strong stakeholder communication; ability to translate business needs into value adding data models/pipelines.
• Documentation mindset (runbooks, catalog cards, readme's).
• Have experience of a multinational business and system landscape.
• Flexible and acting as a positive agent for change.
• Enjoy working as part of a team.

What happens next?

Ordinarily, our Resourcing Team reviews and shortlists CVs. If shortlisted, you'll speak to one of our Recruiters to discuss the role further. Our interview process usually consists of an initial team's interview followed by an in-person interview. We'll keep in touch throughout the process but if you have any questions, please get in touch at [e-mail]

What's in it for you?

This is your chance to join a company that values expertise not only in rewards but also in real employee care. At JCB you don't just get a competitive salary, 33 days' holiday and access to our company pension, you can also use our onsite gym, in-house doctor and dentist. We have an ULEV car scheme available for our employees too. Then there's our Cycle to Work Scheme.

We value diversity and welcome applications from candidates from all backgrounds.

We're committed to ensuring our recruitment process is fair and inclusive. If you face any accessibility challenges with your online application and require additional support, you have the option of speaking to a member of our Recruitment Team who can support you to complete an application in an alternative format. If you would benefit from this support, please email [e-mail], and a member of the team will be in touch.

Recruitment Agencies: JCB does not accept any speculative approaches to present candidates for advertised vacancies.