Job summary
To support the Data Management Leads of the BI Systems team whose purpose is to manage all aspects of processing 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.
Main duties of the job
To be the principal developer for the BI Systems 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 BI Systems 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.
About us
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.
Job description
Job responsibilities
To support the Data Management Leads of the BI Systems team whose purpose is to manage all aspects of processing 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.
Job description
Job responsibilities
To support the Data Management Leads of the BI Systems team whose purpose is to manage all aspects of processing 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.
Person Specification
Education./Training/Qualifications
Essential
- Professional qualification at degree level in an information related discipline or equivalent experience.
- Evidence of continued professional development.
Desirable
- Post graduate qualification
- Prince 2 qualified
- Cloud certification
Experience
Essential
- 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, 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 and negotiation of delivery timescales
Desirable
- Experience in designing database architecture in a complex 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
Person Specification
Education./Training/Qualifications
Essential
- Professional qualification at degree level in an information related discipline or equivalent experience.
- Evidence of continued professional development.
Desirable
- Post graduate qualification
- Prince 2 qualified
- Cloud certification
Experience
Essential
- 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, 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 and negotiation of delivery timescales
Desirable
- Experience in designing database architecture in a complex 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
Disclosure and Barring Service Check
This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.
Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).
From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).
Additional information
Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).
From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).
