Senior Business Intelligence Developer

at  RNLI

Salary
£50,000 - £55,000 (dependent on experience)
Contract type
Temporary: Fixed Term Contract or Secondment
Hours
Full Time
Location
Poole, Dorset, England
Location description
Hybrid contract between home and Poole, although we would consider candidates based anywhere in the UK or Ireland, as only a minimal requirement to attend the office, a few times a year (as required)
Closing Date
15-10-2024
Reference
18093
-

ABOUT US

Our purpose is simple, to save lives at sea. Our crews risk their lives every day to save those who are in danger of drowning, and our volunteers are tirelessly raising the funds we need to support them.
We’re looking for a Senior Business Intelligence Developer to join our brilliant Business Intelligence Team and work on our Lifesaving Learning Refresh project which will modernise the RNLI’s learning management system and competency frameworks for our crew. Through this project, our team will provide the reporting required to ensure our crew have the right training and assessments in place to ensure they can safely perform their lifesaving duties.
This role is all about designing and delivering a well-structured dimensional data model and writing the SQL code necessary to provide a robust semantic layer which will be used to deliver our Power BI reporting to meet our customer’s reporting requirements.
You will work closely with our Data Engineering team and systems experts to ensure we consume data from our source systems in the right way, and then work with other Senor Business Intelligence Developers who will use the data model to create the reports for the organisation.

ABOUT YOU

We are looking for someone with advanced data modelling and SQL developer experience who can interpret complex reporting requirements and multiple business processes to deliver a robust semantic layer which underpins our reporting delivered through Power BI.
You will be able to work in an agile manner to deliver benefit to our customers as soon as possible according to project priorities. You will enjoy working with other data professionals and others on the project delivery team to ensure that dependencies across teams are understood and communicated so that data can flow from consumption to presentation layers in a robust and efficient manner.
You will have extensive experience and working knowledge of SSMS, dimensional data modelling, Kimball methodology techniques and building data structures for consumption and presentation via Power BI.
You will be used to working to project timescales and using project delivery tools such as Jira and Azure DevOps.

You’ll be:

• Someone who understands how data should be consumed and structured throughout each level of ingestion and transformation to a presentation layer which will deliver business intelligence reporting
• Someone with a vast experience of creating robust data warehouse models to meet complex reporting and analytical needs
• Someone who enjoys writing efficient and robust t-SQL code to deliver the agreed dimensional data model which will be used to deliver the reporting for the organisation
• Someone with experience of data lineage testing to ensure data quality throughout the ETL process and can check their work as they develop
• Someone who wants to do all of that and in a context that really makes a difference!

So, as a Senior Business Intelligence Developer, you will have the analytical and modelling skills to really make a difference, supporting us in giving people the insight they need to save lives.
To find out if this could be the role for you, please apply via the button shown.

As a Senior Business Intelligence Developer working on our Lifesaving Learning Refresh project, you’ll help the RNLI transform the way we consume insight by:

• Helping to build products that maintains crew competency and compliance with our operational policies which keep our crew safe and effective in their roles so we can continue to perform our lifesaving work
• Giving our crew and operational managers around the coast access to vital information to see when action needs to be taken to keep our crew up to date with the maintenance of their skills and assessments
• Working with other experts in the RNLI’s data teams to ensure we consolidate data and best deliver a robust reporting layer that will meet the organisations reporting and analytical needs now, and in the future
• Making sure we have high quality, structured data flowing from source systems to our reporting presentation layer so we can deliver accurate and timely insight to those that need it
• Ensuring that data quality is considered throughout any systems change in the RNLI, from system design right through to the insight we deliver