SQL Reports Developer
Shared Services Connected Ltd
holborn, london
4d ago

The day job

You’ll be joining a team responsible for the paying of salaries,allowances and pensions to the UK Armed Forces and Veterans.

Also administerand pay compensation to injured service personnel, and run the associatedtechnical infrastructure and applications.

Part of the Joint PersonnelApplication (JPA) programme, it was implemented to modernise the way the ArmedServices carry out personnel and pay administration.

The Data Team (where this sits) is responsible for cyclical rate changes onJPA, data fixes, the support of Reports for Management Information (MI)purposes and the data loading activities associated with refreshing the VirtualTraining Environments.

The team also encompasses the overall strategic MIcapability, currently supported via OBIEE.

Key responsibilities

  • Maintain reference data within JPA’s Oracle EBS
  • Attend the Operational Control Board (OCB) as Data (including OBIEE) Team’s representative as required.
  • Maintain Serena Incidents for Data and OBIEE teams.
  • Correction of corrupt records, including, creating correction scripts
  • Assign OBIEE Serena Incidents to the appropriate team member
  • Refresh data sets within the Virtual Training Environments
  • Create and maintain reports in SQL to provide management information for queries regarding historic data, freedom of information requests and parliamentary questions.
  • Development of high quality database solutions using Oracle EBS
  • Essential Skills

    You will need to have :

  • Good experience of SQL Report writing and development
  • Experience of reviewing and interpreting ongoing business report requirements
  • Experience of research required data
  • Experience of building appropriate and useful reporting using SQL and associated tools
  • Experience of analysing existing SQL queries for performance improvements and suggesting new queries
  • Experience of developing procedures and scripts for data migration
  • Experience of providing timely scheduled management reporting
  • It would be great if you had :

  • Oracle EBS R12, Finance, HR, Payroll, CRM modules.
  • If you are interested in this role but not sure if yourskills and experience are exactly what we’re looking for, please do apply, we’dlove to hear from you!

    Full time permanent

    Location : Gosport, Hampshire

    SecurityClearance Level : Current SC of willing to undergo the vetting process.

    InternalRecruiter : Paul

    Salary : up to £35,000

    Benefits : 25days annual leave with the option to buy additional days, life assurance,pension, and generous flexible benefits fund

    Althoughthis role is advertised as full-time, we support different ways of working andcan offer a range of flexible working arrangements.

    So, if you’re interestedand need to work flexibly, we encourage you to apply and talk to us about whatmight be possible.

    Report this job
    checkmark

    Thank you for reporting this job!

    Your feedback will help us improve the quality of our services.

    Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Continue
    Application form