Senior Business Intelligence Analyst

The Methodist Church in Britain; Cranfield; Hybrid; GBP 55,000 - 85,000; Full time

Benefits offered by this job

Hybrid working

Flexible working options

Job summary

Cranfield University is seeking a senior BI and data warehouse lead to manage the centralised reporting estate, drive dimensional modelling, and ensure timely HESA and OfS returns.

The role requires strong SSIS and Power BI skills and will partner with stakeholders to turn complex requirements into scalable technical solutions; hybrid working is available.

Qualifications

• Solid experience with Microsoft SSIS and Power BI.
• Strong knowledge of relational database design.
• Experience with dimensional modelling and SQL.

Responsibilities

• Lead the development and management of the Data Warehouse and BI ecosystem.
• Provide a robust, centralised reporting service and data visualisation tools.
• Partner with stakeholders to translate complex business requirements into technical solutions.
• Provide reporting and visualisations to users across the University.
• Lead the technical preparation for mandatory HESA and Office for Students regulatory returns.

Skills

SSIS

Power BI

Relational database design

Dimensional modelling

SQL

Tools

SAP Business Objects

Tribal SITS

Job description

This senior post sits in Cranfield University's business intelligence service, where the holder leads the data warehouse and reporting estate that measures university performance. The work covers a centralised reporting service, data visualisation tools, and the technical preparation of mandatory HESA and Office for Students returns. It suits a specialist in SSIS and Power BI with dimensional modelling and SQL skills, and student record system background (Tribal SITS) is an advantage. Hybrid working is available where the role allows.

What the job involves

• Lead the development and management of the Data Warehouse and Business Intelligence ecosystem
• Provide a robust, centralised reporting service and data visualisation tools
• Partner with stakeholders to turn complex business requirements into technical solutions
• Provide reporting and visualisations to people across the University
• Lead the technical preparation for mandatory HESA and Office for Students regulatory returns

Experience

• Solid experience with Microsoft SSIS and Power BI

Skills & knowledge

• Strong technical knowledge of relational database design
• Dimensional modelling
• SQL

Nice to have

• Experience with the SAP Business Objects platform
• Experience working with student record databases, preferably Tribal SITS
• Experience preparing HESA statutory returns

What’s offered

• Hybrid working combining on-site and remote working, where the role allows
• Flexible working options considered for each role