Midlands and Lancashire Commissioning Support Unit
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.
You will have experience working with large datasets and experience of working with a range of data products and platforms.
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 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.
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
* 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, and working with Secondary Care (SUS) or other complex datasets.
Skills
* Ability to work without supervision, providing specialist advice across BI functions. Manages own time, working flexibly to prioritise responses to a 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.
Midlands and Lancashire Commissioning Support Unit
#J-18808-Ljbffr