Job summary
The post holder will support in the maintenance and development of analytical web-based informatics tools and focus on clinical and operation reporting.
Supporting Informatics community and virtual ward reporting requirements.
Using SQL to extract data and automating reports in Power BI and other reporting tools to meet the teams requirements for both routine and Ad hoc reporting.
Developing systems and data knowledge to help meet reporting requirements.
Generates, produces and distributes routine and ad-hoc reports.
Utilising Microsoft technologies including Power Bi and SQL.
Main duties of the job
To support in the design, development and maintenance of informatics systems. This will involve working with complex processes involving large data sets and utilising Microsoft technologies such as SQL Server, Analysis Services and Integration Services.
Handling of large complex data sets and dimensional data models in order to support in the design and delivery multi-audience reports.
Extraction, processing and validation of data from various data sources.
To ensure the existing processes are regularly reviewed and modified and/or new procedures developed as required to ensure timely and accurate reporting of data both internally and externally.
Maintaining accurate and accessible tailored technical documentation and scripts.
Proactively seeking to improve the technical capability and efficiency of informatics solutions to minimise downtime.
Planning and prioritisation of own workload to ensure that agreed deadlines are met.
Maintaining a high level of accuracy within work and ensuring work is auditable.
Ensuring Department guidelines are followed, and a culture of best practice is promoted regarding analysis and the clear presentation of reports.
Ensuring that any reporting, whether of a complex or simple nature, runs efficiently and is automated where possible.
Continually developing technical skills. Researching new software tools, data management & analytical techniques to ensure best practice.
About us
We are recognised as one of the leading NHS Foundation Trusts in the UK. Our vision is to Build Healthier Lives, and we recognise that we need incredible staff to do this.
Our commitment to our staff is to create the best place for them to work, and we are dedicated to:
Investing in the health and wellbeing of our staff, including a commitment of offering flexible working where we can;Offer our staff a wide variety of training and development opportunities, to support their personal and career development objectives.
UHB is committed to ensuring that our staff are treated fairly and feel that they belong, by creating a kind and inclusive environment. This is about equity of opportunity; removing all barriers, including discrimination and ensuring each individual member of staff reach their true potential, achieve their ambitions and thrive in their work. This is more than words. We are taking action. Our commitment to an inclusive culture is embedded at all levels of the organisation where every voice is heard, driven by our diverse and active staff networks, and at Board level by the Fairness Taskforce led by our CEO. We nurture a culture which empowers staff to challenge discriminatory behaviours and to enable people to bring their 'whole self' to a kinder, more connected and bold place to work.
University Hospitals Birmingham is a Smoke-Free premises hospital.
Job description
Job responsibilities
*Please Note : For a detailed job description for this vacancy, please see attached Job Description*
Job description
Job responsibilities
*Please Note : For a detailed job description for this vacancy, please see attached Job Description*
Person Specification
Qualifications
Essential
- *Minimum grade 4/C in GCSE English and Maths.
- *Degree level or equivalent knowledge and skills in a numerate discipline.
Experience
Essential
- *Experience with database software and applications
- *Familiarity with database concepts
Desirable
- *Experience of web related technologies and the development of web-based reports.
- *Experience of producing automated reports.
- *Experience in querying / designing Dimensional Modelled Databases
- *Knowledge of dimensional data modelling methodologies & relational database design.
- *Experience in providing user support.
- *Experience of and confidence in interacting with senior members of an organisation.
- *Understanding of NHS Healthcare Service.
- *Knowledge of NHS data standards, definitions, and guidance, or demonstrated ability to rapidly acquire such knowledge.
- *Knowledge of querying of NHS datasets / systems (or other highly complex data).
Additional Criteria
Essential
- *Ability to use Microsoft Office suite.
- *Excellent analytical and problem-solving skills.
- *Advanced Keyboard skills and understanding of simultaneous working across multiple computer applications.
- *Good communication and interpersonal skills.
- *Ability to work under pressure.
- *Self-motivated with the ability to work autonomously and effectively within a team.
- *A desire to continue personal professional development, learn new technologies, updating skills and knowledge on an on-going basis. Attention to detail
- *Professional manner
- *Excellent organisational and time management skills
- *Ability to prioritise tasks
- *Ability to support the day-to-day work of more junior staff
Desirable
- *Experience of Microsoft BI tools including SQL Server (T-SQL), Analysis Services & Integration Services.
- *Experience of using statistical software packages such as SAS, Python or R.
Person Specification
Qualifications
Essential
- *Minimum grade 4/C in GCSE English and Maths.
- *Degree level or equivalent knowledge and skills in a numerate discipline.
Experience
Essential
- *Experience with database software and applications
- *Familiarity with database concepts
Desirable
- *Experience of web related technologies and the development of web-based reports.
- *Experience of producing automated reports.
- *Experience in querying / designing Dimensional Modelled Databases
- *Knowledge of dimensional data modelling methodologies & relational database design.
- *Experience in providing user support.
- *Experience of and confidence in interacting with senior members of an organisation.
- *Understanding of NHS Healthcare Service.
- *Knowledge of NHS data standards, definitions, and guidance, or demonstrated ability to rapidly acquire such knowledge.
- *Knowledge of querying of NHS datasets / systems (or other highly complex data).
Additional Criteria
Essential
- *Ability to use Microsoft Office suite.
- *Excellent analytical and problem-solving skills.
- *Advanced Keyboard skills and understanding of simultaneous working across multiple computer applications.
- *Good communication and interpersonal skills.
- *Ability to work under pressure.
- *Self-motivated with the ability to work autonomously and effectively within a team.
- *A desire to continue personal professional development, learn new technologies, updating skills and knowledge on an on-going basis. Attention to detail
- *Professional manner
- *Excellent organisational and time management skills
- *Ability to prioritise tasks
- *Ability to support the day-to-day work of more junior staff
Desirable
- *Experience of Microsoft BI tools including SQL Server (T-SQL), Analysis Services & Integration Services.
- *Experience of using statistical software packages such as SAS, Python or R.
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).
