Main area: Administration
Grade: Band 6
Contract: Fixed term: 10 months
Hours: Full time - 37.5 hours per week
Job ref: 174-BIAS-021124
Employer: Yorkshire Ambulance Service NHS Trust
Employer type: NHS
Site: Yorkshire Ambulance Service, Trust Headquarters
Town: Wakefield
Salary: £37,338 - £44,962 Per annum, pro rata
Salary period: Yearly
Closing: 10/11/2024 23:59
Business Intelligence Analytics Specialist
Band 6
Job overview
The BI Analytics Specialist role forms part of a busy BI team responsible for supporting the design, implementation, and review of the BI Information System (Analytics platform). You will be skilled in using statistical methods and techniques. The role also includes high-level analytical support for senior analysts to deliver cutting-edge intelligence and insight using complex, sensitive, and contentious information across the Ambulance Sector locally and regionally. Significant experience within a BI team would be an advantage.
The role will be responsible for leading projects to develop analytics solutions that provide the Trust with informative self-serve reports and insights that aid decision-making. Experience of SQL, RPA, Microsoft PowerBI, R/Python, and the wider Microsoft Power Platform (Automate, Apps) would also be advantageous. Must have relevant up-to-date work experience.
Main duties of the job
To be responsible for supporting and developing the BI Information System (Analytics System) which covers the whole organisation. This includes the data flow from various other information systems into the data warehouse and out into the reporting Analytics system. This includes data governance and providing a lead role with all aspects of the system.
Develop key relationships with Senior Management, the Board, and key partners such as Commissioners, other Trusts, NHS England, and NHS Digital. This includes providing and receiving highly complex, sensitive, or contentious information where there are significant barriers to acceptance which need to be overcome using a high level of interpersonal and communication skills.
Strong interpersonal skills required with the ability to explain and present reports to a wide-ranging non-technical audience.
Train end users on the technical abilities of Power BI and Office 365 applications across the trust and within the BI Team.
Working for our organisation
Yorkshire Ambulance Service (YAS) NHS Trust geographically covers nearly 6,000 square miles of varied terrain, from isolated moors and dales to urban areas, coastline, and inner cities. We serve a population of over five million people across Yorkshire and the Humber and strive to ensure that patients receive the right response to their care needs as quickly as possible, wherever they live.
We employ more than 7,100 staff, who together with over 1,300 volunteers, enable us to provide a vital 24-hour, seven-days-a-week, emergency and healthcare service.
Our ambition is to be an employer of choice, and we are continuously working across our partnership to improve our collective offer to staff in areas like health and wellbeing, benefits, and flexible working including hybrid working.
Benefits
* Flexible working including part-time hours, job shares, and flexible hours, agile working (role dependent).
* 27 days annual leave, increasing to 33 with service.
* Contributory Pension.
* NHS Discounts including shops, restaurants, gyms, etc.
* Car lease and other salary sacrifice schemes.
* Dedicated employee assistance and counselling service.
* Opportunities for research participation, career progression, and ongoing development.
* Well-respected, committed, and supported staff networks for our workforce.
Detailed job description and main responsibilities
Provide full admin for the Analytics Platform including resolving any issues with reports, setting up new workspaces, user access, and data gateways.
Lead on the innovation of the Trust BI Information (Analytics platform) utilising cutting-edge technology such as SQL and other reporting tools (such as Power BI, Python, R, Power Automate, Power Apps, and AI).
Responsible for planning the development of the data analytics platform including utilising all the latest technology within Power BI and other Office 365 applications (such as Data Flow/Power Apps).
Design ways for data to flow from the end user through our data warehouse or SharePoint and into reports utilising key technology such as Power Automate and Data flow.
Interrogate relational databases and the Data Warehouse to produce reports and analysis by understanding the underlying data and making recommendations to the senior members of the BI team. In particular, work with Senior Analysts to refine the aggregate datasets suitable for the BI Analytics Platform and setting up stored procedures/views to interrogate the data.
Provide analysis and interpretation on complex, sensitive, and contentious data or datasets taken from multiple sources and organisations.
To fully understand all relevant data (Local, Regional, and National) and benchmarking that is available to the BI Team and use innovative ways to incorporate that into reporting/analysis.
Detailed understanding of all the underlying service lines and the datasets used to support that service.
Develop the BI Governance approach and work to review these processes are carried out effectively.
Working with stakeholders to agree and refine specifications to achieve the best outcome using an Agile process.
Ability to set up a technical working group with other similar trusts to develop the Analytics platform.
Person specification
Skills and Experience
* Advanced experience and knowledge of using SQL and other database tools with the ability to query datasets with the use of Select, Joins, Grouping, Sub Queries. Creation of Stored Procedures, views, and functions.
* Advanced knowledge of the reporting information system Microsoft PowerBI including DAX, dataset transformation, filtering, connections, and other advanced features.
* Ability to overcome barriers associated with conveying analytical/technical information to a non-technical audience.
* Knowledge or experience of working in a business intelligence, management information, or similar team for at least 2 years.
* Be able to interpret results from the use of complex and sensitive data. By the use of statistical methods to apply the results to the given problem, suggest conclusions to be drawn and offer recommendations where appropriate.
* Presenting advanced technical and complex analytical information to an audience in a clear and concise manner with the ability to pick out key themes and trends.
* Understanding of the NHS and or Ambulance Services.
* Advanced knowledge of Office 365 Programs (such as Power Automate, Power Apps, Forms).
Yorkshire Ambulance Service NHS Trust is committed to having a diverse and inclusive workforce which reflects the communities and patients we serve across the Yorkshire region. Our ambition is to work together to promote a more inclusive environment, which attracts candidates from all sections of the community and signals our commitment to embracing diversity and promoting inclusivity.
As an inclusive organisation, we welcome applicants irrespective of people’s age, disability, sex, gender identity and gender expression, race or ethnicity, religion or belief, sexual orientation, or other personal circumstances. We particularly encourage applications from people who are underrepresented within our sector, including people with lived experience from Black, Asian and minority ethnic backgrounds, people from the LGBT+ community, people with caring responsibilities, and people with disabilities. We have policies and procedures in place to ensure that all applicants are treated fairly and consistently at every stage of the recruitment process, including an invitation to the first stage of the selection process for applicants who meet the essential criteria for the job vacancy and consideration of reasonable adjustments for people who have a disability under the “Disability Confident Scheme”.
Please note the salary range stated in advertisements is calculated on a pro-rata basis if the vacancy is part-time.
Disclosure and Barring Service
Yorkshire Ambulance Service NHS Trust is committed to safeguarding & promoting the welfare of children & vulnerable adults. Many of our posts are subject to a Disclosure & Barring Service check (DBS). Should this position be subject to a DBS check the cost will be recovered from your salary as a one-off payment. Currently, the charges made by the Disclosure and Barring Service (incl. application fee) are £41.90 for an enhanced check and £21.90 for a standard check.
Any correspondence regarding an application will be sent electronically via the Trac Jobs Website to the email address that was provided at the time of the application. It is important, therefore, that you read your emails on a regular basis and respond as necessary.
The Yorkshire Ambulance Service Trust reserves the right to close adverts before the published closing date due to high volumes of applications received.
Please note, the selection processes at Yorkshire Ambulance Service are in place to ensure we recruit candidates with the right skills and values. Please be advised that the use of Artificial Intelligence (AI) in applications is monitored. We remain vigilant against candidates who misuse these tools to generate an application that doesn’t accurately reflect their skills, and you will be required to declare on your application if AI has been used before submitting your application.
Our values underpin everything we do and how we do it: Kindness, Respect, Teamwork, Improvement.
Employer certification / accreditation badges
Name: Ryan Higgins
Job title: Deputy Head of Business Intelligence
Email address: ryan.higgins1@nhs.net
Telephone number: 03306784015
If you have problems applying, contact
Address: Yorkshire Ambulance Service Headquarters
Brindley Way
Wakefield
West Yorkshire
WF2 0XQ
Telephone: 07425 213930 or 0330 678 4015
#J-18808-Ljbffr