Senior Software Engineer
- Sopra Steria
- Gosport, Hampshire
- 24/09/2022
Full time
Information Technology
Telecommunications
Job Description
Are you an expert in SQL scripts for JPA (Joint Personnel Applications) and Oracle!? Are you considering a new and exciting challenge, where you can make the most of your skills? If so this role may be just for you!
We are looking for a Senior Software Engineer with an in depth knowledge of SQL to our team of Software Engineers. The team run the technical infrastructure applications that are responsible for coordinating pay for veterans. They complete data fixes on JPA, the support of archived preserved data for Management Information (MI) purposes and the data loading activities associated with refreshing the Virtual Training Environments.
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:
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:
It would be great if you had:
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!
Although this role is advertised as full-time, we support different ways of working and can offer a range of flexible working arrangements. So, if you're interested and need to work flexibly, we encourage you to apply and talk to us about what might be possible.
Employment Type: Full-time Permanent
Location: Gosport
Security Clearance Level: SC
Internal Recruiter: Theo
Salary: £46,969 - £56,363 DOE
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.
We embrace difference as a source of creativity, innovation and competitive advantage and are striving to become a more diverse organisation. We welcome applications from people with a diverse variety of backgrounds and identities. We are committed to equality of opportunity for all and do not discriminate on the basis of race, religion, colour, gender, age, disability, sexual orientation or marital status. We have partnered with Vercida , the UK's largest diversity and inclusion focused careers site, where all our vacancies are available in an accessible format.
If you require any adjustments to the recruitment process, to enable you to perform to the best of your ability, please let us know when completing your application. We participate in the Disability Confident scheme and are committed to offering an interview to any candidate with a disability, who meets the minimum criteria for the role. If you believe this could apply to you, please let us know when completing your application.
We are looking for a Senior Software Engineer with an in depth knowledge of SQL to our team of Software Engineers. The team run the technical infrastructure applications that are responsible for coordinating pay for veterans. They complete data fixes on JPA, the support of archived preserved data for Management Information (MI) purposes and the data loading activities associated with refreshing the Virtual Training Environments.
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:
- Manage SQL scripts, collaborating closely with ORACLE on the content of scripts and running 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.
- 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
- SQL and PL experience
- 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!
Although this role is advertised as full-time, we support different ways of working and can offer a range of flexible working arrangements. So, if you're interested and need to work flexibly, we encourage you to apply and talk to us about what might be possible.
Employment Type: Full-time Permanent
Location: Gosport
Security Clearance Level: SC
Internal Recruiter: Theo
Salary: £46,969 - £56,363 DOE
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.
We embrace difference as a source of creativity, innovation and competitive advantage and are striving to become a more diverse organisation. We welcome applications from people with a diverse variety of backgrounds and identities. We are committed to equality of opportunity for all and do not discriminate on the basis of race, religion, colour, gender, age, disability, sexual orientation or marital status. We have partnered with Vercida , the UK's largest diversity and inclusion focused careers site, where all our vacancies are available in an accessible format.
If you require any adjustments to the recruitment process, to enable you to perform to the best of your ability, please let us know when completing your application. We participate in the Disability Confident scheme and are committed to offering an interview to any candidate with a disability, who meets the minimum criteria for the role. If you believe this could apply to you, please let us know when completing your application.
About Sopra Steria