Business Intelligence Developer

Elht; Preston; Híbrido; GBP 32 000 - 52 000; Tempo integral

Resumo da oferta

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

Qualificações

• 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.

Responsabilidades

• 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.

Conhecimentos

SQL

SSIS/SSAS

Data visualization

ETL

Excel

Formação académica

Graduate level qualification in information management or statistical analysis

Ferramentas

SSIS

SSAS

Qlikview

Qlik Sense

Power BI

Descrição da oferta de emprego

All our vacancies are below we would love for you to apply for one of our vacancies and start a fantastic new career with us. Check out our helpful tips on our application process page .

Information aboutwork experience and work shadowing canbe found by clicking here .

One LSC is a new collaborative partnership shared service formed by the five NHS Trusts serving the Lancashire and South Cumbria population of 1.8 million people. We are a shared service run by the NHS, for the NHS and are hosted by East Lancashire Hospitals NHS Trust on behalf of the partner Trusts of the Lancashire and South Cumbria system.

One LSC stands for ‘One Lancashire and South Cumbria’ and reflects the Lancashire and South Cumbria System ambition to have one team serving Lancashire and South Cumbria in a joined-up way. It is jointly run by the five Trusts as a collaborative partnership.

The Trusts that make up One LSC are:

• Blackpool Teaching Hospitals NHS Foundation Trust
• East Lancashire Hospitals NHS Trust
• Lancashire and South Cumbria NHS Foundation Trust
• Lancashire Teaching Hospitals NHS Foundation Trust
• University Hospitals of Morecambe Bay NHS Foundation Trust

One LSC brings together the Digital, Data and Technology, Estates and Facilities, Finance, People Services and Procurement and Logistics services from each of the provider Trusts to create one central community of professionals. Under one leadership team, they will provide services for and on behalf of all Trusts.

The aim is to bring services more closely together so that we can deliver the best service possible to each of our partner organisations. At the core of One LSC delivery is eliminating duplication, removing unwarranted variation, realisation of the benefits of sharing common systems and processes and ensuring we deliver value for money for our partners, our system and, ultimately, for the communities we serve.

Job overview

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.

Main duties of the job

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.

Working for our organisation

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.

Detailed job description and main responsibilities

Further details are available in the detailed Job Description and person specification. The main responsibilities of the post are:

• Design, implementation, testing, deployment, and support of ETL processing solutions.
• Develop expert knowledge of BI implementation methodologies and in‑depth experience with the Microsoft BI ETL Stack (SSIS, SSAS).
• Design, create, implement, and update reference tables as and when required.
• Design and produce thorough and detailed test plans and scripts which are adopted prior to the release of new and / or updated software.
• Works alongside other developers and business intelligence analysts in carrying out testing activities.
• Support troubleshooting SQL and BI tools, systems, and software.
• Transition process to move existing reporting solutions to next generation version with a focus on the delivery of mobile applications
• identify user reporting requirements through a Use a structured evaluation process to identify user requirements
• Create/build complex data structures and analytical presentation to support the provision of relevant information through data visualisation products
• Proactive identification and development of improvements and amendments to existing database structures, queries etc. and responsibility for implementing any changes.
• Develop and implement complex ETL processes.
• Develop multidimensional cubes and tabular models.
• Fully document all reports and systems developed.

Person specification

Qualifications & Education

• Graduate level qualification in information management / statistical analysis or proven experience through practice with detailed evidence of working at this level

Knowledge & Experience

• Working experience of the Microsoft ETL Stack (SSIS and SSAS)
• Working experience of analysing and reporting on large, complex datasets using Microsoft Excel, SQL Server or similar software
• Experience of using appropriate tools for data visualisation and reporting
• Experience of creating and implementing Qlikview/Qliksense applications
• Experience of creating data collection models and extraction processes in an NHS environment

Dear Potential Applicant,

It is important you are made aware of the following as regards your application to East Lancashire Hospitals NHS Trust

• Please note that the salary advertised is for full time hours. If this post is less than 37.5 hours per week, the salary will be pro‑rata. For posts on Agenda for Change pay‑scales, new entrants to the NHS will normally commence on the first pay point of the relevant band.
• This vacancy may close before the closing date if the recruiting manager deems sufficient applications have been received. Therefore it is advised to complete your application as early as possible to avoid disappointment.
• Please ensure you check the email account from which you apply regularly as we will use this to contact you regarding your application.
• Please note that shortlisting is completed anonymously with candidates being assessed against the essential criteria for the post. Therefore only applicants, who can clearly demonstrate how they meet our person specification criteria in their application, will be short‑listed.

Disclosure and Barring Scheme (DBS)

If the role you are applying for is identified as either controlled or regulated activity as defined in in the Safeguarding vulnerable Groups Act (2006) any offer of employment is provisional upon a satisfactory DBS check being obtained.

The healthcare sector is exempted from the Rehabilitation of Offenders Act 1974.

In line with other NHS organisations in the North West Region, the Trust is now passing the charge for undertaking a DBS check on to candidates in the event they are successfully appointed into the post for which they have applied. Candidates can choose whether to pay this over 1-3 months as a deduction from the monthly salary. However, if you are applying for a post as a BANK worker, the payment must be made in full at the time of employment checks. By applying for this vacancy you are agreeing to this undertaking in the event you are successfully appointed.

The cost for an Enhanced DBS, is £45.90 and for a Basic & Standard, this is £24.90 this cost includes a £4.90 admin fee.

This cost is not applicable for a Volunteer post

The Trust is an equal opportunities employer, committed to improving the working lives of our staff and operates a 'Zero Tolerance' policy to aggression, violence, bullying and harassment. In addition, our aim is to help protect children and vulnerable adults by providing a first‑class service to the recruitment of people into positions of trust.

We aim to employ a workforce that reflects the diverse communities we serve.

We welcome applications from everyone irrespective of ethnic origin, gender, age, gender identity, sexual orientation, religion, marital status, disability or social background.

We especially welcome applications from members of our black, Asian and minority ethnic (BAME) communities, as we have identified that ELHT has an under‑representation of BAME employees. Appointments will be made on merit.

Applicants who have a disability and meet the essential criteria for the job will be interviewed if you indicate you wish to be considered under the Guaranteed Interview Scheme.

If you require a reasonable adjustment at any stage of the recruitment process please make the recruitment services team aware as soon as possible. By telephone [phone] or email [e-mail] write to Employment Services, Parkview Offices, Haslingden Road, Blackburn, BB2 3HH

We will contact you by e‑mail to update you on the progress of your application, so please check the e‑mail account that you applied from regularly (including spam/junk).

The Trust is an equal opportunities employer, is committed to improving the working lives of its colleagues and operates a 'Zero Tolerance' policy on aggression, violence, bullying and harassment.

As a recruitment service, our aim is to help protect children and vulnerable