Job summary
We are not trying to show off, but when we say we have a talented and expanding Business Intelligence (BI) team who are building innovative analytics products that help to inform and empower our decision makers we really do mean it....We just want you to join us to complete the picture!
We need you and the wealth of skills and experience you bring as a key BI Developer, to extract knowledge for our clinical and operational teams, hungry for analytics to optimise clinical care and performance and for our vibrant research community. Our collaborative group is working across Lancashire Teaching Hospitals Trust, Lancashire & South Cumbria ICS and beyond and is closely linked to our innovative Data Science Community.
You will join a group of approximately 20 Business Intelligence Analysts and engineers 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 Medicine, Surgery, Women and Children's services and Diagnostics. 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 our mature Electronic Patient Record system. Given our close relations with Data Science and Development, you may have the chance to build skills in cloud-based technologies, languages such as Python or R, working with the research community and publishing papers.
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 Trusts 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.
About us
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 the Trust, 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.
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.
Job description
Job 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
Job description
Job 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
Qualifcations and Education
Essential
- oGraduate level qualification in information management / statistical analysis or proven experience through practice with detailed evidence of working at this level
Desirable
- oRelevant NHS working experience in a BI environment
- Project management qualification
Knowledge & Experience
Essential
- Working experience of the Microsoft ETL Stack (SSIS and SSAS)
- Experience of using appropriate tools for data visualisation and reporting
- Experience of interpreting user need and incorporating into relevant analytical output
- oExperience of developing test plans and scripts
Desirable
- Experience of creating and implementing QlikView/QlikSense applications
- Experience of creating data collection models and extraction processes in an NHS environment
Skills & Abilities
Essential
- Good all round numeracy skills, problem solving abilities and logic.
- Good written and verbal communication skills and the ability to present information logically and concisely.
- Able to establish rapport and foster good working relationships with a wide range of staff groups.
Person Specification
Qualifcations and Education
Essential
- oGraduate level qualification in information management / statistical analysis or proven experience through practice with detailed evidence of working at this level
Desirable
- oRelevant NHS working experience in a BI environment
- Project management qualification
Knowledge & Experience
Essential
- Working experience of the Microsoft ETL Stack (SSIS and SSAS)
- Experience of using appropriate tools for data visualisation and reporting
- Experience of interpreting user need and incorporating into relevant analytical output
- oExperience of developing test plans and scripts
Desirable
- Experience of creating and implementing QlikView/QlikSense applications
- Experience of creating data collection models and extraction processes in an NHS environment
Skills & Abilities
Essential
- Good all round numeracy skills, problem solving abilities and logic.
- Good written and verbal communication skills and the ability to present information logically and concisely.
- Able to establish rapport and foster good working relationships with a wide range of staff groups.
Additional information
Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).
From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).
