Advanced Information Analyst
Main area: Analyst
Grade: Band 7
Hours: Full time: 37.5 hours per week
Job ref: 362-A-20-2847714
Site: Stepping Hill Hospital
Salary: £38,890 - £44,503 Per Annum
Salary period: Yearly
Closing: 24/01/2021 23:59
Stockport NHS Foundation Trust
There are lots of good reasons to choose to come and work at Stockport NHS Foundation Trust. A dynamic integrated Trust with integrity and vision. Exactly the same qualities you’ll see in yourself. Stockport NHS Foundation Trust aims to be the organisation of choice for patients and an employer of choice for staff. In order to continually improve all aspects of our patient experience, we rely upon having a highly skilled, motivated, diverse, productive and patient focused workforce.
Stockport Foundation Trust is one of four ‘specialist’ hospital sites in Greater Manchester. Being a ‘specialist’ hospital will enhance our general surgery, anaesthetics, critical care and emergency medicine for the benefit of people in Stockport, High Peak, Cheshire and across Greater Manchester.
Our values ‘We Care, We Respect, We Listen’ are at the heart of everything we do, and come from our promise: ‘Making a difference every day.’ They drive the behaviour and actions for everyone in our organisation.
In your application for this post, please describe how your experience and skills align with 'Our values-based behaviours' ( see additional documentation) and provide examples.
Greater Manchester Continuous Service Commitment
As well as recognising previous NHS service, Stockport NHS Foundation Trust is a member of the Greater Manchester Continuous Service Commitment. If you are currently employed by Greater Manchester Local Authority, Combined Authority, GMFRS, TfGM as well as other public service organisations, Stockport NHS Foundation Trust will recognise your previous service for sickness and maternity/paternity/adoption entitlement and also for annual leave purposes (providing there has been no break in service). If you currently work for one of the above organisations and successfully apply for a post with Stockport NHS Foundation Trust, please ensure the Recruitment team are aware so that this service is reflected in your contract of employment.
We Listen to
Advanced Information Analyst - Band 7 – Full Time
Please note interview may happen on the 1st week of Feb 2021
The Trust is looking to recruit an enthusiastic and highly motivated analyst to join the Business Intelligence team. At a time when the demand for robust information to support business planning is increasing and the NHS information agenda is rapidly changing, the ability to work as a flexible team member is essential.
The successful candidate will have a strong track record in analytics, and use their specialist knowledge of Tableau, SQL, and Excel to promote and maximizing the use of Information and the benefits derived from it.
Main duties of the job
They will possess:
Experience of creating reports and dashboards using Tableau
Experience of using of MS SQL and associated Business Intelligence products.
Advanced skills in the use of relational databases and query languages.
Advanced skills in the use of MS Excel, with the ability to present data visually, and to create dynamic and interactive reports
Excellent communication, presentation and interpersonal skills.
Good powers of persuasion
The ability to present complex, sensitive and contentious information to clinicians and senior management.
Be a self-motivated team player, with the initiative to develop the role further.
This post is ideal for an enthusiastic, experienced analyst who has the ability to work logically, with great attention to detail and be tenacious in resolving problems.
Note: Potential applications should be able to evidence or demonstrate at interview previous examples of work. An SQL test will form part of interview and selection process.
Working for our organisation
Stockport NHS Foundation Trust provides hospital services for children and adults across Stockport and the High Peak, as well as community health services for Stockport, Tameside and Glossop. Stepping Hill Hospital treats over 500,000 patients per year and community health services are run across 24 sites in Stockport and 17 sites in Tameside and Glossop.
There are lots of good reasons to choose to come and work at Stockport NHS Foundation Trust. A dynamic integrated Trust with integrity and vision. Exactly the same qualities you’ll see in yourself.
Stockport NHS Foundation Trust aims to be the organisation of choice for patients and an employer of choice for staff. In order to continually improve all aspects of our patient experience, we rely upon having a highly skilled, motivated, diverse, productive and patient focussed workforce.
We are constantly improving how we work with staff and this is reflected in the awards we have been awarded, which can be viewed on our website.
Detailed job description and main responsibilities
To work as part of a dynamic team in delivering an effective information analytical service, supporting business groups, managers and clinicians. To provide specialist advice and guidance on data, analysis and measurement within a wide range of domains, developing business and performance management reporting, indicators and dashboards.
The post holder will have advanced database and MS Excel skills, having worked with relational database systems; possess strong technical skills with the ability to write complex SQL queries using SQL Server and ideally have a good knowledge of creating reports using SQL Server Reporting Services. The role will also require good level of dashboard design and report building skills, making use of the Trust’s BI software Tableau to deliver visual analytics that are clear and insightful.
They will be an expert for their domain but be expected to understand all areas of activity; to develop reports and help end-users to interpret information. They will continually look to enhance the format of information provided and seek to provide innovative solutions to help inform decision making across the Trust.
Education & Qualifications
Master’s degree or equivalent experience in Informatics at a senior level
Evidence of continuing professional development
In depth highly specialist knowledge of NHS information processes, data sets, definitions and standards
Expert knowledge of MS Excel and Access products, including the ability to devise complex, interlinked and macro driven models and charts.
Specialist knowledge of statistical, analytical and presentation techniques.
Knowledge of the performance management and other information requirements of an operational NHS Business Group.
Sound understanding of Information Governance
Extensive experience of using SQL Server Management studio, including the ability to write complex SQL queries
Significant experience and proven track record in a senior analytical position
In depth experience of designing, developing and implementing reporting systems and processes.
Highly proficient in interpreting national guidance/ requirements and developing plans to implement
Experience developing performance dashboards.
Experience of resolving complex problems involving many functions and stakeholders.
Experience of supporting business planning.
Experience of delivering training to both informatics and non-informatics staff.
Experience of developing dashboards in Tableau
Experience of using Microsoft SQL Reporting services SRSS and Integration services SSIS
Experience of managing staff
Experience of developing and interpreting predictive modelling
Skills & Abilities
Excellent analytical and problem solving skills.
Ability to communicate with a wide range of people from different backgrounds
Ability to shape requirements from broad concepts and to act upon incomplete information.
Ability to demonstrate strategic and innovative thinking.
Ability to work under pressure to meet deadlines.
Ability and willingness to work to standards
Ability and willingness to share knowledge with team members.
Able to work logically with great attention to detail.
Excellent communication, presentation and interpersonal skills. Good powers of persuasion and able to present complex, sensitive and contentious information to clinicians and senior management.
Staff management skills.
Applicants are encouraged to read the documents attached to this vacancy before applying, including the job description and person specification and the information for applicants which includes useful information to assist you in completing your application.
From time to time we may need to close a vacancy early when in receipt of a sufficient number of applications. If you are interested in this post and wish to be considered, we strongly advise you to complete and submit your application as soon as possible.
Please note that all correspondence will be via your NHS Jobs account. Unfortunately we are not able to acknowledge each application. If you do not hear from us within four weeks of the closing date, please consider that you have not been shortlisted on this occasion. Please also note that Stockport NHS Foundation Trust are unable to refund Interview expenses or re-location costs.
Stockport NHS Foundation Trust is committed to promoting and championing a culture of diversity, fairness and equality for all applicants and employees. Applications are welcomed from all backgrounds and we strive to reflect the community we serve in our diverse workforce. Our "two tick" kite mark guarantees a candidate with a disability, who fulfills the essential criteria, an interview at the Trust. We can make reasonable adjustments, and offer support and advice in a variety of ways on request.