Job summary
We are looking for an enthusiastic and dynamic Power BI developer with project management and data science skills to undertake exciting analytical projects and challenges. You will have a passion for presenting data and designing dashboards to inspire decision making! This will entail database development, data extraction and data manipulation using SQL and DAX. This role will also take a lead on user experience design and strategy ensuring our dashboards are designed to high standards and intuitive and exciting to use.
Main duties of the job
This is an exciting role joining the Royal Statistical Society Florence Nightingale award winning team (2022)! The primary purpose of the analytics team is to develop an innovative integrated reporting system from clinical and non-clinical data sources to enhance day to day evidence based decision making to improve patient care.
We support our analytics team with a strategic training strategy and we are looking for a candidate that is looking to continuously improve, develop and learn new technologies and approachesin this exciting and ever developing environment.
About us
Our mission is to make a positive difference to people's lives by improving the quality of life for all we serve. Our values are: We Care, We Respect, We are Inclusive - so we are looking for people who live and breathe these qualities when supporting service users and carers, and in their relationships with colleagues in the Trust and our partner organisations
Job description
Job responsibilities
For further information of the job, please see the attached job description and personal specification.
Job description
Job responsibilities
For further information of the job, please see the attached job description and personal specification.
Person Specification
Education/ Qualification/ Training
Essential
- Education to degree level, ideally in Computer Science or Health Informatics or highly numerate and/or computing discipline
Desirable
- Certificates in Microsoft BI Stack
- SQL Reporting Services
Experience
Essential
- Extensive 'Hands on' knowledge of large and complex datasets
- Experience of handling, analysing and manipulating large, complex datasets.
- Transact SQL experience
- Project management delivering large scale analytical products
- Experience of building data models within Power BI
- Experience of using Power BI for visual analytics
- Experience of working with complex stored procedures
- Knowledge and experience of SQL Server Reporting Services (SSRS)
- Experience of, or demonstrable ability to acquire, the skills of statistical analysis and interpretation of raw data
- Experience in using statistical software application.
- Extremely numerate and able to analyse and interpret data and information accurately and effectively
- Experience in developing visual analytics to present complex datasets in a simple, meaningful way i.e. Infographics, Animations etc.
- Experience of working in a challenging and continuously changing environment.
Desirable
- Experience of working with NHS datasets, and knowledge of the NHS data dictionary definitions
- Database management skills.
- Troubleshooting technical and performance problems with SQL Server
Knowledge and Skills
Essential
- Practical experience of using Power BI/SSRS
- DAX/M script development
- Knowledge of a range of work procedures and software programmes relevant to the pos
- Excellent knowledge of SQL Server
- Advanced level knowledge of SSMS to develop complex scripts and stored procedures.
- Substantial programming skills in database design and programming using MS Office products
- Excellent verbal and written communication skills, producing reports/documentation to a professional standard with an ability to communicate complex issues in a simplified way.
- Proven ability to design and manage programmes of work, including the ability to act on own initiative in these areas and meet tight deadlines
Desirable
- Knowledge of UK healthcare service provision
- Understanding of the workings of a Mental Health / Community Health provider organisation
- Sound knowledge and skills in the use of relevant statistical/mathematica l modelling packages and knowledge in statistical process control and its application in understanding variation
- Expert knowledge and skills in the practical applications of all MS Office products
- Knowledge of Microsoft Azure Cloud technology
Person Specification
Education/ Qualification/ Training
Essential
- Education to degree level, ideally in Computer Science or Health Informatics or highly numerate and/or computing discipline
Desirable
- Certificates in Microsoft BI Stack
- SQL Reporting Services
Experience
Essential
- Extensive 'Hands on' knowledge of large and complex datasets
- Experience of handling, analysing and manipulating large, complex datasets.
- Transact SQL experience
- Project management delivering large scale analytical products
- Experience of building data models within Power BI
- Experience of using Power BI for visual analytics
- Experience of working with complex stored procedures
- Knowledge and experience of SQL Server Reporting Services (SSRS)
- Experience of, or demonstrable ability to acquire, the skills of statistical analysis and interpretation of raw data
- Experience in using statistical software application.
- Extremely numerate and able to analyse and interpret data and information accurately and effectively
- Experience in developing visual analytics to present complex datasets in a simple, meaningful way i.e. Infographics, Animations etc.
- Experience of working in a challenging and continuously changing environment.
Desirable
- Experience of working with NHS datasets, and knowledge of the NHS data dictionary definitions
- Database management skills.
- Troubleshooting technical and performance problems with SQL Server
Knowledge and Skills
Essential
- Practical experience of using Power BI/SSRS
- DAX/M script development
- Knowledge of a range of work procedures and software programmes relevant to the pos
- Excellent knowledge of SQL Server
- Advanced level knowledge of SSMS to develop complex scripts and stored procedures.
- Substantial programming skills in database design and programming using MS Office products
- Excellent verbal and written communication skills, producing reports/documentation to a professional standard with an ability to communicate complex issues in a simplified way.
- Proven ability to design and manage programmes of work, including the ability to act on own initiative in these areas and meet tight deadlines
Desirable
- Knowledge of UK healthcare service provision
- Understanding of the workings of a Mental Health / Community Health provider organisation
- Sound knowledge and skills in the use of relevant statistical/mathematica l modelling packages and knowledge in statistical process control and its application in understanding variation
- Expert knowledge and skills in the practical applications of all MS Office products
- Knowledge of Microsoft Azure Cloud technology
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.
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).
Additional information
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.
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).
