Specialist BI Developer

Purpose of the team is to lead on the strategic planning design and delivery of digital and data technology solutions used across SCA. The team will be key to defining the technology strategy including roadmaps for product developments ensuring our systems remain fit for purpose maximising the value they deliver and enabling our organisation to achieve impact for children. Working in partnership with Transformation Delivery the team will be accountable for planning design and delivery of digital and data technology solutions to Transformation Delivery projects SCI Functions and internal IT functions., Working with members of the global TDIT team the role holder will be responsible for building implementing continuously improving supporting and analysing Business Intelligence (BI) solutions within the organisation. This role will partner with business stakeholders and product owners in order to understand their analytics requirements and implement and maintain BI solutions to meet these needs utilising best practices., * Trains BI Developers analysts and end-users on key analytic and reporting systems and databases. Works with new and existing product and BI Developers to share knowledge in methods of data analysis summarization and presentation.

• Collaborate inclusively with global TDIT team members business stakeholders and product owners to design and deliver comprehensive Business Intelligence solutions that support organisational goals ensuring alignment with stakeholder requirements and best practices.

• Estimate and deliver tasks to agreed prioritisation and timeframes escalate risks and issues in alignment with project and change request delivery methodologies

• Foster a culture of innovation when creating BI Solutions using proof of concepts to demonstrate the new approaches

• Analyse and continuously improve BI systems and processes ensuring they are efficient robust and capable of helping the organisation make data-driven decisions.

• Collaborate with other IT Teams (e.g. testing release management infrastructure architecture) to assist management in implementing and managing changes to the BI environment

• Provide agreed services to business functions (e.g. monthly KPI data to Program Operations team or month end stock reconciliation data to Supply Chain and Finance Teams)

• Maintain and support existing BI solutions working closely with broader Technology Services teams and in alignment with the organisations application support ways of working

• Collaborate with IT Operations team and take ownership of key elements of BI infrastructure e.g. SQL high availability performance and tuning planning and scheduling backups and recovery pans

• Maintain accurate technical documentation, Applications will be reviewed on a rolling basis and the job advert may be closed earlier than advertised subject to the volume of suitable applicants. Please submit your application at your earliest convenience to avoid disappointment. Due to the high volume of applications we receive only shortlisted candidates will be contacted. Candidates who are successfully shortlisted should expect to hear from us within 2 weeks of the advert deadline. Our recruitment process :

• Application review by our recruiting team based on your CV and cover letter

• Two-stage competency-based interviews with the hiring team

• Some recruitmentmay include an additional assessment or case study stage or a third stage interview

• If successful you will receive a conditional offer of employment followed by your contract subject to passing background checks We need to keep children and adults safe so our selection process includes rigorous background checks and reflects our commitment to the protection of children and adults from abuse. All employees are expected to carry out their duties in accordance with our Code of Conduct and all policies and procedures relating to Anti-harassment Health and Safety Safeguarding and DEI and Equal Opportunities. Save the Children does not charge a fee at any stage of the recruitment process. Required Experience : Senior IC

Right to Work : The successful candidate must possess the unrestricted right to work in their current or preferred location for the duration of employment.

Language Requirements : English, * Experience in a variety of BI roles including senior level responsibilities

• Experience delivering BI solutions using Azure technologies such as Azure Data Factory Azure Synapse Azure Databricks as well as SSAS solutions in both Multidimensional and Tabular modes including the ability to script MDX and DAX

• Extensive knowledge of ETL tools such as SSIS and Azure Data Factory

• Extensive knowledge of Reporting tools such as Power BI and SSRS

• In-depth knowledge of MS SQL Serverand / or 2012

• Experience of working with SQL Server databases including creating & modifying T-SQL scripts stored procedures functions triggers writing ad-hoc queries and dynamic SQL

• Extensive knowledge of dimensional modelling and database modelling theories

• Experience of working closely with non-technical staff demonstrating an ability to translate and negotiate non-technical requirements into a detailed technical specification

• Good interpersonal verbal and written communication skills with a proven ability to explain complex technical ideas and problems clearly to non-experts

• Self-motivated enthusiastic and strong problem-solving skills Desirable

• Experience working with finance systems

• Experience working with the full MS BI suite in its different variations IaaS PaaS and SaaS (e.g. Power BI PerformancePoint DataZen etc.)

• Non-profit sector knowledge / experience

• Experience of working within an agile project delivery environment and with geographically dispersed team members

• Cultural awareness and experience of delivering solutions internationally Education and Qualifications Essential

• Demonstrated skills and experience are more important that formal education and qualifications in this role therefore none are considered essential

• Desirable

• Degree in appropriate computing or technology related subject

• Relevant technology specific certifications (e.g. Microsoft certified (MCSE in Business Intelligence)

• Appropriate certification in technology methodologies (e.g. agile)

• Experience with Big Data and Cloud Data Warehousing : Familiarity with tools like Databricks Spark or Snowflake for handling large-scale data integration is beneficial.

• Programming skills in python or R, Business Intelligence,Cognos,SQL,Power BI,QlikView,Microsoft SQL Server,ssrs,Tableau,SSIS,T Sql,Data Modeling,Data Warehouse Employment Type : Full-Time Experience : years

Save the Childrenis the worlds leading organisation for children employing 25000 staff. We save childrens lives. We fight for their rights. We help them fulfil their potential. Through our work in 116 countries we put the most deprived and marginalised children first. We know that great people make a great organisation and that our employees play a crucial role in helping us achieve our ambitions for children. We value our people and offer a meaningful and rewarding career along with a collaborative and inclusive environment where ambition creativity and integrity are highly valued. The work here is challenging but is also immensely rewarding. At Save the Children you will be in good company working with talented like-minded individuals who are determined to ensure that all children survive learn and are protected. Your contribution will help ensure childrens voices are heard at the highest levels and that we achieve our global strategy Ambition for Children 2030 and reach every last child. Diversity Equity and Inclusion and Equal Opportunities DEI is core to our vision values and global strategy. Save the Children is committed to creating a truly diverse equitable and inclusive organisation and one which will support us in our vision to ensure every child attains the right to survival protection development and participation. We are committed to equal employment opportunities regardless of gender sexual orientation race colour ethnic origin nationality disability marital or civil partnership status gender reassignment pregnancy and maternity caring or parental responsibilities age or beliefs and religion. We are committed to diversifying our staff to better represent the communities we serve and actively welcome underrepresented groups to apply. Reasonable adjustments will be made should any candidate invited to interview require this.