Data Team Consultant

Do you have extensive knowledge of drafting, implementing, and auditing SQL scripts for JPA (Joint Personnel Applications) and Oracle? Are you looking for somewhere you can make the most of your skills and develop new ones? If so this role may be just for you
The service was formed in 2007 to provide harmonised administration services and accurate processing of pay, allowances, and pensions to the veterans’ communities. IT looks to modernise the way the Client carry out pay administration, based on the introduction of policy and regulations supported by new administration processes and Commercial Off The Shelf (COTS) software.
The role is Hybrid with two days per week based in our Gosport office and 3 days remote.

**What you’ll be doing**:
Creating SQL scripts, collaborating closely with ORACLE on the content of scripts and acquiring their approval to run scripts on JPA.
Producing paperwork for RCB, updating dimensions, creating DBA requests, obtaining customer approval for the changes, Liaising with the functional team members during process.
Assist with the resolution of queries raised with the Data Team and other teams.
Maintain reference data as supplied approved agencies from the Authority, taking them through the Release Control Board (RCB) process.
Maintain accurate figures for work carried out against the Measure of Performance identifiers.
Correction of bulk corrupt records, including, creating GFF or SQL correction scripts.
Move documentation, SQL Scripts, spreadsheets etc between the production and development environments against an approved Variance.
Maintain Serena Incidents for the team.
Create Data Loader scripts.
Interrogate the DPR using SQL to formulate responses to customer queries.
Advise on matters relating to VTE, DPR and DPRR as required.
The team is growing as workload increases and therefore there may be responsibility to deliver training and support to newer members of the team in the future.

**What you’ll Bring**:
Experience working with Oracle / JPA
Knowledge of writing SQL Scripts
Ability to prioritise and facilitate large workloads.

**It would be great if you had**:
Prior experience working with a government client.
If you are interested in this role but not sure if your skills and experience are exactly what we’re looking for, please do apply, we’d love to hear from you
Employment

**Type**: Full-time, Permanent

**Location**: Gosport (2 Days office based)

**Security Clearance Level**: SC

**Internal Recruiter**: Theo

**Salary**: £35,000

**Benefits**: 25 days
annual leave with the choice to buy additional days, life assurance, pension,
and generous flexible benefits fund
Loved reading about this job and want to know more about SSCL?
Shared Services Connected Ltd was established as a joint venture between the Cabinet Office and Sopra Steria, in 2013 as part of the Government’s Shared Services Strategy for Smarter Government programme and operates from four regional centres of excellence: Blackpool; Newcastle; Newport; and York. We deliver best in class business transformation programmes to across the Public Sector with a target to release one billion pounds of savings to the public.
We have established an enviable track record in the design and delivery of large-scale innovative HR, Payroll, IT, and Finance & Accounting solutions to significantly improve efficiencies and enhance service levels across Government and Public Sector.
Our clients include several government agencies including the Department for Work and Pensions, Environment Agency Department for Education, Ministry of Justice and Home Office as well as the Metropolitan Police Service and the Construction Industry Training Board.