Business Intelligence Developer

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.

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.