Data & Analytics Engineer

JCB; Rocester; On-site; GBP 60,000 - 90,000; Full time

Benefits offered by this job

33 days holiday

Company pension

Onsite gym

In-house doctor and dentist

ULEV car scheme

JCB Rewards Hub discounts

Cycle to Work Scheme

Job summary

JCB in Rocester, United Kingdom, seeks a Data & Analytics Engineer to own the design, build and optimisation of data pipelines and governed datasets on the Databricks Lakehouse, transforming raw data into BI-ready gold models for fast analytics.

You will collaborate with stakeholders and SI partners to deliver scalable data solutions, focusing on data quality, security and discoverability across analytics layers.

Qualifications

• Experience designing data pipelines and analytical datasets.
• Knowledge of data governance, lineage, and cataloging practices.
• Ability to translate business needs into scalable data models.

Responsibilities

• Design and implement batch/streaming pipelines (PySpark, Spark SQL, DLT, Auto Loader).
• Orchestrate using Databricks Jobs and CI/CD via repos/ Terraform.

Skills

Stakeholder communication

Detail-oriented

Customer focus

Documentation mindset

Tools

PySpark

Spark SQL

Delta Live Tables

Auto Loader

Databricks Jobs

Unity Catalog

Terraform

Tableau

Power BI

Job description

Salary: Competitive Salary

Contract Type: Full Time

Working Pattern: Permanent

The Opportunity – Data & Analytics Engineer

Click here for our Careers & Life at JCB pages

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 role involve 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 customer focused and 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'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 the JCB Rewards Hub, which gives you discounts with high street retailers. Feel like biking to work? 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.