Business Intelligence Developer

East Lancashire Hospitals NHS Trust; Preston; Hybrid; GBP 35,000 - 55,000; Full time

Job summary

OneLSC operates a collaborative BI community delivering data management services with a focus on clinical and operational analytics. You will join a team of analysts and engineers supporting Lancashire Teaching Hospitals Trust, working across numerous specialties and data sources from the EPR system.

You will develop automated reporting tools, harnessing the Microsoft BI stack, and contribute to real‑time operational dashboards.

Qualifications

• Proficient in Microsoft BI stack and SQL development.
• Experience building automated data processing and reporting solutions.
• Ability to translate data into actionable insights for clinical/operational teams.

Responsibilities

• Develop automated solutions to move BI from manual to scheduled processing and visualisation.
• Utilise SQL and advanced programming skills to support automation across the service.
• Ensure timely data flow into visualisation tools and reporting solutions for real‑time operational needs.

Skills

SQL

ETL

SSIS/SSAS

Data visualization

Reporting

Tools

Microsoft SQL Server

SSIS

SSAS

Job description

At OneLSC we are a community of Business Intelligence teams working together to deliver data management services to our partner Trusts.

We need you and the wealth of skills you bring as an experienced analyst, to extract knowledge for our clinical and operational teams, hungry for analytics to optimise clinical care and performance and for our vibrant research community.

You will join a group of approximately 20 Business Intelligence Analysts and engineers supporting Lancashire Teaching Hospitals Trust and you will have options to increase and hone your skills in multiple BI related areas covering up to 40 clinical specialties, including Regional specialist services across our clinical divisions. As part of the expanding team, you will use your developer experience to create clear, informative reporting tools, utilising a range of complex data sources derived from the Trusts mature Electronic Patient Record system. You will work collaboratively across the wider One LSC BI community, building your experience portfolio within an expert analytics community.

What can we offer you – access to extensive opportunities for training and development, career progression and an agile/home working model of delivery across all our Business Intelligence services that maximises flexible working for all our staff.

This isn’t just a BI role; it’s a BI role that that has the potential to make a huge impact ultimately for our patients. It’s an exciting opportunity for an experienced developer looking to make their next move within the Business Intelligence field.

Your main duties will include developing automated solutions to support the ongoing transition the Business Intelligence department from manual to automated, scheduled processing and visualisation of data. You will utilise your expert SQL, and highly technical programming skills to support the development of the automation process across the service.

You will ensure the service maximises the timely flow of data into the organisations data visualisation tools and the development of appropriate reporting solutions that meets the ever-increasing organisational need for real time operational data.

Your key skill set will include Microsoft ETL Stack (SSIS and SSAS), analysing and reporting on large, complex data sets and experience of using appropriate tools for data visualisation and reporting.

Our commitment to our staff is to create the best place for them to work so you will be joining a Business Intelligence team that actively supports training and skills development to help you achieve your personal and career development objectives and promotes agile/home working opportunities for all. We are a dedicated, extremely busy, hard-working, and friendly team who will help you to flourish in your new role. Our team are really looking forward to meeting you.

As a member of OneLSC you will be working as part of a collaborative, friendly and caring team of incredible people who are committed to providing excellent care with compassion. We celebrate diversity, encourage everyone to contribute, and you are valued for who you are. Together, we can create your future. You will be supported to achieve your personal goals and build the career you want. You will have access to our world‑class education facilities and award‑winning leadership and learning programmes - so this is the perfect place for you to achieve your potential. Together, we have created a supportive, inspirational, innovative, and vibrant workplace.