Healthcare BI Developer — Real-Time Data & Auto-ETL (Remote)

Elht; Preston; Hybrid; GBP 32,000 - 52,000; Full time

Job summary

OneLSC is seeking an experienced BI Analyst to join our expanding team supporting Lancashire Teaching Hospitals Trust and other partner Trusts. You will develop automated ETL solutions, build reporting tools, and leverage the MS BI stack to deliver real-time operational data across multiple clinical domains.

You will be part of ~20 BI professionals, using SQL and complex data sources from electronic patient records, with opportunities to grow skills in various BI areas and contribute to a

Qualifications

• Graduate-level qualification in information management or statistical analysis.
• Experience with the Microsoft ETL Stack (SSIS/SSAS).
• Experience analyzing and reporting on large, complex datasets.
• Experience creating data collection models and extraction processes in an NHS environment.

Responsibilities

• Design, implementation, testing, deployment, and support of ETL processing solutions.
• Develop expert knowledge of BI implementation methodologies and MS BI Stack (SSIS/SSAS).
• Design, create, implement, and update reference tables as required.
• Produce thorough test plans and scripts for releases.
• Collaborate with developers and BI analysts on testing activities.
• Troubleshoot SQL and BI tools, systems, and software.
• Transition reporting solutions to next-gen, including mobile reporting.
• Identify user reporting requirements and build complex data structures for visualization.
• Document all reports and systems developed.

Skills

SQL

SSIS/SSAS

Data visualization

ETL

Excel

Education

Graduate level qualification in information management or statistical analysis

Tools

SSIS

SSAS

Qlikview

Qlik Sense

Power BI

Job description

OneLSC is seeking an experienced BI Analyst to join our expanding team supporting Lancashire Teaching Hospitals Trust and other partner Trusts. You will develop automated ETL solutions, build reporting tools, and leverage the MS BI stack to deliver real-time operational data across multiple clinical domains.

You will be part of ~20 BI professionals, using SQL and complex data sources from electronic patient records, with opportunities to grow skills in various BI areas and contribute to a