Job summary
Are you highly skilled in Business Intelligence and looking for an opportunity to work hands-on with large and complex data sets? Are you passionate about data accuracy, analytics, visualisation and have experience with Business Intelligence tools? Are you looking for a role that will make a difference? If so, the NHS Business Services Authority (NHSBSA) have a great opportunity for you.
We are looking for a Business Intelligence Developer to join our team; someone who understands the best way to present data to our large and growing user base, working with high-volume, complex, health-related data sets in an exciting and challenging environment, using the latest cloud technologies. You will be part of the NHSBSA Data Platforms team, handling the design, development, testing, and production of dashboards and reports using Oracle and Microsoft technologies.
If you are highly accurate, enjoy working with complex data, and are experienced in using information to produce solutions, this is the perfect opportunity to see how the NHS can help you take the next step in your career!
What do we offer?
- 27 days leave (increasing with length of service) plus 8 bank holidays.
- Flexible working (we are happy to discuss options such as compressed hours)
- Flexi time
- Hybrid working model (we are currently working largely remotely)
- Career development
- Active wellbeing and inclusion networks
- Excellent pension
- NHS Car lease scheme
- Access to a wide range of benefits and high street discounts!
Main duties of the job
In this role you will be expected to develop and provide efficient, timely and accurate information, documented analysis, reports and dashboards to internal and external stakeholders based upon their requirements.
Below are some examples of the type of work that this role covers:
- Develops reports, dashboards and visualisations (e.g. clinical and non-clinical dashboards) to meet the Authority's needs and provide actionable insight.
- Ability to handle large datasets with a clear understanding of how to clean, process, analyse, and visualise data to provide the most value and insight.
- Provide analysis using appropriate query tools for performance reporting, contract monitoring, forecasting, target monitoring and audit purposes.
- Ability to use business intelligence tools and basic SQL queries to interrogate, analyse and present data in an effective and informative manner in the most efficient way possible.
- Automate processes to avoid time consuming data entry or unnecessarily manipulation and allow a focus on analysis and providing useful insight and interpretation of the data.
- Decide on the best methodology to analyse, investigate and resolve complex analytical queries or problems.
- Resolve highly complex information problems where there is no precedent or where leading opinions may conflict. Support development and refinement of metrics and reports to highlight trends, identify outlier behaviours within the data sets and risks within NHS services.
About us
Here at the NHS Business Services Authority (NHSBSA), what we do matters.
We manage the NHS Pension scheme, process prescription payments and much more. Our services are used by NHS organisations, contractors and the public: we take pride in being part of something so meaningful, that touches millions of lives.
Just as we design our services around the needs of our customers, we place our people at the heart of our organisation. That's why when you join us, you'll be empowered and given the right support to help your career grow.
As one of the UK's Best Big Companies to work for, we're all connected to our values: Collaborative, Adventurous, Reliable and Energetic. We care about our people, our purpose, and your progress.
We strive to offer a fantastic colleague experience, where every voice is heard, and every colleague is supported and respected. Wellbeing, diversity and inclusion is at the centre of this, so when you join us, you can connect with our Lived Experience Networks who help us to bring our authentic selves to work.
We welcome applications from people of all backgrounds and circumstances. We are committed and proud to be a flexible employer and will endeavour to offer a working pattern that suits you wherever possible, whether that be hybrid working, flexible hours, job sharing and more.
Ready to join us on our journey to be a catalyst for better health? Apply today and see where the NHSBSA can take you.
We are people connected to care.
Job description
Job responsibilities
In this role, you are accountable for:1. Develops reports and dashboards (e.g. clinical dashboards) to meet the Authoritys needs and provide actionable intelligence. Provides anexpert resource in both the technical skills required to create reports and also the design of dashboards to communicate information andinsight effectively.2. Build fully documented analysis, reports and dashboards for use by external customers to required specifications. Ensure that accompanyingnotes and definitions are regularly reviewed and updated where appropriate.3. Ability to handle large datasets with a clear understanding of how to clean, process, analyse, and visualise data to provide the most valueand insight. Applies statistical techniques where appropriate. Conduct advanced analysis, interpretation and presentation of highly complexdata and information to support informed decision making within the wider NHS.4. Provide expert analysis by the use of appropriate query tools for performance reporting, contract monitoring, forecasting, target monitoring and audit purposes.5. Ability to use business intelligence tools, SQL queries and data mining techniques to interrogate, analyse and present data in an effectiveand informative manner in the most efficient way possible.6. Supports the development of the data warehouse to meet new and changing requirements. Liaises with the data warehouse team to ensurestructures to support reporting needs e.g. a new service, are available.7. Coordinates workload to support team members and contributes to team projects. Takes part in wider team development activities e.g. teammeetings, sharing knowledge/skills, training and mentoring other team members.8. Communicates complex data and analyses effectively at all levels to both technical and non-technical audiences verbally and in writing.Comfortable presenting discussing information to an audience.9. Resolve highly complex information problems where there is no precedent or where leading opinions may conflict. Support development and refinement of metrics and reports to highlight trends, identify outlier behaviours within the data sets and risks within NHS services.10. Decide on the best methodology to analyse, investigate and resolve complex analytical queries or problems where there is a range ofsolutions or analyses.11. Ensure the information provided is accessible and understandable to a wide audience, and that it conforms to expected high standards ofaccuracy, quality improvement and presentation.12. Automate processes as much as possible to avoid time consuming data entry or unnecessarily manipulation and allow a focus on analysisand providing useful insight and interpretation of the data.13. Produce fully documented information and analyses to satisfy ad-hoc requests in a timely manner. Provide information to answerParliamentary Questions and Freedom of Information requests.14. Plan and organise own workload and manage activities or projects requiring formulation or adjustment whilst ensuring compatibility with the wider workload of the team.15. Shares problems, solutions knowledge and best practice to maximise benefits and improve services within the team, peer group and withcustomers and stakeholders.16. Participate in organisation wide and NHS projects and working groups where appropriate, fulfilling a lead role based on experience.17. Propose policy or service changes to improve the products and services of the department or to improve internal processes.18. Provide training to internal staff and customers on the use of data, data systems and the interpretation of information reports. Ensurecolleagues are updated on developments
In addition to the above accountabilities, as post holder you are expected to:
Undertake additional duties and responsibilities in line with the overall purpose of your role and as agreed by your line manager.Demonstrate NHSBSA values and core capabilities in all aspects of your work.Foster an environment where your own and colleagues safety and well-being is promoted.Contribute to a culture which values diversity and inclusion.Comply with NHSBSA policies, procedures and protocols as they apply to your role.
Working relationships
Responsible to: Information Services ManagerResponsible for: Providing direction to colleagues relating to specialist knowledge
Key relationships and connections: Information Services colleagues. Internal and External customers and clients
Job description
Job responsibilities
In this role, you are accountable for:1. Develops reports and dashboards (e.g. clinical dashboards) to meet the Authoritys needs and provide actionable intelligence. Provides anexpert resource in both the technical skills required to create reports and also the design of dashboards to communicate information andinsight effectively.2. Build fully documented analysis, reports and dashboards for use by external customers to required specifications. Ensure that accompanyingnotes and definitions are regularly reviewed and updated where appropriate.3. Ability to handle large datasets with a clear understanding of how to clean, process, analyse, and visualise data to provide the most valueand insight. Applies statistical techniques where appropriate. Conduct advanced analysis, interpretation and presentation of highly complexdata and information to support informed decision making within the wider NHS.4. Provide expert analysis by the use of appropriate query tools for performance reporting, contract monitoring, forecasting, target monitoring and audit purposes.5. Ability to use business intelligence tools, SQL queries and data mining techniques to interrogate, analyse and present data in an effectiveand informative manner in the most efficient way possible.6. Supports the development of the data warehouse to meet new and changing requirements. Liaises with the data warehouse team to ensurestructures to support reporting needs e.g. a new service, are available.7. Coordinates workload to support team members and contributes to team projects. Takes part in wider team development activities e.g. teammeetings, sharing knowledge/skills, training and mentoring other team members.8. Communicates complex data and analyses effectively at all levels to both technical and non-technical audiences verbally and in writing.Comfortable presenting discussing information to an audience.9. Resolve highly complex information problems where there is no precedent or where leading opinions may conflict. Support development and refinement of metrics and reports to highlight trends, identify outlier behaviours within the data sets and risks within NHS services.10. Decide on the best methodology to analyse, investigate and resolve complex analytical queries or problems where there is a range ofsolutions or analyses.11. Ensure the information provided is accessible and understandable to a wide audience, and that it conforms to expected high standards ofaccuracy, quality improvement and presentation.12. Automate processes as much as possible to avoid time consuming data entry or unnecessarily manipulation and allow a focus on analysisand providing useful insight and interpretation of the data.13. Produce fully documented information and analyses to satisfy ad-hoc requests in a timely manner. Provide information to answerParliamentary Questions and Freedom of Information requests.14. Plan and organise own workload and manage activities or projects requiring formulation or adjustment whilst ensuring compatibility with the wider workload of the team.15. Shares problems, solutions knowledge and best practice to maximise benefits and improve services within the team, peer group and withcustomers and stakeholders.16. Participate in organisation wide and NHS projects and working groups where appropriate, fulfilling a lead role based on experience.17. Propose policy or service changes to improve the products and services of the department or to improve internal processes.18. Provide training to internal staff and customers on the use of data, data systems and the interpretation of information reports. Ensurecolleagues are updated on developments
In addition to the above accountabilities, as post holder you are expected to:
Undertake additional duties and responsibilities in line with the overall purpose of your role and as agreed by your line manager.Demonstrate NHSBSA values and core capabilities in all aspects of your work.Foster an environment where your own and colleagues safety and well-being is promoted.Contribute to a culture which values diversity and inclusion.Comply with NHSBSA policies, procedures and protocols as they apply to your role.
Working relationships
Responsible to: Information Services ManagerResponsible for: Providing direction to colleagues relating to specialist knowledge
Key relationships and connections: Information Services colleagues. Internal and External customers and clients
Person Specification
Personal Qualities, Knowledge and Skills
Essential
- Able to critically appraise and interpret highly complex data and advise on actions based on the comparison of a range of options.
- Skilled In the translation of business needs and issues into logical, analytical frameworks that outline and support reporting requirements.
- Able to use database, statistical, word processing, spreadsheet and presentational IT packages to produce complex and, at times, highly sensitive reports
- Understanding of the principles of effective report design and able to check own work in an objective manner.
- Ability to contribute confidently in meetings and workshops.
- Able to formulate plans which cover a range of complex activities including target setting and prioritisation of activities with an analytical and logical approach to problem solving
- Able to concentrate intensively, using significant discretion in decision-making activities.
- Confident at data analysis and presenting information as an subject matter expert to internal and external stakeholders.
- Able to present information clearly and communicate technical concepts to a varied audience.
- Proactive and personally motivated, able to use own initiative and self-manage where appropriate. Takes ownership of their workload.
- Strong interpersonal team working skills.
- Resilient and self-aware with a flexible and adaptable approach to work.
- Ability to work with changing and sometimes conflicting priorities with limited supervision with the ability to prioritise accordingly.
- Enjoys working within a busy and challenging environment
- Able to absorb technical information quickly and put it to use within the workplace.
Desirable
- Previous work experience within the NHS
- An excellent knowledge of the principles of data warehousing
- Knowledge and experience of data architecture in an health care environment.
Experience
Essential
- In depth specialist knowledge of information analysis and the use of information acquired through degree or equivalent.
- Experience of using OAC and SQL developer tools in a workplace environment.
- Practical applied experience of using BI tools with large data sets to achieve significant results.
- Experience of working within a business-reporting environment.
- Experience of developing dashboards, reporting or analyses based upon customer requirements.
Desirable
- Experience with statistical programming software such as R & R Studio.
- Experience of using Oracle and SQL Server.
- Data reporting packages and tools.
- Experience of managing projects.
Qualifications
Essential
- Degree in mathematics/statistics/finance or subject requiring high levels of numeracy
- Equivalent qualification or experience.
- Evidence of recent personal development
Desirable
- IT related degree or equivalent.
Person Specification
Personal Qualities, Knowledge and Skills
Essential
- Able to critically appraise and interpret highly complex data and advise on actions based on the comparison of a range of options.
- Skilled In the translation of business needs and issues into logical, analytical frameworks that outline and support reporting requirements.
- Able to use database, statistical, word processing, spreadsheet and presentational IT packages to produce complex and, at times, highly sensitive reports
- Understanding of the principles of effective report design and able to check own work in an objective manner.
- Ability to contribute confidently in meetings and workshops.
- Able to formulate plans which cover a range of complex activities including target setting and prioritisation of activities with an analytical and logical approach to problem solving
- Able to concentrate intensively, using significant discretion in decision-making activities.
- Confident at data analysis and presenting information as an subject matter expert to internal and external stakeholders.
- Able to present information clearly and communicate technical concepts to a varied audience.
- Proactive and personally motivated, able to use own initiative and self-manage where appropriate. Takes ownership of their workload.
- Strong interpersonal team working skills.
- Resilient and self-aware with a flexible and adaptable approach to work.
- Ability to work with changing and sometimes conflicting priorities with limited supervision with the ability to prioritise accordingly.
- Enjoys working within a busy and challenging environment
- Able to absorb technical information quickly and put it to use within the workplace.
Desirable
- Previous work experience within the NHS
- An excellent knowledge of the principles of data warehousing
- Knowledge and experience of data architecture in an health care environment.
Experience
Essential
- In depth specialist knowledge of information analysis and the use of information acquired through degree or equivalent.
- Experience of using OAC and SQL developer tools in a workplace environment.
- Practical applied experience of using BI tools with large data sets to achieve significant results.
- Experience of working within a business-reporting environment.
- Experience of developing dashboards, reporting or analyses based upon customer requirements.
Desirable
- Experience with statistical programming software such as R & R Studio.
- Experience of using Oracle and SQL Server.
- Data reporting packages and tools.
- Experience of managing projects.
Qualifications
Essential
- Degree in mathematics/statistics/finance or subject requiring high levels of numeracy
- Equivalent qualification or experience.
- Evidence of recent personal development
Desirable
- IT related degree or equivalent.
Additional information
Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).
From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).
