Solutions Analyst

South East Water Limited; Snodland; Hybrid; GBP 40,000 - 55,000; Full time

Benefits offered by this job

Stakeholder pension scheme

25 days holiday + bank holidays

Flexible annual leave

Paid volunteering days

Cycle to work scheme

Health cash plan

Life assurance

Wellbeing related benefits

Job summary

South East Water is seeking a Solutions Analyst/Developer to design, build, and modernise Oracle-based applications within a hybrid on-premise and Google Cloud Platform (GCP) data-centre. You will craft secure, responsive Oracle APEX interfaces and robust PL/SQL, while enabling cross-data-centre syncing and REST APIs via ORDS.

You will collaborate with Cloud Engineers and DBAs, optimising queries, and ensuring data integrity across massive datasets, with equity and security at the core.

Qualifications

• Experience with Oracle Database 19c/23c and PL/SQL development.
• Proven Oracle APEX development experience, including UI/UX and plugins.
• Experience building REST APIs with ORDS and data integration in hybrid environments.

Responsibilities

• Design, develop, and maintain Oracle APEX applications.
• Build and manage interactive grids, charts, and reports.
• Write clean, optimized PL/SQL code and improve performance.
• Collaborate with Cloud Engineers and DBAs for hybrid on-prem/GCP infrastructure.
• Develop and expose RESTful services using ORDS.

Skills

Oracle Database

PL/SQL

Oracle APEX

API Development

HTML/CSS/JS

JSON

GCP

CI/CD

Git

SQL Server

BigQuery

Education

Bachelor's degree in Computer Science/IT

Tools

ORDS REST APIs

GitLab CI

Google Cloud Platform

Job description

Summary: As our Solutions Analyst/Developer at South East Water, you will design, build, deploy, and constantly improve our Oracle-based applications and databases. You'll work right at the intersection of our hybrid setup, bridging our on-premise data centre with our modern Google Cloud Platform (GCP) environment. In this role, you'll write highly efficient database code and use Oracle APEX to design clean web interfaces, keeping our data flowing smoothly between both worlds. We are a forward-thinking technology team bridging the reliability of robust, secure on-premise infrastructure with the dynamic scalability of the cloud. Our core systems are built on Oracle and Google Cloud Platform (GCP). We are seeking a highly skilled Developer to design, develop, and modernise our suite of business-critical web applications. If you are a database-centric developer who loves building highly responsive low-code applications while navigating the exciting complexities of a hybrid on-premise/GCP multi-data-centre architecture, we want to hear from you!

Main Responsibilities

Oracle APEX & Web Development

Design, develop, and maintain secure, responsive, and user-friendly Oracle APEX applications.

Implement custom UI/UX requirements using HTML, CSS, JavaScript, and custom APEX plugins.

Configure APEX authentication and authorization schemes integrated with enterprise Identity Providers (IdP).

Build and manage interactive grids, charts, and highly customized reports.

Database Engineering & PL/SQL

Write clean, maintainable, and highly optimized PL/SQL code (packages, procedures, functions, triggers, and types).

Architect and design relational data models, ensuring data integrity, normalization, and performance efficiency.

Perform query tuning, analyse execution plans, and optimize indexes to ensure low latency across massive datasets.

Build robust RESTful APIs using Oracle REST Data Services (ORDS) to expose database endpoints.

Hybrid Infrastructure & Cloud Integration

Collaborate with Cloud Engineers and DBAs to support database infrastructure running on-premise and on Google Cloud Platform (GCP).

Support data replication, ETL pipelines, and secure networking between on-premise Oracle databases and GCP-hosted resources (e.g., Cloud SQL, Compute Engine, BigQuery).

Develop routines for cross-data-center data synchronization and integrity validation.

Participate in database migration plans, backup strategies, and Disaster Recovery (DR) drills involving both on-premise and GCP topologies.

You’ll need:

• Skills / Qualifications / Experience
• Oracle Database: Extensive knowledge of Oracle Database 19c / 23c database objects, memory architecture, and optimization.
• PL/SQL Mastery: Expert-level writing of complex PL/SQL block structures, analytical functions, bulk collections, and exception handling.
• Oracle APEX: Strong experience with modern APEX version 24 and newer, custom themes, templates, and JavaScript integration.
• API Development: Proficient in configuring and developing ORDS REST APIs.
• Web Basics: Solid foundational understanding of HTML5, CSS3, JavaScript, and JSON formatting.
• Cloud Infrastructure: Familiarity with GCP core services (GCE, Cloud SQL for MySQL, Cloud Storage and IAM).
• CI/CD & DevOps: Experience with Git version control and CI/CD pipelines (such as GitLab CI, or Google Cloud Build).
• Alternative Databases: Experience with SQL Server & Google BigQuery is a strong plus.
• Degree in Computer Science, Information Technology, or a closely related quantitative field.
• Demonstrable professional experience in Oracle PL/SQL development.
• Demonstrable experience specifically developing and deploying applications with Oracle APEX.

Grow a career with a meaningful purpose.

We know the communities we serve are diverse. We recognise creativity comes from diversity not similarity. That’s why we are enthusiastic about creating inclusion across age, race, gender, ethnicity, religion and identity. You will experience our dedication to equal opportunities and fair treatment for all: through your recruitment, employment and career progression with South East Water.

Benefits package

• Excellent Stakeholder pension scheme, up to 10% employer contribution.
• 5 weeks holiday plus bank holidays per annum, increasing to 6 weeks with length of service.
• Flexible annual leave policy to buy or sell holiday leave.
• Paid volunteering days.
• Cycle to work scheme.
• Health cash plan.
• Life assurance.
• Wellbeing related benefits.

It is necessary for you to have the legal right to work in the UK when you begin employment with South East Water. Additionally, as part of the employment offer, you will need to pass background, identity, and employment referencing checks.

Compensation package

£40,000 - £55,000 p.a. (dependent on experience)

Be you, belong and valued.

Grow a career with a meaningful purpose.

We supply top-quality drinking water to 2.3 million customers in the southeast of England. Through a network of 9,000 miles of pipe, we deliver 544 million litres of water every day. It's the skill and expertise of our employees that ensures our water meets the highest standards. We make sure we can meet the needs of our customers both now and in the future.

Grow a career with a meaningful purpose.

• Come to work to be safe, valued, and trusted.
• We’ll encourage you to create and pursue new opportunities for personal growth.
• A place to be the real you, build deeper connections and enjoy a sense of belonging.
• Be invested in helping us to create a sustainable water supply for now, and in the future.