Software Engineer III

Job-ID: 26492Category: TechnologyLocation: London, United Kingdom; Rotherham, South Yorkshire, United Kingdom; Manchester, Lancashire, United KingdomWorkplace: HybridSchedule: Full timePosted: 2026-10-23Closes: 2026-11-20Role: Software Engineer III (Oracle APEX)Division: Assessment & Qualifications Delivery Location: Rotherham, Manchester or London

Please read the information in this job post thoroughly to understand exactly what is expected of potential candidates.
- HybridThis role aligns with positions typically advertised in the external market as Oracle APEX Developer, Oracle Developer or Oracle PL/SQL Developer. About Pearson: At Pearson we ‘add life to a lifetime of learning’ so everyone can realise the life they imagine.

We do this by creating vibrant and enriching learning experiences designed for real-life impact.

Our Purpose | Add Life to a Lifetime of Learning.

Pearson was founded in 1844 and has been built on our ability to grow with and adapt to a constantly evolving market.

Our 20,000+ employees are dedicated to creating high-quality, digital-first, accessible and sustainable resources for lifelong learning. About the Job We are looking for an Oracle Engineer to join the team delivering our TOpS programme.

You will design, build and support Oracle database solutions and Oracle APEX applications, and own the data pipelines that ingest, transform and validate data from multiple internal and external sources.

Data quality sits at the heart of this role: the information you manage underpins operational decisions and reporting, so accuracy, traceability and reliability matter. The role involves working closely with business SMEs, product owners, architects, QA engineers, and fellow developers, so excellent communication and analysis skills are essential.

You will also be expected to explain technical designs and decisions clearly to non-technical colleagues. Key Responsibilities Design, develop and maintain Oracle APEX applications, from data model through to user interface, security and deployment. Write and optimise high-quality SQL and PL/SQL, including packages, procedures, functions and triggers that support business applications. Build, schedule and monitor data pipelines (ETL/ELT) that load, transform and reconcile data between Oracle and other systems. Implement data validation rules, reconciliation checks and exception handling so that data issues are caught early and resolved at source. Tune the performance of queries, pipelines and APEX pages, using execution plans, indexing and partitioning strategies. Contribute to code reviews, automated testing, CI/CD and technical documentation. Support live services by investigating and resolving incidents and data defects. About You This role would suit someone with a solid background in Oracle development who has built and supported Oracle APEX applications in a commercial setting, and who has worked on data transformation or integration projects.

You will be curious about data and its value, take pride in getting it right, and enjoy working on fast-moving, business-critical projects where you can contribute to design decisions. Key Skills & Experience Oracle Database, SQL and PL/SQL Strong hands-on experience with Oracle Database (19c or later). Expert SQL and PL/SQL, including packages, bulk processing (BULK COLLECT/FORALL), dynamic SQL, collections and robust exception handling. Relational data modelling and normalisation, with an understanding of dimensional/data warehouse design. Performance tuning using execution plans, indexing, partitioning, and Oracle diagnostic tools. Oracle APEX Commercial experience designing, building and supporting Oracle APEX applications on recent releases. Confident use of interactive reports and grids, forms, faceted search, dynamic actions, processes, validations and shared components. Implementing authentication and authorisation schemes, role-based access and APEX security good practice (e.g.

session state protection, preventing SQL injection and XSS). Building and consuming REST services using Oracle REST Data Services (ORDS) and APEX REST Data Sources. JavaScript, HTML and CSS for customising the APEX user interface; experience with APEX plug-ins is an advantage. Managing the APEX application lifecycle: exports, supporting objects, promotion between environments and source control. Data Pipelines and Transformation Designing and building ETL/ELT pipelines, including staging, transformation, incremental loading and Change Data Capture (CDC) concepts. Scheduling and orchestration with DBMS_SCHEDULER, and loading data using external tables, SQL
*Loader, Data Pump or DBMS_CLOUD. Integrating data from files (CSV, JSON, XML) and APIs from multiple internal and external sources. Implementing pipeline monitoring, logging, and alerting to identify and address issues proactively. Data Quality Designing and implementing data validation rules,