individual to support the Non-Emergency Patient Transport Service in undertaking analysis and performance reporting to support service improvement. Key skills include SQL, PowerBI, Statistical Analysis and being able to present information in an easy to understand format - making recommendations as appropriate. The post will … cost-effective and responsive NEPTS services across the Trust. The post holder will also be responsible for NEPTS SharePoint reporting, SQL extraction and powerBI report creation. This post is a fixed term position until the end of March 2025. Main duties of the job To … required. To develop appropriate reporting solutions, undertake analysis and evaluation to support specific initiatives/projects implemented (including the creation and analysis of PowerBI reports). Extract, manage and analyse complex datasets using spreadsheets, databases, and other software tools. To provide information and analytical support more »
experience of linear regression Working knowledge and experience of SQL Server SSIS Working knowledge of analytic functions in SQL Working knowledge of integrating PowerBI reports with multiple data sources Working knowledge and experience of SPC charts, technical data models, writing DAX queries, creating calculations and … measures, bespoke functions and integrating multiple data sources in PowerBI Working knowledge and understanding of NHS policy and its relevance to commissioning and contracting Desirable Knowledge of Freedom of Information Legislation, Data Protection Act etc Knowledge of the Information Governance agenda Highly developed specialist knowledge … developing effective working relationships Good eye for detail Ability to present highly complex information to non-technical audiences Experienced of developing reports in PowerBI Working knowledge and experience of query optimisation Substantial experience of writing SQL queries for reporting- complex correlated queries, subqueries Substantial experience more »
Waltham on the Wolds, Leicestershire, United Kingdom
Randstad Sourceright
complex scientific messages to a variety of audiences. High drive for results and an ability to work with limited support. Experience working with PowerBI or Tableau would be an advantage, but not essential Experience in data preparation tools such as Alteryx would also be beneficial more »