Oracle Data & Analytics Lead (Data Lakehouse)

CAPGEMINI; Newcastle Emlyn; Hybrid; GBP 65,000 - 95,000; Full time

Job summary

Capgemini is seeking an experienced data consultant to design and implement advanced data warehousing and lakehouse solutions for Oracle-centric environments. You will work across UK client engagements, translating complex data landscapes into scalable analytics platforms and dashboards.

Ideal candidates will bring hands-on Oracle DB/ADW experience, SQL and Python proficiency, and a good grasp of data modelling (Dimensional, Data Vault 2.0). UK SC eligibility is required or already held.

Qualifications

• Experience designing data warehouses and lakehouses, especially in Oracle contexts.
• Hands-on with Oracle Database and Autonomous Data Warehouse.
• Knowledge of Oracle BI tools OTBI and BI Publisher.
• Proficiency in SQL and Python.
• Knowledge of dimensional modelling and Data Vault 2.0.
• Experience deploying data models into data warehouses and lakehouses.
• Familiarity with Agile delivery models.
• Eligible for UK Security Check (SC) or already SC and UK national.

Responsibilities

• Architect and implement data warehousing and analytics solutions, including data lakehouses.
• Deliver projects UK-wide on time and to customer expectations.
• Champion Oracle cloud-native data and analytics technologies internally and for clients.
• Share knowledge with colleagues and the wider community through blogs or articles.

Skills

Data warehousing and lakehouse design

Oracle Database

Oracle Autonomous Data Warehouse

Oracle Analytics Cloud / OTBI / BI Pbl

SQL

Python

Dimensional modelling

Data Vault 2.0

Agile delivery

UK SC eligibility / UK national

Tools

Oracle Data Integrator

OCI / Data tools

PowerBI

Snowflake / Databricks (awareness)

Job description

Capgemini is seeking an experienced data consultant to design and implement advanced data warehousing and lakehouse solutions for Oracle-centric environments. You will work across UK client engagements, translating complex data landscapes into scalable analytics platforms and dashboards.

Ideal candidates will bring hands-on Oracle DB/ADW experience, SQL and Python proficiency, and a good grasp of data modelling (Dimensional, Data Vault 2.0). UK SC eligibility is required or already held.