The job of a Save the Children’s UK Lead BI Developer is busy and complex.
- Are you passionate about providing high quality data solutions?
- Are you driven to help organisations understand the value good quality data?
- Do you have strong stakeholder management and communication skills?
- Are you motivated by our vision of creating a world where every child doesn’t just survive, but thrives, and can go on to change the world?
If the answers to these questions are yes, we would love to hear from you!
Save the Children UK believes every child deserves a future. In the UK and around the world, we work every day to give children a healthy start in life, the opportunity to learn and protection from harm. When crisis strikes, and children are most vulnerable, we are always among the first to respond and the last to leave. We ensure children’s unique needs are met and their voices are heard. We deliver lasting results for millions of children, including those hardest to reach.
Reporting directly to the BI & Data Manager, the Lead BI Developer will be responsible for developing robust, reliable reports, dashboards and analytics solutions that helps us to understand opportunities, threats, risks and demand so we are able to make informed decisions that will positively impact children’s lives.
The Lead BI Developer will lead on the design, build and delivery of reporting, dashboards and analytics solutions to better enable the Save the Children UK to gain visibility of key management information and insights.
The role holder will be the primary owner of the data warehouse used by the BI & Data Team and take a leading role in ensuring our organisation’s data infrastructure is optimised for enabling data-driven decision making. The data managed will drive depth analysis, data visualisation and daily / weekly reporting across the organisation.
Key duties will include partnering with multiple departments to help drive data driven ways of working, using query tools to transform data into useful insights as well as creating data visualisations and interactive dashboards to service requests from across the organisation.
Sitting in the BI & Data Team, the Lead BI Developer’s role is to support the team’s ambition to connect organisation systems and data silos to deliver a joined-up view of our organisation’s data. This enables the holistic business analysis and reporting of vital KPIs which is critical to our success.
As a rights-based organisation, we are committed to anti-racism and actively opposed systemic oppression of any form. The Senior Media Manager will also support our commitment to celebrate diversity, challenge inequality, and build an inclusive environment for every one of our employees so we can better represent the children we protect.
The Lead BI Developer will have responsibility for leading technical assurance for data and associated system solutions within an agile environment. Key duties will focus on:
- Working with BI & Data Manager, the Data Architect and other scrum and operations members to agree, deliver and document technical solutions
- Being responsible for data definitions, source system identification and connectivity. Performing data validation while working with end users to define business requirements and needs
- Reading and interpreting business needs to proactively identify potential issues and problems
- Creating Dimensional Data models from the new requirement and developing Tabular cube using SSAS where needed
- Developing, building and maintaining all aspects of the BI and Data platform, which include Tibco Data Virtualisation platform and MSBI stack including Power BI Reporting
- With the rest of the team, considering how to increase connectivity between our systems. Building automated workflows and data checks to constantly improve the smooth running of the processes, data integrity and accurate reporting
- Reviewing code and data model of other Developers to ensure the overall code quality and to encourage a collaborative development environment
- Ensuring a globally robust and highly scalable approach to development to support our growing number of global users and services
- Clearly conveying the key insights or "story" the data reveals in a visual format that is grouped, summarised, or formatted to be easily understood and actionable
- Keeping up to date with the latest technologies and methodologies to ensure Save the Children UK stays ahead of the game and can provide suitable solution for the business requirement
- Taking a strategic view on suggesting and delivering new services and service improvement
- Acting as an enthusiastic and effective champion for our organisation’s data
- Significant experience with MS SQL 2012
- Experience in database management
- Significant MS SSAS Tabular experience with the ability to create cubes from scratch
- Data Modelling – Dimensional / Kimball/Star Schema
- OLTP database development
- Experience of solving complex issues through analysis, definition of a clear way forward and ensuring buy in
- Experience of at least one BI reporting or Visualisation tools (e.g. Power BI, SSRS, Tableau or any other similar tools)
- Experience creating Logical and Conceptual Data Models
- Experience working with version control like TFS, Git or any other similar tools
- Ability to understand, interpret and challenge organisation requirements and translate these into a developed solution
- Ability to understand customer requirements and deliver applicable solutions
- A demonstrable commitment to the principles of diversity and inclusion and their practical application and integration in the work environment
- A commitment to Save the Children UK’s aims and core values of accountability, ambition, collaboration, creativity, and integrity
Save the Children UK is committed to diversity and equality of opportunity in all aspects of our work both external and internal. We strive to be an inclusive employer and particularly encourage applications from under-represented groups such as returning parents or carers who are re-entering work after a career break, people who are LGBT+, from Black, Asian and Minority Ethnic backgrounds, with a disability, impairment, learning difference or long-term condition, with caring responsibilities, from different nations and regions, and from less advantaged socioeconomic backgrounds.