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.

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:

• 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.
• Widening access (anchor institution) and employability.
• Improving the experience of staff with disability.
• Improving the EDI literacy and confidence of trust staff through training and development.
• 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.
• 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 Trust's 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:

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

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