Detailed job description and main responsibilities
DUTIES AND RESPONSIBILITIES
1. Develop and maintain complex data transfer pipelines from source systems to the Trust Data Warehouse and Data Marts.
2. Analyse and interpret requirements and specifications from the Business Intelligence Analysts to inform data construct design, development and assurance processes.
3. Support the appropriate data warehousing design and software development methodologies agreed for use within the team.
4. Produce detailed technical specifications and documentation for the support, maintenance, monitoring and quality assurances of ETL processes.
5. Investigate, support, correct and prevent issues relating to existing Trust developed data reporting systems and processes, identifying issues and implementing resolutions in a timely manner.
6. Participate in the sprint planning process to determine durations and any dependencies with planned development work.
7. Develop test plans, and supporting test data, for the developed services in order to validate their stable and maintainable operation against requirements.
8. Ensure that skills and knowledge are kept up-to-date through professional development.
9. Make recommendations on new tools, technologies and techniques that can be adopted by the team.
10. Participate in regular exercises to test business continuity and disaster recovery plans.
Human Resources
1. Line manage (if applicable) in line with appropriate policies, procedures, working practices and guidelines, ensuring all resources are deployed to maximise an efficient and effective delivery of support services to patients and users.
2. As requested, provide reports on progress, status and achievements for own work.
3. Undertake and support the development of staff/placements in line with personal development reviews and other associated guidance.
4. Provide guidance for staff from own or other disciplines on own subject area, when required.
5. On limited occasions, by exception, the post holder may be required to work unsociable hours to support and/or enable the delivery of key programmes or projects.
Financial/Physical Resources
1. Be responsible for the safe and efficient use of hardware, software and financial resources.
2. Where required, liaise with external agencies, suppliers and contractors ensuring delivery of service is in line with agreed contracts and value for money.
3. Ensure the post holder adheres to Trust Standing Financial Instructions (SFIs) and procurement guidelines.
Project Management
1. Advise and participate in the development and implementation of projects as part of planned development sprint cycles.
2. Ensure project tasks, where required, are successfully delivered in line with agreed timescales and budgets.
3. Work with line manager to ensure any project management documentation or reports are delivered in line with agreed standards and timescales.
Policy/Service Development/Governance
1. Act as an ambassador for Digital Services by developing and maintaining excellent working relationships with users across the organisation to deliver a high quality professional service as part of the a development team.
2. Pro-actively participate in ensuring that Digital services delivered within the Trust reflect best practice with respect to organisational, NHS and legislative requirements and guidelines including IT Infrastructure Library (ITIL), Data Protection Act 2018, Information Standards, Information Security and compliance with NHS Information Governance.
3. Ensure all documentation relating to own area is complete and fit for purpose and all releases relating to hardware, software and documentation is controlled.
4. Ensure there is a proactive and comprehensive approach to risk management and be responsible for service continuity for own area.
5. Contribute to Root Cause Analysis (RCA) for allocated incidents and problems; instigating action when required, liaising with other team members and managers, as appropriate.
Business Continuity Management
1. Be familiar with the Trust and Department level Business Continuity Plan and personal responsibilities within, where applicable.
Person specification
Qualifications
Essential criteria
1. University Degree in a related subject or demonstrable equivalent experience in developing Business Intelligence Solutions.
Desirable criteria
1. UK Council for Health Informatics Professionals (UKCHIP) registration or equivalent.
2. Agile development qualification.
3. Microsoft certifications or equivalent technical qualifications.
Experience
Essential criteria
1. Substantial experience of design, build and deployment of Business Intelligence functions in a large/complex organisation.
2. Substantial experience of SQL Server database/data warehouse development maintenance and support.
3. Substantial experience of handling ETL solutions and issues across a range of systems.
4. Substantial experience of delivering complex data and reporting projects.
5. Experience in task resource estimation for sprint planning.
6. Experience in creating and updating system documentation relating to Business Intelligence processes.
7. Experience in developing data interchange processes using XML and JSON.
8. Experience of successfully managing a number of equally important tasks to completion.
Desirable criteria
1. Previous experience of working in the NHS.
2. Using NoSQL data sources.
3. Source control processes and branching strategies.
4. Database table partitioning.
5. Data transfer using a web API.
6. Transferring data using SFTP.
Skills
Essential criteria
1. Creating well-structured SQL Server Integration Services packages for data transfer and Data Warehouse ETL processes.
2. Designing and implementing SQL Server Reporting Services reports.
3. Data transfer using XML and JSON.
4. Developing custom SSIS Script Tasks/Components using C# to add non-standard functionality to SSIS Packages.
5. Using Visual Studio for database and business intelligence development.
6. Advanced T-SQL query writing.
7. Microsoft Excel.
8. Ability to use own initiative, coach individuals and lead a project team engendering enthusiasm and commitment.
9. Able to work to deadlines, prioritise and manage workload in a busy and changing environment.
10. Strong problem solving approach.
11. Ability to work under pressure.
12. Influencing and negotiating skills.
13. Ability to think creatively.
14. Ability to explain complex technical issues to a non-technical audience.
Desirable criteria
1. Azure DevOps.
2. Tableau.
3. Power BI.
4. SQL Server Analysis Services.
5. MDX.
6. R.
7. Python.
8. Source control using Visual Studio.
9. Master Data Services.
10. Business Intelligence Markup Language and BIML Express.
Knowledge
Essential criteria
1. Good knowledge of industry standard Data Warehouse design methodologies, i.e., Kimball.
2. SQL Server query optimisation techniques.
3. SSIS package performance optimisation.
4. Best practices relating to the Microsoft SQL Server stack.
Values
Essential criteria
1. Ability to demonstrate the organisational values and behaviours.
Other
Essential criteria
1. Evidence of continuing professional and personal development.
2. Ability to travel to Christie managed sites as necessary.
3. Ability to undertake shift working including out-of-hours, weekend and Public Holidays as required.
The closing date for this post may be extended if there are insufficient applicants or brought forward if there is a high volume of applicants.
We want to ensure that everyone who works at the Christie or uses our services is welcomed, valued and treated with dignity and respect. The Christie values diversity and is committed to ensuring equal opportunities for all and fair representation across the organisation at all levels. In support of these commitments, we particularly welcome applications from Black, Asian and other ethnic minority people and people with disabilities for this post. Appointment will be only on merit.
We are committed to creating a balanced and diverse workforce. As such we welcome and encourage applications from people of all backgrounds. Together we will foster inclusion and tackle inequity and health inequalities in cancer care.
As users of the disability confident scheme, we guarantee to interview all disabled applicants who meet the minimum criteria for the vacancy.
All positions within the Christie are subject to the receipt of satisfactory written references, medical clearance and evidence of your Right to Work in the UK. Some roles will require a Disclosure & Barring Service (DBS) check. Please note if you are successfully appointed to a post with this Trust, you will be required to pay for your own DBS Disclosure.
By applying for this post you are agreeing to The Christie NHS Foundation Trust transferring the information contained in this application to its preferred applicant management system. If you are offered a job, information will also be transferred into the national NHS Electronic Staff Records system. Please note, all communication regarding your application will be made via email; please ensure you check your junk/spam folders as emails are sometimes filtered there.
If you have not heard from us within four weeks of the closing date, I regret that on this occasion your application will have been unsuccessful.
The Inter-Authority Transfer (IAT) process is a critical and beneficial component of ESR and will form part of the recruitment process. In the event that you are successful following interview, your previous NHS employment data, if applicable, will be transferred from your current / most recent employer.
Overseas candidates wishing to apply for this position and who would require immigration sponsorship may wish to self-assess the likelihood of obtaining a Certificate of Sponsorship for the post on the UKVI website.
You should be aware the Trust operates a No Smoking Policy and therefore employees are not permitted to smoke at work.
Employer certification / accreditation badges
Documents to download
1. Job Description and Person Specification (PDF, 192.8KB)
2. The Christie Values and Behaviours (PDF, 919.5KB)
3. Strategy Brochure (PDF, 1.0MB)
4. Trust Membership - Christie Talent (PDF, 23.0KB)
5. Travel to The Christie (PDF, 3.8MB)
#J-18808-Ljbffr