Crynodeb o'r swydd
Teitl cyflogwr
Principal Data Warehouse Developer (Adult Social Care)
NHS AfC: Band 7
Arden & GEM is a leading Commissioning Support Unit (CSU) working across the health and care system in England to provide transformational solutions, business support and clinical services. We work in partnership with other health and care organisations to design, develop and deliver better care for patients that improves health outcomes while making efficient use of resources. Regardless of function, specialism, or location, we are all united in our commitment to improving health and wellbeing for everyone.
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.
Arden & GEM CSU is committed to supporting the redeployment of our at risk employees. In line with our policy, staff at risk may be given preferential consideration to posts that could be considered suitable alternative employment. We reserve the right to close, delay or remove adverts while this process is completed. We apologise if you experience a delay in the shortlisting stage of the recruitment cycle.
Trosolwg o'r swydd
Arden and GEM CSU are actively recruiting a Principal Data Warehouse Developer to support with the delivery of Adult Social Care data. The successful applicant will be responsible for the technical design, development and support of Adult Social Care deliverables using a range of relevant tools and solutions such as Power BI to deliver an effective service to our customers.
Prif ddyletswyddau'r swydd
To ensure Adult Social Care deliveries 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 Flexible Resource Pool Lead and wider Arden and GEM colleagues 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. To support the department’s Senior Manager FRP for the development, processing and support of the Data and Systems end to end delivery to Arden and GEM customers using associated technologies, tools and solutions to deliver an effective service. |
Gweithio i'n sefydliad
We are a multi award-winning organisation that has achieved the prestigious Investors in People Gold Award for ‘We invest in people’ and ‘We invest in wellbeing’ and are passionate about creating an inclusive workplace that promotes and values diversity. We believe that every team member should have the opportunity to contribute and share their ideas.
We reward the hard work and commitment of our people with the following benefits:
- A competitive salary with annual pay reviews
- A generous annual leave entitlement starting at 27 days
- Membership of the NHS Pension Scheme
- Flexible working and family friendly policies, including enhanced parental leave and pay
- A wide range of in-house and external learning and development opportunities
- Access to salary sacrifice and discount schemes
- Access to employee assistance and occupational health services.
Swydd ddisgrifiad a phrif gyfrifoldebau manwl
To be the principal Adult Social Care developer for the AGEM CSU designing and building advanced data solutions. To lead on Adult Social Care documentation ensuring clear documentation on all developments and Information Governance procedures are adhered to. To attend operational meetings as required and be the Flexible Resource Pool lead representative. To read and understand complex technical specification material so these can be further developed into data specifications and to support junior developers when required. 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. |
Manyleb y person
Education / Training / Qualifications
Meini prawf hanfodol
- Professional qualification at degree level in an information related discipline or equivalent experience
- Evidence of continued professional development
Meini prawf dymunol
- Prince 2 qualified
Experience
Meini prawf hanfodol
- Proven experience in the provision of data management systems
- Significant experience in design and modelling of complex NHS data and systems
- Expert Knowledge of industry systems/technologies supporting Data Management/ Business Intelligence
- Significant experience and training in Microsoft SQL Server, SSMS, SSIS, SSAS, ADF, Azure Synapse Analytics and Cloud technologies.
- Experience of developing large scale enterprise DW Solutions utilising the Microsoft BI stack
- Experience of working in a pressured and complex environment requiring prioritisation of workloads and negotiation of delivery timescales
Meini prawf dymunol
- Experience in designing database architecture in an NHS environment
- Experience of designing solutions within Architectural capacity within a formal and structured environment utilising version control
- Experience in delivery of the responsibilities described in the JD
Knowledge
Meini prawf hanfodol
- Specialist knowledge of enterprise level database software
- High level of knowledge of Cloud based technologies.
- Expert knowledge of data manipulation tools and techniques such as Data Factory / SSIS
- Knowledge and experience of implementing information reporting flows between systems and organisations
- Highly proficient in the use of SQL to manipulate and transform large and complex relational datasets
- Knowledge of information governance standards for data security and confidentiality
- Working knowledge of market leading technologies that support Data Management.
- In-depth knowledge of NHS data dictionary, Commissioning datasets NHS Information Systems (e.g. SUS)
- Ability to build Power BI dashboards
Meini prawf dymunol
- Knowledge of market leading technologies that support Data Management.
Dogfennau i'w lawrlwytho
Rhagor o fanylion / cyswllt ar gyfer ymweliadau anffurfiol
- Enw
- David Harrison
- Teitl y swydd
- Senior Manager - Flexible Resource Pool
- Cyfeiriad ebost
- [email protected]
Rhestr swyddi gyda Arden and GEM Commissioning Support Unit yn Gwasanaethau gwyddor iechyd neu bob sector