Job summary
We have an exciting opportunity for a Senior Developer within the Business Intelligence team.
This is a new role within the team identified to support existing projects and the development and implementation of new cloud-based technologies. You will support and lead on exciting and always interesting projects using your technical expertise as a key member of the development team and have the opportunity to shape and guide existing work and new projects.
This is an exciting opportunity to join a great team with opportunity to develop skills and implement new technologies as we look to develop the data platform and support national developments.
You will have experience working with large datasets and experience of working with a range of data products and platforms.
Midlands and Lancashire Commissioning Support Unit recognises the value serving personnel, reservists, veterans, and military families bring to our business and would encourage people from the armed forces community to apply for our vacancies.
***PREVIOUS APPLICANTS NEED NOT APPLY***
Main duties of the job
You will be working with Lead Developers in the Development team as well as colleagues across the wider Business Intelligence Team. You will provide technical advice and support and the opportunity to implement and improve processes and methodology where necessary.
As a Senior Developer you will have experience working in a similar data environment and delivering complex ETL/ELT processes. You will be able to manage the workload of yourself and the team and be able to communicate issues to a range of audience as required.
You will be a valuable member of the Business Intelligence team, supporting the development of the work the being delivered and maintaining our reputation for excellence.
You will be provided with all the opportunities you require to develop your skills and build your career, both through formal training and hands-on experience.
NHS ML is committed to our process of redeployment at risk members of our existing workforce to new roles. As such, all job adverts are subject to this policy and we reserve the right to close, delay or remove adverts while this process is completed. If you do experience a delay in the shortlisting stage of the recruitment cycle, please bear with us while this process is completed, and contact the named contact if you have any questions.
About us
The NHS is the biggest employer in Europe. It's a world-renowned institution and an exciting place to work, full of challenges and opportunities.
NHS Midlands and Lancashire Commissioning Support Unit (MLCSU) is one of the biggest and best-performing commissioning support units in the country, with among the highest levels of staff and customer satisfaction. We work together as a team of over 1,600 expert staff based across the Midlands and North West to make a difference - for our customers, patients and communities.
Offering a full range of professional services to hospital trusts, local authorities, integrated care systems (ICSs) and other public bodies across the country, our NHS values underpin everything we do.
The development team are a small team within the wider Business Intelligence team responsible for ensuring the data flows and data pipelines operate effectively and efficiently to support onward analysis.
The team is based in various locations, mostly working from home with the ability to utilise desk space at various offices.
In return, we provide a supportive environment in which to learn and develop, with the opportunity to further your skills and career within an exciting and evolving environment.
Joining our inclusive and innovative team comes with a range of benefits including flexible & agile working arrangements, pension scheme and generous annual leave allowance.
Job description
Job responsibilities
Responsibility for the design, implementation, testing, deployment and support of a range of BI solutions.
Design and improvement of ETL/ELT and Delta processing models.
Develop and maintain effective data quality, integrity, validation and monitoring processes.
Responsibility for debugging and troubleshooting SQL and BI tools, systems and software.
Lead the design and development of SSIS packages and Azure Data Factory pipelines.
Build and maintain data pipelines and ensure our products are robust, performant, safe and cost effective.
Ensure that proportionate security and data protection protocols are incorporated into solution designs.
Contribute to the upgrades, migrations, and enhancements of the data warehouse to new platforms and solutions.
Continuous exploration and experimentation of new technologies to improve existing designs, solutions and platforms.
Responsibility for maintaining solutions within source code repositories.
Proactive in the deployment of solutions into a fully managed and maintained operational environment following appropriate release and change control.
Fully document all reports and systems developed.
Ensure compliance with current Information Governance regulations, particularly in relation to the storage & processing of patient identifiable data
Working collaboratively with colleagues to achieve mutual goals and supporting a culture of development and improvement.
Works alongside other developers and business intelligence analysts in carrying out testing activities.
Provides leadership and insight in helping to solve complex issues and developing innovative solutions
Provide leadership and direction across teams and to work in a matrix management approach as projects and programmes require.
Responsible for recruitment and selection of Graduates /Apprentices. Providing management support and supervision as part of their overall development plan
Job description
Job responsibilities
Responsibility for the design, implementation, testing, deployment and support of a range of BI solutions.
Design and improvement of ETL/ELT and Delta processing models.
Develop and maintain effective data quality, integrity, validation and monitoring processes.
Responsibility for debugging and troubleshooting SQL and BI tools, systems and software.
Lead the design and development of SSIS packages and Azure Data Factory pipelines.
Build and maintain data pipelines and ensure our products are robust, performant, safe and cost effective.
Ensure that proportionate security and data protection protocols are incorporated into solution designs.
Contribute to the upgrades, migrations, and enhancements of the data warehouse to new platforms and solutions.
Continuous exploration and experimentation of new technologies to improve existing designs, solutions and platforms.
Responsibility for maintaining solutions within source code repositories.
Proactive in the deployment of solutions into a fully managed and maintained operational environment following appropriate release and change control.
Fully document all reports and systems developed.
Ensure compliance with current Information Governance regulations, particularly in relation to the storage & processing of patient identifiable data
Working collaboratively with colleagues to achieve mutual goals and supporting a culture of development and improvement.
Works alongside other developers and business intelligence analysts in carrying out testing activities.
Provides leadership and insight in helping to solve complex issues and developing innovative solutions
Provide leadership and direction across teams and to work in a matrix management approach as projects and programmes require.
Responsible for recruitment and selection of Graduates /Apprentices. Providing management support and supervision as part of their overall development plan
Person Specification
Experience
Essential
- Experience of working across a full range of Business Intelligence technologies. Including in the development of Azure or other cloud-based technologies, the full set of Microsoft Business Intelligence technologies, working with Secondary Care (SUS) or other complex datasets.
Skills
Essential
- Ability to work without supervision, providing specialist advice across BI functions. Manages own time, working flexibly to prioritise responses to wide range of competing demands.
- Self-motivated, good self-management with an eye for detail and ability to track issues and prioritise when under pressure.
Person Specification
Experience
Essential
- Experience of working across a full range of Business Intelligence technologies. Including in the development of Azure or other cloud-based technologies, the full set of Microsoft Business Intelligence technologies, working with Secondary Care (SUS) or other complex datasets.
Skills
Essential
- Ability to work without supervision, providing specialist advice across BI functions. Manages own time, working flexibly to prioritise responses to wide range of competing demands.
- Self-motivated, good self-management with an eye for detail and ability to track issues and prioritise when under pressure.
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).
