Job summary The BI Analytics Specialist role forms part of a busy BI team responsible for supporting the team with 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 the senior analysts to deliver cutting edge intelligence and insight using complex, sensitive, and contentious information across the Ambulance Sector locally and regionally. Therefore, significant experience within a BI team would be an advantage. The role will be responsible for leading on projects to develop analytics solutions that provide the Trust with informative self-serve reports and insight that aid decision making. Experience of SQL, RPA, Microsoft PowerBI, R/Python and the wider Microsoft Power Platform (Automate, Apps) would also be of an advantage. Experience of working with large data from complex systems is advantageous.Must have relevant up to date work experience. Main duties of the job To be responsible for supporting and development of 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, highly sensitive or highly contentious information where there are significant barriers to acceptance which need to be overcome using a high level of interpersonal and communication skills. Strong inter-personal 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. About us 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 incl. hybrid working.Benefits:o Flexible working including part-time hours, job shares and flexible hours, agile working (role dependant)o 27 days annual leave, increasing to 33 with service.o Contributory Pension.o NHS Discounts including shops, restaurants, gyms etc.o Car lease and other salary sacrifice schemes.o Dedicated employee assistance and counselling service.o Opportunities for research participation, career progression and ongoing development.o Well respected, committed and supported staff networks for our workforce. Check out our YAS One Team Simulation https://www.nwyhelearning.nhs.uk/elearning/yorksandhumber/yas/yasoneteam/index.html Date posted 04 November 2024 Pay scheme Agenda for change Band Band 6 Salary £37,338 to £44,962 a year Per annum, pro rata Contract Fixed term Duration 10 months Working pattern Full-time Reference number 174-BIAS-021124 Job locations Yorkshire Ambulance Service, Trust Headquarters Brindley Way Wakefield WF2 0XQ Job description Job 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 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 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 use 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 underlining 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 underlining 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 technical working group with other similar trusts to develop the Analytics platform. Job description Job 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 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 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 use 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 underlining 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 underlining 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 technical working group with other similar trusts to develop the Analytics platform. Person Specification Skills and Experience Essential Advanced Experience and knowledge of using SQL and other database tools with 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. Relevant degree or equivalent experience Presenting advanced technical and complex and analytical information to an audience in a clear and concise manner with the ability to pick out key themes and trends Desirable Understanding of the NHS and or Ambulance Services Advanced knowledge of Office 365 Programs (such as Power Automate, Power Apps, Forms) Person Specification Skills and Experience Essential Advanced Experience and knowledge of using SQL and other database tools with 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. Relevant degree or equivalent experience Presenting advanced technical and complex and analytical information to an audience in a clear and concise manner with the ability to pick out key themes and trends Desirable Understanding of the NHS and or Ambulance Services Advanced knowledge of Office 365 Programs (such as Power Automate, Power Apps, Forms) 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. Employer details Employer name Yorkshire Ambulance Service NHS Trust Address Yorkshire Ambulance Service, Trust Headquarters Brindley Way Wakefield WF2 0XQ Employer's website https://www.yas.nhs.uk/ (Opens in a new tab)