At a Glance
- Tasks: Transform data into actionable insights to support lifesaving efforts at sea.
- Company: Join the RNLI, a dedicated organisation saving lives every day.
- Benefits: Make a real impact while enjoying a collaborative and supportive work environment.
- Other info: Work on exciting projects in a dynamic environment with opportunities for growth.
- Why this job: Be part of a team that uses data to drive meaningful change and save lives.
- Qualifications: Advanced SQL skills and experience in data modelling and reporting with Power BI.
The predicted salary is between 50000 - 65000 £ per year.
About us
Our purpose is simple: to save lives at sea. 24 hours a day, every day, RNLI lifesavers are ready to launch to the rescue, 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 to help deliver reporting through a series of strategic projects. The BI team is temporarily expanding to work on a strategic Digital Transformation project, migrating from our existing ERP estate into a new composable architecture and ways of working. We are interested in hearing from people who would be excited to work on projects implementing new systems and leading the design of the new reporting landscape.
This role is all about ensuring our implementation projects run successfully and working closely with our customers to ensure that the right data is available to them as easily as possible. The desire for insight is unstoppable at the RNLI, and the role will include representing the BI Team in Project meetings, selling the enterprise reporting strategy to our customers, gathering requirements and designing reporting products with great user experience baked in at all levels.
You will work with project teams to understand the scope and impact on reporting and to produce achievable delivery plans for those products. The role will work with others in the department to ensure well-structured dimensional data models are delivered in Databricks via a robust semantic/gold layer, and to use these models to deliver the Power BI reporting to meet our customer’s reporting requirements. The role will collaborate closely with others in the team to maintain the award-winning BI products that our people rely on.
Your Role
As a Senior Business Intelligence Developer, you’ll help the RNLI transform the way we consume insight by:
- Representing the BI Team in project meetings, selling the enterprise reporting strategy and ensuring we have the requirements and data to make the reporting a success.
- Turning the needs of customers into well designed reporting products that help users understand their data and drive action.
- Understanding the scope and impact of each project and ensuring there are sensible plans for reporting delivery.
- Working with other experts in the RNLI’s data teams to ensure we consolidate data and 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 and security is considered throughout any systems change in the RNLI, from system design and implementation right through to the insight we deliver.
About You
We are looking for someone with advanced data modelling and SQL developer experience who can gather and interpret complex reporting requirements and multiple business processes to deliver a robust suite of reporting products 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 teams 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 or Azure Databricks, dimensional data modelling, Kimball methodology techniques and building data structures for consumption and presentation via Power BI. You will be confident to represent the needs of the team on the projects and leading the scoping, planning, design and delivery of data products. 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 to deliver business intelligence reporting in Power BI.
- Someone with a vast experience of creating robust data warehouse models to meet complex reporting and analytical needs.
- Someone who enjoys working in a complex project environment.
- Someone who is confident working with data from ERP systems, ideally with experience of working with D365 and Workday.
- Someone who is proficient in writing robust SQL code, designing dimensional data models which are reusable and working within Databricks.
- 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 share their experience with their team and help us to grow and do great things together.
- 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.
Senior Business Intelligence Developer in Poole employer: RNLI
At RNLI, we are not just about saving lives at sea; we are committed to fostering a collaborative and innovative work culture that empowers our employees to thrive. As a Senior Business Intelligence Developer, you will have the opportunity to work on impactful projects that drive our digital transformation, while enjoying a supportive environment that prioritises professional growth and development. With a focus on teamwork and a shared mission, you'll be part of a dedicated team that values your contributions and strives to make a real difference in the world.
StudySmarter Expert Advice🤫
We think this is how you could land Senior Business Intelligence Developer in Poole
✨Tip Number 1
Network like a pro! Reach out to current employees at RNLI on LinkedIn or through mutual connections. Ask them about their experiences and any tips they might have for the interview process. This insider info can give you a leg up!
✨Tip Number 2
Prepare for those tricky questions! Think about how your skills in data modelling and SQL can directly impact RNLI's mission. Be ready to share specific examples of how you've tackled similar challenges in past roles.
✨Tip Number 3
Show your passion for the cause! RNLI is all about saving lives at sea, so make sure to express why this mission resonates with you. A genuine connection to their purpose can set you apart from other candidates.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, it shows you’re serious about joining the team and contributing to their important work.
We think you need these skills to ace Senior Business Intelligence Developer in Poole
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the Senior Business Intelligence Developer role. Highlight your experience with data modelling, SQL, and Power BI, and don’t forget to mention any relevant projects you've worked on that align with our mission at RNLI.
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you’re excited about the role and how your skills can help us transform the way we consume insight. Be sure to connect your past experiences to the specific needs of the BI team.
Showcase Your Team Spirit:We love collaboration! In your application, share examples of how you've worked with others in project environments. Highlight your ability to communicate effectively and ensure everyone is on the same page when it comes to data flow and reporting.
Apply Through Our Website:Don’t forget to apply through our website! It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it shows you’re keen to be part of our mission to save lives at sea!
How to prepare for a job interview at RNLI
✨Know Your Data Inside Out
As a Senior Business Intelligence Developer, you’ll need to demonstrate your expertise in data modelling and SQL. Brush up on your knowledge of dimensional data models and be ready to discuss how you've used them in past projects. Be prepared to explain complex reporting requirements and how you’ve turned them into actionable insights.
✨Showcase Your Project Experience
This role involves working closely with project teams, so highlight your experience in agile project environments. Share specific examples of how you've successfully scoped, planned, and delivered reporting products. Mention any tools like Jira or Azure DevOps that you've used to manage project timelines and deliverables.
✨Communicate Like a Pro
You’ll be representing the BI Team in project meetings, so practice articulating your ideas clearly and confidently. Think about how you can 'sell' the enterprise reporting strategy to stakeholders. Prepare to discuss how you gather requirements and ensure that the right data is available for users.
✨Emphasise Collaboration Skills
Collaboration is key in this role, so be ready to talk about how you work with other data professionals. Share examples of how you’ve communicated dependencies across teams to ensure smooth data flow from source systems to reporting layers. Highlight your ability to maintain high-quality data throughout the ETL process.
