Senior Data Warehouse Developer

This job is brought to you by Jobs/Redefined, the UK's leading over-50s age inclusive jobs board.

Lewisham and Greenwich NHS Trust, (LGT), is a community-focused provider of local and acute care, delivering high-quality services to over one million people living across the London boroughs of Lewisham, Greenwich, and Bexley. We provide whole-life care and are here to support our communities to live healthier lives as well as taking care of them when they need us the most.

Employing almost 7,500 colleagues, affectionately known as Team LGT, we provide services at Queen Elizabeth Hospital in Woolwich, University Hospital Lewisham, and at over a dozen community settings in Lewisham. We also provide some services at Queen Mary's Hospital in Sidcup.

We have recently launched our new vision and values to mark the LGT10 - the tenth anniversary of our Trust forming in 2013. Our trust vision is to be exceptional. In the quality of our patient care; our support for colleagues; and in the difference we make through our partnerships and in our communities.

To achieve this we value Respect, Compassion, and Inclusion; Being accountable over staying comfortable; Listening over always knowing best; and Succeeding together over achieving alone. You can read more about our visions and values here

Our hospitals and community sites provide a wide range of inpatient and outpatient services, as well as emergency and planned care. The Trust is rated as "good" or "outstanding" in over three-quarters of the services inspected by the Care Quality Commission.

Every year our work includes performing 10,000 procedures in our theatres; bringing seven and a half thousand new lives into the world; carrying out 570,000 visits to patients in their homes or communities and providing emergency care for more than 300,000 patients arriving in our busy Urgent and Emergency Departments.

LGT is a centre for the education and training of medical students enrolled with King's College London's GKT School of Medical Education. We are a training centre for nurses, midwives and allied health professionals. We are pioneering new roles that will support the changing needs of our patients and are one of the largest employers of physician associates in the country.

We are committed to working with our partners to deliver the best outcomes for our local communities. This means playing an active role in the South East London Integrated Care System (ICS), and in formal partnerships including the South East London Acute Provider Collaborative, provider partnerships with our local mental health trusts and borough-based boards of the ICS in Bexley, Greenwich and Lewisham.

Job overview

We are looking for a dedicated, enthusiastic, and dynamic individual to join the Trust's Data Warehouse development team.

Working under general direction and using your own discretion to identify and respond to complex issues and assignments, you will be expected to work with the Head of Information Systems and Data Warehouse to ensure best use of resources and to provide support to colleagues in the team and associated areas.

You will be involved in decision making around resource allocation and the delivery of work packages to meet Trust priorities and local and national timeframes.

Main duties of the job

• Support the management of all aspects of Data Administration within the Trust (Acute and Community).
• Using MS SQL, Visual Studio and other database packages, develop and document the Trust data warehouse to a professional standard.
• Where data is NOT available within a corporately supported system (Cerner Millennium, RIO etc.), ensuring that a data extract process is developed, tested, documented and data is fed into the Data Warehouse as required.
• Understand the Commissioning environment and the role of the Data Warehouse as the main data source for Income Recovery.
• Form a deep understanding of wider customer and organizational needs

Working for our organisation

Our people are our greatest asset. When we feel supported and happy at work, this positivity reaches those very people we are here for, the patients. Engaged employees perform at their best and our Equality, Diversity & Inclusion (EDI) initiatives contribute to cultivate a culture of engagement. We have four staff networks, a corporate EDI Team and a suite of programmes and events which aim to insert the 5 aspirations:

1. Improving representation at senior levels of staff with disabilities, from black, Asian, and ethnic minorities background, identify as LGBTQ+ and women, through improved recruitment and leadership development
2. Widening access (anchor institution) and employability
3. Improving the experience of staff with disability
4. Improving the EDI literacy and confidence of trust staff through training and development
5. Making equalities mainstream

Detailed job description and main responsibilities

• Support the management of all aspects of Data Administration within the Trust (Acute and Community).
• Demonstrating excellent communication skills, forming a deep understanding of wider customer and organizational needs.
• Develop and document the Trust data warehouse to a professional standard.
• Where data is NOT available within a corporately supported system (Cerner Millennium, RIO etc.), ensuring that a data extract process is developed, tested, documented and data is fed into the Data Warehouse as required.
• Understand the Commissioning environment and the role of the Data Warehouse as the main data source for Income Recovery.
  • Manage the on-going development and maintenance of required processes regarding the production of routine reports (automated), data storage requirements (volume and housekeeping) and data retrieval processes.
  • Support the development of any processes necessary to convert legacy data into formats that meet the nationally and locally required formats to allow them to be loaded into the Data Warehouse solution.
  • Manage the on-going development and local support of the Data Warehouse solution to meet the Trusts ever growing need for data.
  • Engage in the development and on-going maintenance of a Trust wide Data Warehouse solution, building on current provision whilst ensuring that the solution meets the Trust strategic direction

Person specification

Training & Qualifications

Essential criteria

• Master's level qualification or extensive equivalent experience in a similar role within an NHS Acute Trust
• Other IT Qualification e.g. Microsoft certification

Desirable criteria

• Project Management qualification

Experience

Essential criteria

• Extensive experience working in Data Management within the NHS
• Evidence of expert SQL Programming skills.
• Evidence of extensive experience with Data Warehousing in terms of design, structure, and technologies.
• Evidence of co-ordinating projects and taking ownership of large bodies of work.
• In-depth understanding of the NHS information flows, hospital systems, and applications
• Managing a Pay and Non pay budget
• Experience of delivering Management Information requirements (data extracts, reports, and data sets) to meet contractual deadlines
• Experience of managing SUS submission process and extracting data for SUS validation purposes

Desirable criteria

• Experience of working Cerner Millennium data
• Developing a Data Warehouse across a multi-site NHS Acute Trust
• Working knowledge of Azure stack
• Significant experience of managing staff
• Managing Supplier relationships
• Monitoring compliance with SLA (Service Level Agreement) conditions

We reserve the right to close the post before the stated closing date, please apply early. We do not contact applicants with the outcome of the shortlisting. If you have been shortlisted, you will receive an invite to an assessment day or interview.

As a local employer and anchor institution we work closely with our community to recruit locally and we welcome applications from the widest variety of people to ensure our workforce are reflective of the local communities which we serve. We encourage all suitable candidates to apply including if you are Black, Asian or other ethnic minorities, live with a disability (visible or not) or are LGBT+. We have a number of active staff networks including Disability, LGBT+, Multicultural Inclusion and Women's staff networks to bring staff together and celebrate diversity across our whole workforce.

Please note, not all roles will meet the criteria for a skilled worker visa.

Employer certification / accreditation badges

Applicant requirements

The postholder will have access to vulnerable people in the course of their normal duties and as such this post is subject to the Rehabilitation of Offenders Act 1974 (Exceptions) Order 1975 (Amendment) (England and Wales) Order 2020 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service to check for any previous criminal convictions.

Documents to download

• JD (PDF, 777.2KB)
• Working at LGT (PDF, 4.2MB)