Job summary
An exciting opportunity has arisen within the Business Intelligence & Clinical Outcomes Section of the Digital & Data Services Department to recruit a permanent, full time Band 6 ETL Systems Developer. The post is based at Flatts Lane Centre, Normanby, however, the Trust endorses a flexible working model that fully facilitates a blended approach to remote and on-site working
This post will work as part of the Trust's Integrated Information Centre (IIC) team and will have responsibility to support with the design, development, documentation and delivery of Trust wide data warehouse and BI solutions.
For this, we are seeking a customer focused individual with the appropriate technical and analytical knowledge to undertake this key role within the Trust and the successful candidate will have a background in system development, with demonstrable, practical skills in relation to BI systems and associated technologies. The post holder will work with internal and external customers and 3rd party system suppliers to maintain, expand, and improve our BI systems data warehouse (the IIC) for the collection, analysis, validation, presentation, and reporting of activity to ensure that Trust income and resources are effectively managed, and the best possible patient care is achieved.
Main duties of the job
Essential skills & experience required include:
- Excellent communication and customer management skills
- Knowledge and experience of change management process, system upgrade paths, data warehouse development lifecycle, Statistical Process Control (SPC) techniques, development, and deployment of ETL processes to support Key Performance Indicators within a health care setting and an advanced knowledge of ETL processes using IBM InfoSphere DataStage & DataStudio tools
In role, the post holder will be expected to:
- Actively contribute and engage with the IIC Team Agile sprint process to support the delivery of an effective service to our customers.
- Support the development lifecycle of the Trust's dashboards and reports, working with customers, developers and end users to plan, develop and deploy products and features to meet user requirements
- Gather, define and document user requirements that are clear, concise and testable; to translate those requirements to a plan of work that can be understood and implemented by the development team ensuring the development meets the objectives and needs of the customer.
- Provide specialist support for all Trust-wide IIC Systems including co- producing detailed technical design documentation proposals for change controls, supplier upgrade paths and development proposals.
- Assist in providing a systematic and modern approach to the use of information and its associated technology, ensuring that Trust staff gain maximum benefit from its use.
About us
The Digital & Data Services Department is an award-winning, dynamic, and fast-paced environment consisting of over 140 multi-disciplined and talented staff across well structured, supportive, and friendly teams. This leads to many rewarding opportunities for development, self-growth and promotion which is demonstrated by low staff turnover and the significant amount of home-grown talent.
We cover a wide range of specialisms, from Business Intelligence to the provision of IT equipment and everything in-between. No matter where your passion lies, join our brightest minds in supporting our staff deliver the best care for our service users and carers.
You'll join a team where flexibility, wellbeing and respect are highly valued, and you'll be supported to be the best version of you!
Job description
Job responsibilities
Please see the attached standard job description for more details relating to the main responsibilities and essential criteria. If you would like to discuss the role further, please contact us.
Job description
Job responsibilities
Please see the attached standard job description for more details relating to the main responsibilities and essential criteria. If you would like to discuss the role further, please contact us.
Person Specification
Qualifications
Essential
- Educated to Degree standard or equivalent preferably in an informatics related subject OR
- Equivalent experiential learning in the field of Information systems design, development and implementation.
Desirable
- Post graduate qualification standard or equivalent or experiential learning in an informatics related subject
- Data Warehousing course certificate
Experience
Essential
- Significant experience (two years+) in designing and developing Data Marts and ETL routines
- Significant experience (two years+) of using and writing advanced SQL and other system development languages.
- Significant experience (two years+) of using IBMs Data Stage and Data Studio products
- Significant experience of planning and delivering change within an informatics environment.
- Significant experience (two years+) of managing and supporting complex database management systems in busy, confidential settings
- Significant experience (two years+) of change control processes and producing technical specification options
- Experience of gathering and defining user requirements
- Experience of working with large data
- Experience of a customer led service.
- Experience in managing projects or work packages
- Experience of business process redesign
Desirable
- Experience of NHS IT systems and services.
- Knowledge of change management principles (ITIL)
- Working in an NHS environment
- Range of knowledge across the broad Information areas
- Experience in the management of third party suppliers
Knowledge
Essential
- Expert knowledge of the IBM Data Studio product suite
- Expert knowledge data warehouse design principles such as Kimball and Inmon
- Expert knowledge of the development cycle including requirements gathering, design, build, test, release and sign-off
- Expert level of understanding of relational database management systems (RDBS)
- Good knowledge of business process redesign techniques
- Up to date practical knowledge of the management of and use of Software application platforms, e.g. (but not limited to) SQL, IBM, Oracle
- Good numeracy and analytical skills
- Knowledge of facilitation and training delivery techniques.
- Excellent understanding of system change control processes, upgrades paths and release management
- Good knowledge of standard PC applications (e.g. PowerPoint, Word, Excel)
Desirable
- Knowledge of current NHS legislation, policies and procedures
- Knowledge of clinical practices
- Knowledge of corporate practices
- ITIL
Skills
Essential
- Ability to work autonomously, under pressure and meet deadlines using excellent organisational planning skills
- Ability to grasp high level concepts and relate to operational/development detail
- Advanced computer literacy and keyboard skills and technical skills in one or more of the following areas: Data Warehousing
Desirable
- Use of IBM Infosphere Datastage software suite
- Understanding of Cognos and how it integrates with IBM Data Studio
- Facilitation of design workshops with customers
Personal Attributes
Essential
- Able to work in accordance with the Staff Compact and Trust Values and Behaviours.
- Committed to continual quality and service improvement.
- Self-aware and committed to continual professional and personal development. Able to accept and respond positively to feedback from supervision.
- Committed to promoting a positive image of people with mental health conditions and learning disabilities.
- Committed to promoting a positive image of the Information Department and the wider Trust.
- Develop and maintain communication with people about difficult matters and/or in difficult situations
- Monitor and maintain health, safety and security of self and others
- Enable people to learn and develop
- Support equality and value diversity
Desirable
- Develop oneself and others in areas of practice
Person Specification
Qualifications
Essential
- Educated to Degree standard or equivalent preferably in an informatics related subject OR
- Equivalent experiential learning in the field of Information systems design, development and implementation.
Desirable
- Post graduate qualification standard or equivalent or experiential learning in an informatics related subject
- Data Warehousing course certificate
Experience
Essential
- Significant experience (two years+) in designing and developing Data Marts and ETL routines
- Significant experience (two years+) of using and writing advanced SQL and other system development languages.
- Significant experience (two years+) of using IBMs Data Stage and Data Studio products
- Significant experience of planning and delivering change within an informatics environment.
- Significant experience (two years+) of managing and supporting complex database management systems in busy, confidential settings
- Significant experience (two years+) of change control processes and producing technical specification options
- Experience of gathering and defining user requirements
- Experience of working with large data
- Experience of a customer led service.
- Experience in managing projects or work packages
- Experience of business process redesign
Desirable
- Experience of NHS IT systems and services.
- Knowledge of change management principles (ITIL)
- Working in an NHS environment
- Range of knowledge across the broad Information areas
- Experience in the management of third party suppliers
Knowledge
Essential
- Expert knowledge of the IBM Data Studio product suite
- Expert knowledge data warehouse design principles such as Kimball and Inmon
- Expert knowledge of the development cycle including requirements gathering, design, build, test, release and sign-off
- Expert level of understanding of relational database management systems (RDBS)
- Good knowledge of business process redesign techniques
- Up to date practical knowledge of the management of and use of Software application platforms, e.g. (but not limited to) SQL, IBM, Oracle
- Good numeracy and analytical skills
- Knowledge of facilitation and training delivery techniques.
- Excellent understanding of system change control processes, upgrades paths and release management
- Good knowledge of standard PC applications (e.g. PowerPoint, Word, Excel)
Desirable
- Knowledge of current NHS legislation, policies and procedures
- Knowledge of clinical practices
- Knowledge of corporate practices
- ITIL
Skills
Essential
- Ability to work autonomously, under pressure and meet deadlines using excellent organisational planning skills
- Ability to grasp high level concepts and relate to operational/development detail
- Advanced computer literacy and keyboard skills and technical skills in one or more of the following areas: Data Warehousing
Desirable
- Use of IBM Infosphere Datastage software suite
- Understanding of Cognos and how it integrates with IBM Data Studio
- Facilitation of design workshops with customers
Personal Attributes
Essential
- Able to work in accordance with the Staff Compact and Trust Values and Behaviours.
- Committed to continual quality and service improvement.
- Self-aware and committed to continual professional and personal development. Able to accept and respond positively to feedback from supervision.
- Committed to promoting a positive image of people with mental health conditions and learning disabilities.
- Committed to promoting a positive image of the Information Department and the wider Trust.
- Develop and maintain communication with people about difficult matters and/or in difficult situations
- Monitor and maintain health, safety and security of self and others
- Enable people to learn and develop
- Support equality and value diversity
Desirable
- Develop oneself and others in areas of practice
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).
