Remote BI Developer: Automated ETL & Real-Time Visuals

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

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.