Job summary
This is an exciting opportunity to join a highly regarded Business Intelligence team as we continue to implement our data warehouse and develop Tableau business intelligence visualisations, transforming data into intelligence to support performance management, effective decision making, and service improvement.
Reporting to the Head of Data Engineering , you will communicate effectively with staff at all levels to interpret their needs and build elegant reporting solutions. Highly developed specialist knowledge of Microsoft SQL Server and its associated tools (SSIS, SSRS and SSAS) will be required, and you must be familiar with the Kimball data modelling approach.
The post-holder will play a key role in the development of the Trust data warehouse, building robust ETL processes that pull data from multiple clinical systems into the Trust data warehouse. You will also be skilled in data visualisation, delivering insightful and impactful analytics using Tableau.
At a time when demand for robust information to support business planning and transformation is increasing and the NHS information agenda is rapidly changing, the ability to work as a flexible team member is essential.
The post is offered on a hybrid working pattern, working two days a week in the office as you will be expected to attend face to face meetings and provide support to colleagues working on-site.
Main duties of the job
We are looking for an experienced, dynamic and motivated individual to join our team, someone with the skills and experience to lead the development of the data warehouse for certain subject areas and clinical systems.
You will have excellent communication skills, working with colleagues across clinical and operational teams to understand complex reporting requirements; you will develop and maintain collaborative working relationships with staff across all levels of the Trust and will develop new and innovative reporting solutions.
You will support in all areas of data warehouse management and development including but not limited to: new data feeds, data quality, IG considerations, remedy of issues, permissions management, user support and requests.
About us
We hold a unique position in the Stockport community as the provider of healthcare and we are one of its largest employers.
Our mission is to make a difference every day. Our values are that we care, we respect, and we listen
We believe that the best organisations are those that reflect the communities they serve. We are therefore seeking to improve the diversity of our workforce to make it truly representative of our local population.
We actively encourage applications irrespective of race, age, disability, sex, gender reassignment, gender identity or expression, sexual orientation, religion or belief, marriage & civil partnership, or pregnancy or maternity. Recognising those communities that are underrepresented within our workforce, we would particularly welcome applications from you.
We recognise that flexible working is important. We take requests for flexible working seriously, consider any request we receive and try to work with you, so we can explore if your request may fit with the needs of the service.
The salary for the role is only one part of the excellent package of benefits we offer to you:
- Between 27-33 days of annual leave plus bank holidays
- NHS pension scheme membership
- Salary sacrifice schemes for lease cars, home electronics and more, to make your salary go further
- NHS Staff discounts
- Cycle to work scheme
- Salary finance - for loans, savings, budget planning and tips on managing debt
- Stockport Credit Union- for local financial advice
Job description
Job responsibilities
You will join a friendly, supportive and dedicated Business Intelligence team committed to delivering a high quality and responsive service to the Trust. We are committed to providing a supportive work environment and promoting learning and development opportunities.
Please refer to the Job Description/Person Specification for full details of the role and responsibilities.
The Trust is committed to safeguarding and promoting the welfare of children, young people and vulnerable adults and expects all staff and volunteers to share this commitment and promote safeguarding by implementing the Trusts policies and procedures, acting promptly on concerns, communicating effectively and sharing information appropriately.
Job description
Job responsibilities
You will join a friendly, supportive and dedicated Business Intelligence team committed to delivering a high quality and responsive service to the Trust. We are committed to providing a supportive work environment and promoting learning and development opportunities.
Please refer to the Job Description/Person Specification for full details of the role and responsibilities.
The Trust is committed to safeguarding and promoting the welfare of children, young people and vulnerable adults and expects all staff and volunteers to share this commitment and promote safeguarding by implementing the Trusts policies and procedures, acting promptly on concerns, communicating effectively and sharing information appropriately.
Person Specification
Qualifications
Essential
- Relevant Master's degree or equivalent level of experience
- Evidence of continuing professional development
Desirable
- Microsoft SQL Server MCSA certification
Experience
Essential
- Extensive experience of advanced T-SQL query writing
- Substantial experience of query performance tuning in Microsoft SQL Server
- Substantial experience of developing ETL solutions using SSIS
- Experience of developing dashboards in Tableau or another similar BI Tool e.g. Power BI, Qlik etc
- In depth experience of designing, developing and implementing reporting systems and processes
- oSignificant experience and proven track record in a senior analytical position in an acute NHS Trust.
Desirable
- Experience of using C#, JavaScript and Python
- Experience of Tableau Server administration
Knowledge
Essential
- Good knowledge of industry standard data warehouse design methodologies i.e., Kimball and Inmon
- SQL server query optimisation techniques
- SSIS package performance and optimisation
- Specialist knowledge of statistical, analytical and presentation techniques
- Sound understanding of Information Governance
- In depth highly specialist knowledge of NHS information processes, data sets, definitions and standards
- Extensive understanding of the healthcare model - commissioning frameworks, CQUINs and the NHS performance agenda
Skills
Essential
- Excellent analytical and problem-solving skills
- Strongly pro-active and solution orientated and technically innovative
- Proven ability to manage and interpret complex numerical data
- Ability to work under pressure to meet deadlines
- Excellent communication, presentation and interpersonal skills
- Qualities of perseverance, flexibility, determination and adaptability
Person Specification
Qualifications
Essential
- Relevant Master's degree or equivalent level of experience
- Evidence of continuing professional development
Desirable
- Microsoft SQL Server MCSA certification
Experience
Essential
- Extensive experience of advanced T-SQL query writing
- Substantial experience of query performance tuning in Microsoft SQL Server
- Substantial experience of developing ETL solutions using SSIS
- Experience of developing dashboards in Tableau or another similar BI Tool e.g. Power BI, Qlik etc
- In depth experience of designing, developing and implementing reporting systems and processes
- oSignificant experience and proven track record in a senior analytical position in an acute NHS Trust.
Desirable
- Experience of using C#, JavaScript and Python
- Experience of Tableau Server administration
Knowledge
Essential
- Good knowledge of industry standard data warehouse design methodologies i.e., Kimball and Inmon
- SQL server query optimisation techniques
- SSIS package performance and optimisation
- Specialist knowledge of statistical, analytical and presentation techniques
- Sound understanding of Information Governance
- In depth highly specialist knowledge of NHS information processes, data sets, definitions and standards
- Extensive understanding of the healthcare model - commissioning frameworks, CQUINs and the NHS performance agenda
Skills
Essential
- Excellent analytical and problem-solving skills
- Strongly pro-active and solution orientated and technically innovative
- Proven ability to manage and interpret complex numerical data
- Ability to work under pressure to meet deadlines
- Excellent communication, presentation and interpersonal skills
- Qualities of perseverance, flexibility, determination and adaptability
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).
