Are you looking for a new challenge and an opportunity to put your SQL knowledge to use to improve the way projects are monitored and managed? If you are a highly-motivated individual with a genuine interest in digital reporting, then London’s City Hall has the perfect job for you.
Open Project System (OPS) is the GLA’s grant and project management system, used across the GLA group. We are seeking an enthusiastic team player to join the team to support the system’s reporting function and tools.
Based within the OPS Delivery Team, you’ll work closely with reporting leads from across the GLA, MOPAC, and OPDC to set up their initial reporting structures within the system’s reporting tool and build and maintain critical reports for business users.
You will develop a deep understanding of the system’s data model and use that to write complex SQL queries for business and update/maintain this code as additional features and changes are introduced.
The ideal candidate will have excellent knowledge and experience of reporting and data analysis, utilising software such as JasperReport Server and Jaspersoft Studio. They will have advanced Structured Query Language (SQL) knowledge and experience writing and maintaining complex reports. They will also have proficiency in relational database management, maintenance and design.
Please read the JOB DESCRIPTION and PERSON SPECIFICATION
This role will be based at London’s City Hall (More London, SE1 2AA) with some travel to and working from London Fire Brigade’s Head Office (Union Street SE1 0LL).
London's diversity is its biggest asset and we strive to ensure our workforce reflects London's diversity at all levels. We welcome applications from everyone regardless of age, gender, ethnicity, sexual orientation, faith or disability.
We are committed to being an inclusive employer and we are happy to consider flexible working arrangements. We would welcome applications from candidates who are seeking part time work as this role is open to job share.
In addition to a good salary package, we offer an attractive range of benefits including 30 days’ annual leave, interest free season ticket loan, interest free bicycle loan, childcare voucher scheme and a career average pension scheme.
If you have a question about the role or the recruitment process then please contact a member of the recruitment team via email on glajobs@london.gov.uk quoting reference STAF1002
Application closing date: Sunday 31st May 2020 at 23:59 GMT
Interviews will take place at: To be confirmed – W/c 15th June 2020
We recognise the unique circumstances surrounding COVID-19, therefore we will be carrying out interviews via video conferencing. Further details on this will be provided if you are shortlisted for interview.
Please note we do not accept CV’s for this role. All applications for this vacancy must be submitted via our online recruitment system. To apply and to view a copy of the Job Description and Person specification, please click the "Apply Now" button below.