Trac proudly powers the recruitment for
London Ambulance Service NHS Trust
The London Ambulance Service NHS Trust (LAS) is the largest free ambulance service in the world, caring for more than one-and-a-half million patients every year.
We are the only London-wide NHS Trust and are at the frontline of the NHS in the capital. We serve an area of approximately 620 square miles. Broadly speaking, this is the whole area within the M25.
We have two main functions - the provision of an Accident and Emergency service to respond to 999 calls and our Patient Transport Service, which performs an important role in taking patients to and from their hospital appointments.
In addition, we also manage the Emergency Bed Service, which co-ordinates registers of specialised care facilities available across London, along with some national monitoring services.
Senior Business Intelligence Analyst
Closed for applications on: 28-Jul-2021 00:00
Vacancy status: Closed
Closed for applications on: 28-Jul-2021 00:00
- Waterloo HQ
- SE1 8SD
- Major / Minor Region
Contract type & working pattern
- Fixed term: 12 months (or Secondment - 12 months)
- Full time - 37.5 hours per week
- £45,780 - £51,393 per annum inclusive of HCAS
- Salary period
- (Band 7)
- Main area
- Senior Business Intelligence Analyst
- Interview date
London Ambulance Service covers an area of 620 sq. miles, serves one of the world’s most dynamic and diverse cities and is the busiest ambulance service in the UK. We handle over 1.9 million emergency calls from across the capital and attend more than 1.2 million incidents every single year as well as delivering a 24 hour NHS 111 Integrated Urgent Care Service in South East and North East London that we estimate will respond to around 1.4million urgent care calls by the end of the year.
We employ over 8,000 people who work or volunteer across London to respond to the health needs of over eight million people who live, work and travel in the capital. We work closely with our NHS partners and are commissioned by 32 clinical commissioning groups spread across 5 sustainability and transformation partnerships (STPs) and NHS England for our specialist services. We work alongside London’s hospital, mental health and specialist trusts, as well as the five STPs across Greater London.
In addition we work in partnership with the other emergency services, London’s Air Ambulance and London’s Resilience Forums to make sure we are ready and prepared to respond to major incidents and ensure we keep Londoners safe. As the only pan-London NHS provider we have a unique opportunity to play a leading role in integrating access to emergency and urgent care right across London.
By 2023 we will improve outcomes and experiences for all our patients by providing the right care to patients at the right time, and in the most cost effective way. This will mean up to 122,000 fewer patients being taken to emergency departments when their needs could be better met in a different way, and we will deliver significant efficiencies in avoided costs to the urgent and emergency care sector.
LAS Senior Business Intelligence Analysts are instrumental in providing and communicating statistical information about the Trust, including activity and performance data, generating insight, and developing interactive visualisation tools, driving forward our ambition of making the LAS a world-class service. Working on a variety of diverse projects across the organisation, the role will include many aspects of business intelligence, from supporting Operational and Corporate services, providing evidence for business and strategic decision making, to Corporate Reporting delivery, allowing the production and distribution of the Chief Finance Officer’s Integrated Performance Report and Chief Executive Officer’s performance packs for all management levels, external stakeholders and Trust Board. Recommendations derived from your work will shape the delivery of an evolving service in a challenging healthcare environment.
An exciting opportunity has arisen for a twelve month secondment as a Senior Business Intelligence Analyst within the Corporate Reporting team. This is an exciting and challenging role for an individual who enjoys working in a fast paced, demanding and evolving healthcare environment. You will join a technically minded team as part of a high profile and influential organisation. This is a great opportunity for someone interested in using their analytical and technical skillset to tackle Trust challenges helping to drive transformational change. The role will also involve communication with colleagues from across the strategic, operational and executive teams, and so confidence in presenting sensitive and complex findings to non-technical audiences is essential. The ideal candidate will have knowledge of areas such as:
- Microsoft Office
- Coding (SQL)
- Advanced analytics & data visualisation/reporting
- Supervised and unsupervised learning
- Effective communication and presentation
Working for our organisation
London Ambulance Service NHS Trust is the busiest ambulance Trust in the UK. We are seeking someone who will fit with the Trust values of being respectful, professional, innovative and collaborative. The team is well established in the organisation and central to strategic and operational planning. We are part of the wider Performance and Analytics directorate who together cover corporate reporting, data quality, business intelligence, and forecasting and planning for urgent and emergency healthcare services. The directorate is key to ensuring that LAS is a data driven organisation, with decisions being informed by timely and high quality analysis.
Annual leave starts at 27 days rising to 33 days, plus bank holidays, in line with Agenda for Change. Employees can access Blue Light (emergency services) discounts as well as NHS discount schemes.
Detailed job description and main responsibilities
Extract and manipulate complex and extremely varied data from different databases, for all levels of management
Provide support for managers and other users in the interpretation and analysis of complex information, particularly where data is controversial or where different components of that data may conflict
To influence data collection procedures outside the department which affect information provision, including the design of operational forms within the service
Develop existing and new databases (using SQL Server or MS Access) and complex spreadsheets (using Excel) to improve information gathering and analysis
Produce statistical information packs for all management levels including the Executive Board and external organisations, collating and analysing complex information from a number of different areas of the service, including highlighting trends and comparing data on demand, performance, vehicle and control room staffing and vehicle utilisation
Analyse and manipulate data from a variety of internal sources (including activity, manning, staffing and call taking data) whilst supplementing this with information from a variety of external sources (including Census data, weather data etc) to aid in the interpretation of patterns in activity, performance and geographic trends
Present, interpret and explain complicated statistical information to large groups at meetings, to influence operational decisions
Applicants are advised to read all the information enclosed in the advert and the supporting information before completing and submitting an application. As you complete your application please ensure you clearly demonstrate how you meet the criteria in the person specification for this post by adequately completing the supporting information section of the application form.
Priority will be given to staff at risk candidates.
We reserve the right to close the application window early if we receive a high volume of suitable applications.
London Ambulance Service NHS Trust is a member of the Business Disability Forum and is a Disability Confident Employer.
For more information on our equalities strategy, please visit our website and review our current equalities strategy.
In addition to the basic salary for all Agenda for Change posts, London Ambulance Service NHS Trust in line with the NHS Agenda for Change provides 15% or 20% High Cost Area Supplement (HCAS) dependant on the location of your role. The supplement is subject to minimum and maximum payment.
High Cost Area Supplement (HCAS) for part time employee will be based on the part time salary.
Correspondence regarding an application will be done via email to all job applicants. Please ensure you provide current e-mail address on the job application form and please check your email inbox regularly.
If you are successful at interview and offered employment, your personal details will also be transferred into the national NHS Electronic Staff Records system.
Pre-employment checks will be required for all applicants who are issued with a conditional offer of employment. This includes Disclosure and Barring Services (DBS) checks as required for the post and registration with the DBS update service. Documents presented for the purpose of Identity Checks will be verified for authenticity via an ID Scanner. The security features to be checked include machine readable zone, ultra violet image and infra-red image.
The London Ambulance Service NHS Trust reserves the right to close adverts before the published closing date due to high volumes of applications received.
If you do not hear back from us within four weeks of the advert closing date, please assume that you have not been successful at the shortlisting stage.
Applications from job seekers who require sponsorship to work in the United Kingdom (UK) are welcome and will be considered alongside all other applications. Please note that from January 2021, to work in the UK all candidates who are not UK or Republic of Ireland (RoI) nationals require sponsorship unless you have permission to work via another route. Non UK / RoI candidates wishing to apply can self-assess the likelihood of obtaining a Certificate of Sponsorship here. It is vital that you provide full and accurate details of your current immigration status on the application form. Overseas applicants applying for entry clearance into the UK must present a criminal record certificate from each country they have resided in continuously or cumulatively for 12 months or more in the past 10 years. Guidance can be found here. Not everyone needs a ‘Skilled Worker’ visa. If you are applying for a vacancy in health or adult social care, check if you’re eligible to apply for the Health and Care Worker visa instead. It’s cheaper to apply for and you do not need to pay the annual immigration health surcharge
Qualifications, Accreditations, Education
- Graduate level of education or equivalent experience and expertise of providing business intelligence in a work environment
- GCSE mathematics or equivalent
- Extensive experience of producing, analysing and interpreting business intelligence 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)
- Extensive experience of developing applications in Excel (using formulae, functions, complex calculations and other statistical techniques, plus the use of Visual Basic for Applications to automate spreadsheets)
- General knowledge of computer hardware and software and constant updating of that knowledge
- Experience of supervising staff
Knowledge and Skills
- Ability to analyse complex and sometimes conflicting data sets, with a logical approach
- Ability to develop, maintain and adapt databases and spreadsheets for personal use as well as the use of others in a changing environment
- Ability to tailor business intelligence 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 use different influencing skills appropriate to the outcomes of findings, especially when findings do not support initial assumptions or expectations
- Diplomatic and tactful
- 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
- 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
- Adhere to the Trust values and behaviours
- Commitment to and understanding of Equal Opportunities and Diversity both as an employee and a provider of services to the public
- Evidence of reliability
- Positive attitude towards learning and development demonstrated by a record of continuing professional development
- No current or pending disciplinary sanctions
Further details / informal visits contact
- Rommel Casaclang
- Job title
- Business Manager
- Email address