Job description

Job responsibilities

The post holder is the lead specialist responsible for ensuring that the Trust has access to high quality workforce data and information to support workforce and vehicle utilisation and planning, monitoring and development of services. The post holder is also accountable for all overtime and disruption payments ensuring that claims meet the current criteria set out in the respective bulletin for that period. Responsible for the effective running of GRS across the Trust. This includes first point of contact for all queries and developments, and assisting with troubleshooting and solving any problems with the systems Serves both as a technical and resourcing expert. Recommends new developments, investigates and analyses feasibility of system requirements and develops system specification. Identifies methods, solutions and provides project leadership and management in order to provide a high level of service that will benefit the Trust Foremost liaison between the LAS and third party system suppliers. Responsible for projects managing the implementation of developments in GRS within the Trust, working in partnership with relevant departments and third party suppliers. Freedom to research, design and develop intricate data sets and has the autonomy to change procedures to ensure the Trust meets its requirements for staffing and budgetary reporting. Ensure that data quality of information held in the systems is of a high quality, up to date and adheres to the data protection Act 1998. Develop procedures to maintain the quality and auditing of the data Oversee the management of data cleansing and data validation exercises of information held in the systems and ensure that these are completed in a timely manner Oversee the management of data sent to the payroll department for overtime and rest breakpayments Oversee the management of data cleansing and data validation between GRS and ESR Continually adapt to new working practices, system changes and technology changes and take responsibility for keeping up to date with these changes. Develop / update systems, databases and spread sheets in response to these changes Provide training in the use of the resourcing systems, both within and outside the department, for new users and upon implementation of new modules or developments Represent the Trust at the National Resource Managers Forum whereby GRS users meet to discuss areas of common concern and share best practice. Maintain network relationships with other Services, contributing ideas and seeks advice when necessary. Responsible for the forecast accuracy of number of 999 calls. This requires understanding of internal and external factors affecting the Service in order to explain deviations in the forecast and take corrective measures in advance. Develop existing and new databases (using SQL Server or MS Access) and complex spread sheets (using Excel) to improve information gathering and analysis Develop databases and spread sheets which are user friendly and tailored to meet the needs of the customer Develop complex queries using Structured Query Language to interrogate the databases and adapt them on an on-going basis Influence data collection procedures outside the department which affect information provision, including the design of operational forms within the service Set up processes to extract and manipulate complex data from systems created outside the department. Assist in the specification and tendering process for new information systems both within and outside the department Provide advanced support and advice for other database developers Use creativity, imagination and innovative ideas to resolve resourcing issues and problems which prevent the service from providing the provision of high quality patient care

Job responsibilities

The post holder is the lead specialist responsible for ensuring that the Trust has access to high quality workforce data and information to support workforce and vehicle utilisation and planning, monitoring and development of services. The post holder is also accountable for all overtime and disruption payments ensuring that claims meet the current criteria set out in the respective bulletin for that period. Responsible for the effective running of GRS across the Trust. This includes first point of contact for all queries and developments, and assisting with troubleshooting and solving any problems with the systems Serves both as a technical and resourcing expert. Recommends new developments, investigates and analyses feasibility of system requirements and develops system specification. Identifies methods, solutions and provides project leadership and management in order to provide a high level of service that will benefit the Trust Foremost liaison between the LAS and third party system suppliers. Responsible for projects managing the implementation of developments in GRS within the Trust, working in partnership with relevant departments and third party suppliers. Freedom to research, design and develop intricate data sets and has the autonomy to change procedures to ensure the Trust meets its requirements for staffing and budgetary reporting. Ensure that data quality of information held in the systems is of a high quality, up to date and adheres to the data protection Act 1998. Develop procedures to maintain the quality and auditing of the data Oversee the management of data cleansing and data validation exercises of information held in the systems and ensure that these are completed in a timely manner Oversee the management of data sent to the payroll department for overtime and rest breakpayments Oversee the management of data cleansing and data validation between GRS and ESR Continually adapt to new working practices, system changes and technology changes and take responsibility for keeping up to date with these changes. Develop / update systems, databases and spread sheets in response to these changes Provide training in the use of the resourcing systems, both within and outside the department, for new users and upon implementation of new modules or developments Represent the Trust at the National Resource Managers Forum whereby GRS users meet to discuss areas of common concern and share best practice. Maintain network relationships with other Services, contributing ideas and seeks advice when necessary. Responsible for the forecast accuracy of number of 999 calls. This requires understanding of internal and external factors affecting the Service in order to explain deviations in the forecast and take corrective measures in advance. Develop existing and new databases (using SQL Server or MS Access) and complex spread sheets (using Excel) to improve information gathering and analysis Develop databases and spread sheets which are user friendly and tailored to meet the needs of the customer Develop complex queries using Structured Query Language to interrogate the databases and adapt them on an on-going basis Influence data collection procedures outside the department which affect information provision, including the design of operational forms within the service Set up processes to extract and manipulate complex data from systems created outside the department. Assist in the specification and tendering process for new information systems both within and outside the department Provide advanced support and advice for other database developers Use creativity, imagination and innovative ideas to resolve resourcing issues and problems which prevent the service from providing the provision of high quality patient care

Person Specification

Qualifications, Accreditations, Education

Essential

• Post-Graduate level of education or equivalent experience and expertise of providing workforce and finance data analysis in a work environment

Experience

Essential

• Highly developed experience of producing, analysing and interpreting information in a work environment, including manipulating data sets, analysing data, presenting findings in appropriate formats and making recommendations
• Extensive experience of working with complex, conflicting and contentious information
• Extensive experience of using, creating and developing databases in SQL Server or MS Access in a work environment (including creating complex queries using structured query language to interrogate the data, creating procedures and reports)
• Experience of managing staff, leading teams and being a role model to staff

Knowledge and Skills

Essential

• Ability to analyse complex and sometimes conflicting data sets, with a logical approach
• Ability to develop, maintain and adapt databases (using SQL or Access) and spread sheets (MS Excel) for personal use as well as the use of others in a changing environment
• Ability to tailor information systems to meet users requirements
• Ability to solve problems and make informed recommendations based on detailed data analysis
• Excellent numeracy skills, with the ability to use statistical techniques
• Accurate with attention to detail
• Ability to concentrate when carrying out detailed analysis over sustained periods
• Excellent written and oral communication skills
• Excellent interpersonal skills, including ability to negotiate and persuade
• Ability to manage / organise own workload and plan work according to changing priorities and deadlines
• High level of personal motivation with the ability to work independently using own initiative, or as part of a team
• Understanding of rota systems
• Ability to make own decisions on how issues should be resolved and how results are best achieved, implementing those decisions as appropriate
• Ability to delegate and supervise the work of others within the department
• Ability to promote and deliver a customer focused service
• Ability to use different influencing skills appropriate to the outcomes of findings, especially when findings do not support initial assumptions or expectations
• Advanced keyboard skills, including ability to input a large amount of data quickly and accurately

Desirable

• Comprehensive knowledge in the system administration of GRS or similar
• Experience of working within a customer orientated organisation
• Experience of co-ordinating resources to meet objectives

Personal Abilities

Essential

• Be forward thinking, flexible and open to change
• A commitment to excellence in all areas of work
• To understand, promote and demonstrate commitment to the Values of the London Ambulance Service.

Qualifications, Accreditations, Education

Essential

• Post-Graduate level of education or equivalent experience and expertise of providing workforce and finance data analysis in a work environment

Experience

Essential

• Highly developed experience of producing, analysing and interpreting information in a work environment, including manipulating data sets, analysing data, presenting findings in appropriate formats and making recommendations
• Extensive experience of working with complex, conflicting and contentious information
• Extensive experience of using, creating and developing databases in SQL Server or MS Access in a work environment (including creating complex queries using structured query language to interrogate the data, creating procedures and reports)
• Experience of managing staff, leading teams and being a role model to staff

Knowledge and Skills

Essential

• Ability to analyse complex and sometimes conflicting data sets, with a logical approach
• Ability to develop, maintain and adapt databases (using SQL or Access) and spread sheets (MS Excel) for personal use as well as the use of others in a changing environment
• Ability to tailor information systems to meet users requirements
• Ability to solve problems and make informed recommendations based on detailed data analysis
• Excellent numeracy skills, with the ability to use statistical techniques
• Accurate with attention to detail
• Ability to concentrate when carrying out detailed analysis over sustained periods
• Excellent written and oral communication skills
• Excellent interpersonal skills, including ability to negotiate and persuade
• Ability to manage / organise own workload and plan work according to changing priorities and deadlines
• High level of personal motivation with the ability to work independently using own initiative, or as part of a team
• Understanding of rota systems
• Ability to make own decisions on how issues should be resolved and how results are best achieved, implementing those decisions as appropriate
• Ability to delegate and supervise the work of others within the department
• Ability to promote and deliver a customer focused service
• Ability to use different influencing skills appropriate to the outcomes of findings, especially when findings do not support initial assumptions or expectations
• Advanced keyboard skills, including ability to input a large amount of data quickly and accurately

Desirable

• Comprehensive knowledge in the system administration of GRS or similar
• Experience of working within a customer orientated organisation
• Experience of co-ordinating resources to meet objectives

Personal Abilities

Essential

• Be forward thinking, flexible and open to change
• A commitment to excellence in all areas of work
• To understand, promote and demonstrate commitment to the Values of the London Ambulance Service.

Disclosure and Barring Service Check

This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.

Certificate of Sponsorship

Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).

From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).

Certificate of Sponsorship

Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).

From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).

Employer details

Employer name

London Ambulance Service NHS Trust

Address

ECS Scheduling Management

Waterloo Ambulance Station, 220 Waterloo Road, London

London

SE1 8SD

Employer's website

https://www.londonambulance.nhs.uk/ (Opens in a new tab)