Overview
In this BI-focused role you help turn data into actionable insights for clinical and operational teams across the Trust. You will build automated data processing and reporting solutions that feed real-time operational dashboards and mobile-friendly outputs. Working within a vibrant BI community, you’ll apply your development skills to a mature Electronic Patient Record data environment to support patient care improvements. This position offers training, career progression, and flexible/home-working options in a collaborative, high-impact team.
Pay / Benefits
- training and development opportunities
- career progression
- agile/home working model
- flexible working
- supportive team culture
- world-class education facilities (mentioned)
Responsibilities
- Design, implement, test, deploy, and support ETL processing solutions
- Develop expertise in BI methodologies and the Microsoft BI ETL Stack (SSIS, SSAS)
- Create and update reference tables as required
- Draft comprehensive test plans and scripts for releases
- Collaborate with other developers and BI analysts on testing activities
- Troubleshoot SQL and BI tools, systems, and software
- Transition reporting solutions toward next-generation delivery, including mobile applications
- Identify user reporting requirements using structured evaluation processes
- Build complex data structures and analytics for visualization products
- Proactively improve and modify database structures and queries
- Develop and implement complex ETL processes
- Develop multidimensional cubes and tabular models
- Fully document all reports and systems developed
Key requirements
- Graduate level qualification in information management / statistical analysis or proven equivalent experience
- Working experience of the Microsoft ETL Stack (SSIS and SSAS)
- Experience analyzing and reporting on large, complex datasets using Excel, SQL Server or similar
- Experience using tools for data visualization and reporting
- Collaborative team player
- Proactive problem-solving mindset
- Attention to detail
- Microsoft ETL Stack (SSIS, SSAS)
- SQL and handling large/complex datasets
- Data visualization and reporting tools
Business Intelligence Developer in Preston employer: National Health Service
Betsi Cadwaladr University Health Board is an exceptional employer, offering a supportive and collaborative work environment for healthcare professionals in North Wales. With a commitment to employee development and a focus on compassionate care, staff have access to continuous professional development opportunities and the chance to make a meaningful impact in both acute and community paediatrics. The Health Board's integrated approach ensures that employees are part of a dynamic team dedicated to improving health outcomes for the local population.
