Data Engineer

Whitehall Resources Limited; Cambridge; Hybrid; GBP 65,000 - 90,000; Full time

Job summary

Whitehall Resources Limited is seeking a Data Engineer for a hybrid role with two days per week onsite in Cambridge and the remainder remote on a six-month contract. You will design and deliver scalable data solutions in Databricks, build AI-ready data products, and integrate enterprise systems.

The role requires strong Python, PySpark and SQL skills with expertise in data vault and lakehouse architectures.

Qualifications

• Minimum 4 years' data engineering experience with Databricks.
• Strong Python, PySpark and SQL skills.
• Experience designing scalable ETL/ELT pipelines and enterprise data models.
• Strong understanding of Data Vault, Delta Lake, Lakehouse and Medallion Architecture.
• Experience integrating enterprise systems via APIs and data interfaces.
• Experience with structured and unstructured data.
• Practical experience with Generative AI, RAG, embeddings, vector/semantic search and LLM integration.
• Experience with AI workflows, connecting models, data, APIs and tools.
• Experience with automated data quality, testing and monitoring.
• Experience with Git and CI/CD; understanding of data governance and security.

Responsibilities

• Design, build and maintain scalable ETL/ELT pipelines using Databricks, PySpark, SQL and Python.
• Build trusted data products using Lakehouse and Medallion Architecture.
• Integrate data from enterprise systems and AI platforms for reporting and analytics.
• Develop data pipelines for AI usage, telemetry and performance analytics.
• Implement RAG pipelines including embeddings and vector search.
• Integrate LLMs and enterprise data to support AI applications and agents.
• Create AI orchestration workflows connecting models, data, tools and business processes.
• Ensure automated data quality, testing and monitoring; optimise for performance and cost.
• Contribute to data governance, metadata, lineage, security and documentation.
• Use Git and CI/CD for automated deployment.

Skills

Databricks

Python

PySpark

SQL

ETL/ELT pipelines

Data modeling

AI/RAG/LLM integration

APIs/integration

Git & CI/CD

Data governance & security

Tools

Databricks platform

Spark

Job description

Whitehall Resources are looking for a Data Engineer. This role is hybrid working with 2 days per week onsite in Cambridge, and the remainder remote working on an initial 6 month contract.

***Inside IR35***

Job Overview:

We are seeking an experienced Data Engineer to design and deliver scalable, high-quality data solutions in Databricks. You will play a key role in evolving our enterprise data platform, creating trusted, AI-ready data products that power reporting, analytics, automation and AI across Enterprise IT.

You will design and build modern data pipelines integrating enterprise platforms such as AI platforms including Microsoft Copilot, OpenAI and other enterprise AI services.

The role will also contribute to our growing AI capabilities, engineering solutions for AI usage and adoption data, Retrieval-Augmented Generation (RAG), LLM integration and AI orchestration.

• Responsibilities:Design, build and maintain scalable ETL/ELT pipelines using Databricks, PySpark, SQL and Python.
• Build trusted data products using Lakehouse and Medallion Architecture principles.
• Integrate data from enterprise systems including ServiceNow, Jira, Azure DevOps and AI platforms such as Copilot and OpenAI.
• Build data pipelines for AI usage, adoption, telemetry and performance analytics.
• Design and implement RAG pipelines, including ingestion, embeddings, vector/semantic search and retrieval.
• Integrate LLMs, APIs and enterprise data to support AI applications and agents.
• Build and maintain AI orchestration workflows connecting models, data, tools and business processes.
• Implement automated data quality, testing, monitoring and validation.
• Optimise solutions for performance, scalability, reliability and cost.
• Contribute to data governance, metadata, lineage, security and documentation.
• Use Git and CI/CD to support automated and reliable deployment.
• Required Skills and Experience:Minimum 4 years' data engineering experience, with strong experience in Databricks.
• Strong Python, PySpark and SQL skills.
• Experience designing scalable ETL/ELT pipelines and enterprise data models.
• Strong understanding of Data Vault, Delta Lake, Lakehouse and Medallion Architecture.
• Experience integrating enterprise systems through APIs and other data interfaces.
• Experience working with structured and unstructured data.
• Practical experience with Generative AI, RAG, embeddings, vector/semantic search and LLM integration.
• Experience with AI or workflow orchestration, connecting models, data, APIs and tools.
• Experience with automated data quality, testing and monitoring.
• Experience with Git and CI/CD and good understanding of data governance and security.
• Nice to Have Skills and Experience:Experience with Microsoft Copilot, OpenAI/Azure OpenAI or Microsoft Graph.
• Experience with Databricks AI capabilities, including Mosaic AI and Vector Search.
• Experience with orchestration frameworks such as LangChain, LangGraph or Semantic Kernel.
• Experience developing AI agents or agentic workflows.
• Experience with Jira, ServiceNow or Azure DevOps data.
• Knowledge of Power BI, Tableau or AI/BI.
• Familiarity with Agile delivery and iterative development.
• Strong communication and collaboration skills.