Principal Data Warehouse Developer

  • Arden and GEM Commissioning Support Unit
  • Derby DE1, UK
  • 06/08/2022
Full time Data Engineering Artificial Intelligence Biostatistics Data Warehouse

Job Description

Job details

Salary
£40,057 - £45,839 a year
Job type
Full-time

Full Job Description

Who are we:
Arden & GEM is an established business within the NHS. It has a wide customer base including NHS England, ICS’s and CCG’s, Local Authorities, and a range of other Healthcare providers. With offices throughout the Midlands, North West, and South East we cover a core geographic patch that extends throughout the country.
Our services are built on a strong foundation of experienced people who build great relationships, a commitment to NHS values and a thorough understanding of our clients and the challenges they face.
There is an opportunity within the Data Team as part of the Data and Systems function. This role will involve supporting the Data Management Leads whose purpose is to manage all aspects of processing datasets for Arden and GEM customers. The successful applicant will be responsible for the technical design, development and support of the DSCRO / Data Management service and associated technologies, tools, and solutions to deliver an effective service to Arden and GEM customers.
To support the Data Management Leads of the data team whose purpose is to manage all aspects of processing national and local datasets for Arden and GEM customers. To be responsible for the technical design, development and support of the DSCRO/ Data Management service and associated technologies, tools and solutions to deliver an effective service to Arden and GEM customers.
To ensure data flows are designed and developed in accordance with specifications describing customer and internal requirements. Maintain high levels of quality through management of an assurance process working closely with other members of the team and Dataset Leads.
To support the Data Management Leads in the strategic planning of current and future technological solutions to ensure optimal performance, researching and reviewing recognised best practice and upcoming technological enhancements. To manage and provide expert advice and support to internal teams and external clients including prioritising work plans, making best use of available resource and embedding quality throughout the service.
Our vision
Our vision is to work as partners with commissioners and providers to deliver unprecedented transformational change. We enable localities to 'deliver better with less' by developing the integrated systems and models of care needed, with efficiency and outstanding customer satisfaction.
  • To be the principal developer for the data team designing and building advanced data processing solutions.
  • To design, develop and implement large scale data warehouse solutions using different types of data streams.
  • To support the data team into future planning of the data warehouse system for example by ensuring that system procurements, migrations and upgrades are not considered without due considerations taking place.
  • To support and develop resilience and business continuity plans for database upgrades.
  • To produce clear documentation on all developments.
  • To read and understand complex technical specification material so that these can be further developed into data specifications for developers.
  • To evaluate new products and technologies and consider their usage as solutions within the development work program.
  • To support the Data Management Leads by converting business requirements into system specifications and design, by a process of business analysis.
  • To work in matrix management with the other teams in the CSU to ensure that technologies integrate and that data is delivered in a usable and timely manner.
  • To continually strive to improve the effectiveness, performance, ease of access and understanding of existing information systems, incorporating a mix of leading edge and legacy systems.
  • To provide support on established products to end-users and provide technical advice and training to all users where required.
  • To ensure that all products are thoroughly tested before final release to the end user.
  • To design and produce documentation of developed systems both in terms of user manuals and formal schema.
  • To provide effective training, knowledge transfer and support, to other team members and wider AGEM colleagues.
  • The post holder is required to comply with and actively promote the Organisation’s equal opportunities policy.
  • Other ad-hoc duties required to meet the needs of the service.