Job summary
Do you want to work for one of the leading organisations in NHS Data Analytics and winner of numerous awards both national and international?
Do you want to work in a Successful, Friendly and Forward Thinking team that's highly regarded?
Do you want to be part of a team creating innovative, cutting edge BI applications, that are available to other NHS Trust's.If so we are looking for an enthusiastic individual to join our growing Development Den, to continue the production of Ground Breaking & Award Winning BI Solutions and supporting the migration and enhancement of our cloud data warehouse.
- Proven experience and skill in developing in the Microsoft SQL Server BI Stack.
- Experience utilising the Snowflake Cloud Data Platform is advantageous but not essential.
- Experience and skill in BI Self Service technologies such as Qliksense is advantageous but not essential.
The successful candidate will also have to possess excellent numeracy, logical and communication skills, be educated to Degree level or have equivalent experience & knowledge in the above technologies & Business Intelligence.Knowledge of Health Informatics, NHS Data Structures, Processes and Analytics is Desirable however not essential.
This is a development role where the successful candidate will commence a 2 year on the job training as a band 5 before progressing to band 6 on successful completion of the programme.
Main duties of the job
The post holder will play an important role in the development of future reporting within the Trust. They will utilise and develop their relational database skills, using SQL, and their Data analytics (BI) knowledge. They will develop and analyse and interpret business and performance information to ensure the accurate and timely production of reports as per the requirements of the Trust and external bodies.
Responsible for delivering the build of data tables and identify and address the continued development and maintenance of the Snowflake Data Warehouse. Additionally the post holder will offer technical support within the Data analytics Department and other divisional teams
and enhance the Trusts Data analytics solutions and service.
The post holder will be expected to work autonomously, be innovative, delivering work to a high standard within tight deadlines.
To support the department management in shaping and delivering the data analytics strategic vision to streamline activities and focus on value added goals, implementing a real time corporate approach to intelligence, a single version of the truth, exploring and utilising world class technologies and predictive analytics.
Provide support and represent the Data Warehouse service as required
This is a hybrid working role where the successful candidate will be required to commute into the Wigan office 1 day a week and work remotely the other 4.
About us
Wrightington, Wigan and Leigh Teaching Hospitals NHS Foundation Trust are the proud providers of acute hospital and community services to the people of the Wigan Borough and surrounding areas. At WWL, we value our staff believing that 'happy staff, makes for happy patients'. We have a recognised track record in staff engagement and living our values.
People at the Heart
Listen and Involve
Kind and Respectful
ONE Team
WWL are committed to placing the patient at the heart of everything we do, and in the provision of safe, effective care that acknowledges and ensures dignity. We are seeking to recruit people who share our values and beliefs.
At WWL we value the benefits a rich and diverse workforce brings to our community and therefore welcome applications from all sections of society.
COVID-19 vaccination remains the best way to protect yourself, your family, your colleagues and of course our patients from the virus when working in our healthcare settings. Whilst COVID-19 vaccination is not a condition of employment, we do encourage our staff to get vaccinated. If you are unvaccinated there is helpful advice and information available by contacting covid-19.vaccine@wwl.nhs.uk where you can also ask about how to access vaccinations.
Job description
Job responsibilities
- To play a key role in the development of data analytics applications using Trust Data analytics (BI) tools eg. Snowflake, SQL Server to deliver datasets to meet the aims of the Data analytics Strategy and the needs of the organisation.
- Liaise with IM&T Teams to ensure that the most up to date datasets and feeds are available via the data warehouse, tables and databases to ensure that reporting and submissions are based on the most accurate data definitions available.
- Establish and Maintain relationships with colleagues to ensure smooth operation of systems, resolution of complicated problems and system upgrades.
- Work with users to resolve problems and issues with data analytics software.
- Conduct briefing sessions and training days for in relation to the use and interpretation of the data analytics applications.
- Utilising the post holders SQL knowledge to work with clients in developing new datasets for reporting applications and ensuring effective capture of end user requirements. To work and ensure that all reporting solutions to meet business requirements and ensure that the business requirements are met.
- To communicate effectively, and work well in a team.
- Responsible for the database design relating to table builds for key developments within the Trusts data warehouse.
- To automate extraction and reporting of existing and new data flows.
Job description
Job responsibilities
- To play a key role in the development of data analytics applications using Trust Data analytics (BI) tools eg. Snowflake, SQL Server to deliver datasets to meet the aims of the Data analytics Strategy and the needs of the organisation.
- Liaise with IM&T Teams to ensure that the most up to date datasets and feeds are available via the data warehouse, tables and databases to ensure that reporting and submissions are based on the most accurate data definitions available.
- Establish and Maintain relationships with colleagues to ensure smooth operation of systems, resolution of complicated problems and system upgrades.
- Work with users to resolve problems and issues with data analytics software.
- Conduct briefing sessions and training days for in relation to the use and interpretation of the data analytics applications.
- Utilising the post holders SQL knowledge to work with clients in developing new datasets for reporting applications and ensuring effective capture of end user requirements. To work and ensure that all reporting solutions to meet business requirements and ensure that the business requirements are met.
- To communicate effectively, and work well in a team.
- Responsible for the database design relating to table builds for key developments within the Trusts data warehouse.
- To automate extraction and reporting of existing and new data flows.
Person Specification
Qualifications
Essential
- Educated to Degree standard in Mathematics, Statistics, Science, IT or similar relevant subject. Alternatively work knowledge & experience of equivalent level
- Evidence of professional development for example MCTS qualification or attending accredited IT courses
- IT qualification
Desirable
- Working towards a Post-Graduate Degree in a relevant subject
- Management qualification (such as Prince2, iLM or ITIL)
- Microsoft SQL Certification
- Snowflake certification
Experience
Essential
- Minimum of 2 Years' Experience writing advance SQL
- Experience in Database & Data Warehouse Design
- Experience within the Business Intelligence field.
- Experience of Assisting, Capturing and Documenting Customer Requirements.
- Experience of Identifying, Managing or Communicating Data Quality Issues
- Experience of a web based Business Intelligence reporting
- Experience of a web-based Business Intelligence reporting software
- Planning, creation and implementation of software developments ideally within a data warehouse
- System design, Data Programming, facilitating Validation
- Proven experience within an IT / BI Development field
- Track record of developing information outputs through assessment and use of the most efficient analytical tools
Desirable
- Experience of Snowflake Data Platform
- Experience of EPR data extraction
- Experience of SQL Server Integration Services
- Creation of Programme, Project and Work Plans.
- Experience of working in a busy NHS Information Department
- Experience of Azure Data Factory v2
- Proven track record of leading or managing Projects or Programmes of work to tight Deadlines and Budgets.
- Working with Financial / Performance software
- Experience Training and Mentoring Staff.
Skills
Essential
- Skills in writing advanced SQL
- Excellent communication and presentation skills, both oral and written
- Proactive and Responsive to Customer Demands.
- Ability to concentrate for long periods of time on diverse, complex analyses, with frequent interruptions.
- Ability to prioritise varied and high volume workloads
- Ability to translate non-technical requirements into technical solutions and to communicate effectively
- Advanced Skills in Microsoft Office Professional (Excel, Access)
- Database & Data Warehouse Design
- Ability to translate non-technical requirements into technical solutions and to communicate complex analytics to others with little or no analytic background.
- Advanced Skills in Microsoft Office Professional (Excel)
Desirable
- Ability to develop in the Qlik web based reporting platform.
- Snowflake Data Platform Terminology
- Azure Data Factory
- Azure Devops
- Project & Programme Management
- Leadership & People Management
- Advance Skills in Microsoft Office (such as Excel)
Knowledge
Essential
- Proven knowledge of current and emerging technologies to best advise on future system and service development.
- Thorough working knowledge of Microsoft SQL Server
- Thorough working knowledge of Business Intelligence, its Purpose, Potential and Future Direction.
- Knowledge of the Extract Transform Load (ETL) layer within a data warehouse environment
Desirable
- Knowledge of Kimball and Inmon Data Warehouse Design principles
- Knowledge of the Snowflake Cloud Data Platform
- Knowledge of Azure Data Factory v2
- Knowledge of any other programming language
- Knowledge of Hospital / Clinical & Acute systems
- An understanding of National datasets and central reporting in use in the NHS
- Knowledge of Data Protection Act, Information Governance and Security and Confidentiality
Additional
Essential
- Willing to adopt a Flexible approach to working hours.
- Challenging and inquiring mindset combined with an aptitude for working within a changing environment.
- Motivation and willing to undertake further training / qualifications as necessary.
- Speak English to an appropriate standard relevant to their role, i.e. with confidence and accuracy, using correct sentence structures and vocabulary, and without hesitation
Desirable
- Able to work as part of a Team, also on own initiative
- Excellent Time Management Skills
- Able to identify and implement new innovation which will benefit the team or Trust
- Drive for Personal and Team Development
Person Specification
Qualifications
Essential
- Educated to Degree standard in Mathematics, Statistics, Science, IT or similar relevant subject. Alternatively work knowledge & experience of equivalent level
- Evidence of professional development for example MCTS qualification or attending accredited IT courses
- IT qualification
Desirable
- Working towards a Post-Graduate Degree in a relevant subject
- Management qualification (such as Prince2, iLM or ITIL)
- Microsoft SQL Certification
- Snowflake certification
Experience
Essential
- Minimum of 2 Years' Experience writing advance SQL
- Experience in Database & Data Warehouse Design
- Experience within the Business Intelligence field.
- Experience of Assisting, Capturing and Documenting Customer Requirements.
- Experience of Identifying, Managing or Communicating Data Quality Issues
- Experience of a web based Business Intelligence reporting
- Experience of a web-based Business Intelligence reporting software
- Planning, creation and implementation of software developments ideally within a data warehouse
- System design, Data Programming, facilitating Validation
- Proven experience within an IT / BI Development field
- Track record of developing information outputs through assessment and use of the most efficient analytical tools
Desirable
- Experience of Snowflake Data Platform
- Experience of EPR data extraction
- Experience of SQL Server Integration Services
- Creation of Programme, Project and Work Plans.
- Experience of working in a busy NHS Information Department
- Experience of Azure Data Factory v2
- Proven track record of leading or managing Projects or Programmes of work to tight Deadlines and Budgets.
- Working with Financial / Performance software
- Experience Training and Mentoring Staff.
Skills
Essential
- Skills in writing advanced SQL
- Excellent communication and presentation skills, both oral and written
- Proactive and Responsive to Customer Demands.
- Ability to concentrate for long periods of time on diverse, complex analyses, with frequent interruptions.
- Ability to prioritise varied and high volume workloads
- Ability to translate non-technical requirements into technical solutions and to communicate effectively
- Advanced Skills in Microsoft Office Professional (Excel, Access)
- Database & Data Warehouse Design
- Ability to translate non-technical requirements into technical solutions and to communicate complex analytics to others with little or no analytic background.
- Advanced Skills in Microsoft Office Professional (Excel)
Desirable
- Ability to develop in the Qlik web based reporting platform.
- Snowflake Data Platform Terminology
- Azure Data Factory
- Azure Devops
- Project & Programme Management
- Leadership & People Management
- Advance Skills in Microsoft Office (such as Excel)
Knowledge
Essential
- Proven knowledge of current and emerging technologies to best advise on future system and service development.
- Thorough working knowledge of Microsoft SQL Server
- Thorough working knowledge of Business Intelligence, its Purpose, Potential and Future Direction.
- Knowledge of the Extract Transform Load (ETL) layer within a data warehouse environment
Desirable
- Knowledge of Kimball and Inmon Data Warehouse Design principles
- Knowledge of the Snowflake Cloud Data Platform
- Knowledge of Azure Data Factory v2
- Knowledge of any other programming language
- Knowledge of Hospital / Clinical & Acute systems
- An understanding of National datasets and central reporting in use in the NHS
- Knowledge of Data Protection Act, Information Governance and Security and Confidentiality
Additional
Essential
- Willing to adopt a Flexible approach to working hours.
- Challenging and inquiring mindset combined with an aptitude for working within a changing environment.
- Motivation and willing to undertake further training / qualifications as necessary.
- Speak English to an appropriate standard relevant to their role, i.e. with confidence and accuracy, using correct sentence structures and vocabulary, and without hesitation
Desirable
- Able to work as part of a Team, also on own initiative
- Excellent Time Management Skills
- Able to identify and implement new innovation which will benefit the team or Trust
- Drive for Personal and Team Development
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.
Employer details
Employer name
Wrightington Wigan & Leigh Teaching Hospitals NHS Foundation Trust
Address
Buckingham Row
1 Brick Kiln Lane,
Wigan
WN1 1XX
Employer's website
http://www.wwl.nhs.uk/ (Opens in a new tab)
