Job summary
Leeds
is an attractive and vibrant place to live with an estimated population of over
800,000, and its popularity is such that over the next 25 years the number of
people is predicted to grow by over 15 per cent. Leeds has a bold ambition to
Be the best city for health and wellbeing and the city has developed the
Leeds Health and Wellbeing Strategy, supported by the Leeds Plan to achieve the
best conditions for people in Leeds to live fulfilling lives a healthy city
with high quality services.
This is
an exciting opportunity to join the Leeds Teaching Hospitals Technical
Information Team as one of our Data Warehouse Technical Leads.
We are
looking for an experienced SQL developer with a passion to make a positive
contribution to the business and clinical operation of one of Europes largest
teaching hospitals.
Leeds Teaching Hospitals is committed to our process of redeploying 'at risk' members of our existing workforce to new roles. As such, all our job adverts are subject to this policy and we reserve the right to close, delay or remove adverts while this process is completed. If you do experience a delay in the shortlisting stage of the recruitment cycle, please bear with us while this process is completed, and contact the named contact if you have any questions.
Main duties of the job
The successful candidate will be joining the Digital Information&Solutions service with responsibilities such as:
- Leading data management, preparation and evaluation.
- ETL design, conception, development and management.
- SQL expert for the team and lead during investigations of requirements.
- Drive efficient delivery of business intelligence solutions and reporting outputs.
- Contribute to the continued evolution of the Trusts data and reporting solutions.
Working with business analysts and developers, the post holder will be involved in the full development lifecycle from stakeholder engagement; requirement gathering and data model design; meta data and data quality definition capture; database design, development and data model integration; which will lead into data repository solution implementation and deployment.
The team are embarking on an ambitious long-term cloud computing solution, migrating the existing on-premise Data Warehouse and associated reporting outputs to the Microsoft Azure platform, consolidating reporting outputs to be presented using Power BI.This project is an excellent opportunity for the successful candidate to take their current skills and join us as we develop and upskill our existing team in the use of this new technology.
The role reports to a Technical Information Manager who leads a team of passionate data experts responsible for the development and deployment of modern data analytics solutions for the Trust.
About us
Hybrid
working is available (home and office working) with the base being St Jamess University
Hospital Leeds.
Initial
Tenure is 12 months fixed term but would be made permanent after a successful 12-month
review.
We are
an Equal Opportunities employer and welcome applications from all sections of
society regardless of disability, age, gender, ethnicity, sexual orientation,
race, religion or belief.
Please
note that the closing date is given as a guide. We reserve the right to close
this vacancy once enough applications have been received. You are advised to
submit your application as early as possible to avoid disappointment.
Staff
recruited from outside the NHS will usually be appointed at the bottom of the
pay band.
If you
are successful at interview, then it is normal practice for our recruitment
service to request your references as soon as possible and this may happen
prior to you receiving a written offer letter.
All
references from current and previous employers, will be sought and must cover a
minimum of 3 years employment. Therefore, when completing the reference section
of your application form, please give the address, telephone number and work
email address of each of your current/previous line managers that cover 3 years
employment. Failure to complete this section may result in your application not
being processed.
Job description
Job responsibilities
To assist the provision of technical
solutions in the delivery of a Trust Wide Data Warehouse. To ensure a robust
reporting strategy is implemented for Leeds Teaching Hospitals. To assist in the provision of an information
and analysis service delivering accurate, timely and effectively information
tailored to meet specific needs in support of operational requirements
The post
holder will work as part of the Data Warehouse team to provide assistance to
the Technical Information Managers in delivering a consistent, technical
solution for the integration of data from a myriad of clinical information
systems.
Assist the
Technical Information Managers as required and in co-ordination with other
Senior Information Managers, lead a Team of Information Analysts.
Key result areas are patient access, clinical governance, and
performance management which support the strategic business plan and the
accurate and timely submission of Trust data to the Department of Health, which
has a direct bearing on the revenue of the Trust.
The jobholder will assist in the investigation of a range of
highly complex IM&T issues and is a professional lead on the delivery of
multi-layered solutions to allow the Trust to fulfil its internal and external
information gathering and reporting requirements.
Provide technical support required by Trusts commissioning
processes. This includes the accurate submissions to Secondary Users Service
(SUS) and development of other income dependent data flows, ensuring Trust
income is secured.
Job description
Job responsibilities
To assist the provision of technical
solutions in the delivery of a Trust Wide Data Warehouse. To ensure a robust
reporting strategy is implemented for Leeds Teaching Hospitals. To assist in the provision of an information
and analysis service delivering accurate, timely and effectively information
tailored to meet specific needs in support of operational requirements
The post
holder will work as part of the Data Warehouse team to provide assistance to
the Technical Information Managers in delivering a consistent, technical
solution for the integration of data from a myriad of clinical information
systems.
Assist the
Technical Information Managers as required and in co-ordination with other
Senior Information Managers, lead a Team of Information Analysts.
Key result areas are patient access, clinical governance, and
performance management which support the strategic business plan and the
accurate and timely submission of Trust data to the Department of Health, which
has a direct bearing on the revenue of the Trust.
The jobholder will assist in the investigation of a range of
highly complex IM&T issues and is a professional lead on the delivery of
multi-layered solutions to allow the Trust to fulfil its internal and external
information gathering and reporting requirements.
Provide technical support required by Trusts commissioning
processes. This includes the accurate submissions to Secondary Users Service
(SUS) and development of other income dependent data flows, ensuring Trust
income is secured.
Person Specification
Qualifications
Essential
- Degree or equivalent level qualification in a numerate/analytical discipline or equivalent industry experience and some amount of experience ideally in an NHS information management role.
- Evidence of Continuous Professional Development, i.e. specialist IM&T training/study/research, attendance at relevant conferences/workshops.
Desirable
- Staff Management, including objective setting, appraisal and PDPs.
Experience
Essential
- Expert SQL developer skillset in versions 2012-2019, along with a strong background in developing under the Microsoft SQL Server Stack.
- Excellent Data Preparation knowledge to support Business Intelligence analytics and reporting.
- Experience in the use of SourceVersion Control systems such as GitHub.
- Highly motivated and self-reliant aptitude for learning new technical skills and continuous development.
- Experience of undertaking team leadership, providing direction and influence to ensure completion of activities within a team-oriented, collaborative environment.
- Experience of developing and maintaining effective internal and external relationships at senior levels.
- Ability to prioritise and execute tasks in a dynamic, changing environment and make sound decisions in time critical situations.
- Ability to demonstrate relentless drive, energy and determination to delivery sustainable performance.
- Ability to absorb complex technical information and communicate effectively to all levels, both technical and non-technical audiences.
- Strong organisation and personal management skills. Possess a strong sense of purpose and proactively seek responsibility and ownership.
- Creativity and lateral thinking.
- Proven analytical and problem-solving abilities.
- Ability to understand enterprise solutions.
- High standards of integrity and ethics with a demonstrable strong customer service ethos.
Desirable
- Experience of Azure Synapse, PaaS, SaaS, DevOps
- NHS Data and Information standards Agile methodologies.
Skills & Behaviours
Essential
- Abides by the Trust policy on standards of business conduct.
- Committed to continuous active personal development involving formal training and personal study.
- A team leader, able to build and maintain an efficient and effective team.
- Innovative and adaptable to changing priorities
Desirable
- Understands implications of health and social care policies for the strategic development and delivery of informatics services.
Practical Skills
Essential
- Identifying and resolving complex data problems.
- Multi-disciplinary team working.
- Planning and organisation, prioritisation, strategy formulation and management.
- Training and mentoring.
- Analytical and information consultancy.
- Complex analytical report writing.
Person Specification
Qualifications
Essential
- Degree or equivalent level qualification in a numerate/analytical discipline or equivalent industry experience and some amount of experience ideally in an NHS information management role.
- Evidence of Continuous Professional Development, i.e. specialist IM&T training/study/research, attendance at relevant conferences/workshops.
Desirable
- Staff Management, including objective setting, appraisal and PDPs.
Experience
Essential
- Expert SQL developer skillset in versions 2012-2019, along with a strong background in developing under the Microsoft SQL Server Stack.
- Excellent Data Preparation knowledge to support Business Intelligence analytics and reporting.
- Experience in the use of SourceVersion Control systems such as GitHub.
- Highly motivated and self-reliant aptitude for learning new technical skills and continuous development.
- Experience of undertaking team leadership, providing direction and influence to ensure completion of activities within a team-oriented, collaborative environment.
- Experience of developing and maintaining effective internal and external relationships at senior levels.
- Ability to prioritise and execute tasks in a dynamic, changing environment and make sound decisions in time critical situations.
- Ability to demonstrate relentless drive, energy and determination to delivery sustainable performance.
- Ability to absorb complex technical information and communicate effectively to all levels, both technical and non-technical audiences.
- Strong organisation and personal management skills. Possess a strong sense of purpose and proactively seek responsibility and ownership.
- Creativity and lateral thinking.
- Proven analytical and problem-solving abilities.
- Ability to understand enterprise solutions.
- High standards of integrity and ethics with a demonstrable strong customer service ethos.
Desirable
- Experience of Azure Synapse, PaaS, SaaS, DevOps
- NHS Data and Information standards Agile methodologies.
Skills & Behaviours
Essential
- Abides by the Trust policy on standards of business conduct.
- Committed to continuous active personal development involving formal training and personal study.
- A team leader, able to build and maintain an efficient and effective team.
- Innovative and adaptable to changing priorities
Desirable
- Understands implications of health and social care policies for the strategic development and delivery of informatics services.
Practical Skills
Essential
- Identifying and resolving complex data problems.
- Multi-disciplinary team working.
- Planning and organisation, prioritisation, strategy formulation and management.
- Training and mentoring.
- Analytical and information consultancy.
- Complex analytical report writing.
