Business Intelligence Developer

The Methodist Church in Britain; Preston; Hybrid; GBP 42,000 - 58,000; Full time

Benefits offered by this job

Training and development opportunities

Career progression support

Agile and home working model

Education facilities and leadership &

Job summary

The OneLSC Business Intelligence community—part of Lancashire Teaching Hospitals Trust and partner Trusts—is seeking a BI developer to automate BI processing from manual to scheduled workflows. You will design ETL processes, build multidimensional cubes, and deliver data visualisations across up to 40 clinical specialties.

Candidates should have a graduate-level information management or statistics background and hands-on experience with the Microsoft ETL stack.

Qualifications

• Graduate-level qualification in information management or statistical analysis, or proven practice at that level with detailed evidence.
• Experience with the Microsoft ETL stack (SSIS and SSAS).
• Experience analysing and reporting on large, complex datasets using SQL Server or similar.
• Experience using tools for data visualisation and reporting, including BI dashboards.

Responsibilities

• Develop automated solutions to move BI processing from manual to scheduled processing and visualisation.
• Ensure timely data flow into visualisation tools and build reporting for real-time operational data.
• Design, implement, test, deploy and support ETL processing, including complex ETL processes.
• Develop multidimensional cubes and tabular models.
• Create complex data structures and analytical presentations for data visualisation products.
• Identify user reporting requirements through a structured evaluation process.
• Produce test plans and scripts before release of new or updated software, and work with developers and analysts on testing.
• Design, create and update reference tables as required.
• Proactively improve database structures and queries, and implement the changes.
• Support troubleshooting of SQL and BI tools, systems and software.
• Transition existing reporting solutions to a next-generation version with a focus on mobile applications.
• Fully document all reports and systems developed.

Skills

SQL

ETL

Data analysis

SSIS

SSAS

Education

Graduate-level qualification in information management or statistical analysis

Tools

SQL Server

Excel

Job description

A developer post in the OneLSC Business Intelligence community, a group of about 20 analysts and engineers supporting Lancashire Teaching Hospitals Trust and other partner Trusts. The work is automating the move from manual to scheduled data processing and visualisation, using SQL and ETL tools on electronic patient record data. The role offers agile and home working and spans up to 40 clinical specialties. Fit depends on a graduate-level qualification or proven practice in information management, plus Microsoft ETL stack experience.

What the job involves

• Develop automated solutions to move BI processing from manual to scheduled processing and visualisation
• Ensure timely data flow into visualisation tools and build reporting for real-time operational data
• Design, implement, test, deploy and support ETL processing, including complex ETL processes
• Develop multidimensional cubes and tabular models
• Create complex data structures and analytical presentations for data visualisation products
• Identify user reporting requirements through a structured evaluation process
• Produce test plans and scripts before release of new or updated software, and work with developers and analysts on testing
• Design, create and update reference tables as required
• Proactively improve database structures and queries, and implement the changes
• Support troubleshooting of SQL and BI tools, systems and software
• Transition existing reporting solutions to a next-generation version with a focus on mobile applications
• Fully document all reports and systems developed

What’s required

Qualifications

• Graduate-level qualification in information management or statistical analysis, or proven practice at that level with detailed evidence

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
• Experience of using appropriate tools for data visualisation and reporting

Nice to have

• Experience creating and implementing Qlikview or Qliksense applications
• Experience creating data collection models and extraction processes in an NHS environment

What’s offered

• Access to training and development opportunities
• Career progression support
• Agile and home working model across all BI services
• Access to education facilities and leadership and learning programmes