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 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 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. 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 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, 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 interpersonal skills are 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.
Job responsibilities
1. Provide full admin for the Analytics Platform including resolving any issues with reports, setting up new workspaces, user access, and data gateways.
2. 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).
3. 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).
4. 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.
5. 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.
6. Provide analysis and interpretation on complex, sensitive, and contentious data or datasets taken from multiple sources and organisations.
7. 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.
8. Develop the BI Governance approach and work to review these processes to ensure they are carried out effectively.
9. Work with Stakeholders to agree and refine specifications to achieve the best outcome using an Agile process.
10. Ability to set up a 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 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.
* Relevant degree or equivalent experience.
* 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.
Desirable
* Understanding of the NHS and/or Ambulance Services.
* Advanced knowledge of Office 365 Programs (such as Power Automate, Power Apps, Forms).
Employer details
Employer name
Yorkshire Ambulance Service NHS Trust
Address
Yorkshire Ambulance Service, Trust Headquarters
Brindley Way
Wakefield
WF2 0XQ
Any attachments will be accessible after you click to apply.
#J-18808-Ljbffr