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.

Working for our organisation

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

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.

Detailed job description and main 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

• 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
• Working towards a Post-Graduate Degree in a relevant subject
• Management qualification (such as Prince2, iLM or ITIL)
• Microsoft SQL Certification
• Snowflake certification

Experience

• 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
• Proven experience within an IT / BI Development field
• Track record of developing information outputs through assessment and use of the most efficient analytical tools
• 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

• 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)
• Ability to develop in the Qlik web based reporting platform.
• Snowflake Data Platform Terminology
• Leadership & People Management
• Advance Skills in Microsoft Office (such as Excel)

Knowledge

• 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
• 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

• 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
• Able to work as part of a Team, also on own initiative
• Able to identify and implement new innovation which will benefit the team or Trust

Our Trust prefers candidates to submit applications online. Please contact the Recruitment Team on 01942 244000 if you have difficulty applying online.

The Trust reserves the right to close adverts earlier than the stated closing date if there is a high volume of applications.

We endeavour to inform all applicants of the outcome of their application by email or SMS text message.

Guidance on Completing Your Application

Applications are scored against the person specification, therefore we recommend that you use the supporting information section of your application form to demonstrate how you meet the essential and desirable criteria for the role, providing illustrative examples where possible.

On-Call

Please note that some roles may require you to participate in an on-call rota, if the role is predominantly operational.

WWL has signed up to the Greater Manchester Continuous Service Commitment. and will recognise your continuous or ‘unbroken’ service in any Greater Manchester Local Authority or NHS organisation, Transport for Greater Manchester, Greater Manchester Fire and Rescue Service or Greater Manchester Combined Authority; giving you access to our service-related benefits.

Employer certification / accreditation badges

Name Matt Pullen Job title Data Platform Manager Email address matt.pullen@wwl.nhs.uk Telephone number 01942 822726 Additional information

Matt Pullen, Data Platform Manager

E: matt.pullen@wwl.nhs.uk

Or

Paul Woolley, Deputy Data Platform Manager

E:paul.woolley@wwl.nhs.uk

If you have problems applying, contact

Address Buckingham Row
Brick Kiln Lane
Wigan
WN1 1XX
Telephone 07786529393

Originaltext