Oracle Data Warehouse Developer (SC Cleared)

Syntax Consultancy Ltd; Andover; Hybrid; GBP 92,250 - 119,925; Full time

Job summary

Syntax Consultancy Ltd is seeking an Oracle Data Warehouse Developer (SC Cleared) for a 6-month contract in Andover. Hybrid working – 3 days remote, 2 days on-site, with a July/August 2026 start.

You will design, develop and implement Oracle DW solutions, ODI mappings and OAS security, and create dashboards to support analytics. Production support and performance tuning are included.

Active SC clearance and strong ODI/OAS experience are essential for this role.

Qualifications

• Strong ODI and Oracle Analytics Server experience.
• Active SC Security Clearance is essential.

Responsibilities

• Design, develop and implement Oracle Data Warehouse solutions including data modelling and integration.
• ODI mappings for ETL processes.
• OAS security including users, roles and data-level security.
• Developing and implementing OAS reports and dashboards for analytics and reporting.
• Production support for Oracle OAS, ODI and data warehouse objects.
• Performance tuning of RPD objects, ODI mappings, queries and reports.
• Maintain and document standard processes and documentation.

Skills

ETL

Data warehousing

Tools

Oracle ODI

Oracle Analytics Server (OAS)

Job description

Overview

Oracle Data Warehouse Developer (SC Cleared) – Andover (Hybrid)

Contract: 6 Month Contract • Start ASAP in July/August 2026 • Hybrid Working – 3 days remote, 2 days on-site • Pay: £(Apply online only)/day (Outside IR35)

Responsibilities

• Designing, developing and implementing Oracle Data Warehouse solutions including data modelling and integration.
• RPD Repository design in Oracle Analytics.
• Designing, developing and implementing Oracle Data Integrator (ODI) mappings for ETL processes.
• Designing, developing and implementing Oracle Analytics Server (OAS) security including users, roles and data-level security.
• Developing and implementing OAS reports and dashboards to support business analytics and reporting needs.
• Providing Production Support for existing live Oracle OAS, ODI and data warehouse objects.
• Resolving data, ETL and reporting issues to ensure system stability.
• Performance tuning of RPD objects, ODI mappings, queries and reports.
• Maintaining and documenting standard processes, procedures and technical documentation.
• Autonomous Data Warehouse (ADW) design, development and implementation experience is advantageous.

Qualifications & Requirements

• Strong Oracle Data Integrator (ODI) and Oracle Analytics Server (OAS) experience.
• Active SC Security Clearance is essential for this contract.