Specialist, BI Developer

Save the Children International; United States; Hybrid; GBP 60,000 - 85,000; Full time

Job summary

Save the Children International is seeking a Specialist, BI Developer to design and deliver enterprise BI solutions across a global team. You will partner with stakeholders to translate requirements and build scalable data analytics using SQL Server, SSAS, SSIS and Power BI.

You will also contribute to governance, ensure performance, and support BI across programmes while working in a hybrid/remote model with flexible hours.

Qualifications

• Experience with SQL Server databases: T-SQL, stored procedures, functions, triggers, ad-hoc queries.
• Ability to translate non-technical requirements into technical specs for BI solutions.
• Strong communication to explain complex ideas to non-experts.
• Experience delivering BI solutions in international contexts.

Responsibilities

• Collaborate with global TDIT team, stakeholders and product owners to design and deliver BI solutions.
• Estimate and deliver tasks within agreed timelines.
• Foster innovation using proofs of concepts for BI approaches.
• Analyze and continuously improve BI systems for data-driven decisions.
• Collaborate with IT teams to implement and manage BI changes.
• Provide monthly KPI data to Program Operations and month-end data to Finance.
• Identify and elevate BI risks and issues.
• Maintain BI infrastructure and documentation.

Skills

SQL Server

T-SQL

Power BI

SSIS

SSRS

SSAS

Azure Databricks

Python or R

JIRA

Agile

Stakeholder communication

Non-profit sector knowledge

Education

Degree in computing or technology

Technology certifications

Agile certification

Programming skills in Python or R

Tools

Excel

Power BI (presentation)

SharePoint

Job description

Save the Children International has an exciting opportunity for aSpecialist, BI Developer to join our global team.

Team and Role Purpose

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 analytic requirements, and implement and maintain BI solutions to meet these needs, utilising best practices.

• Job Title: Specialist, BI Developer
• Reports To: Manager, BI Development
• Work Pattern: Hybrid/Remote with flexible working options available
• Location: Any approved Save the Children International office location. For a full list of locations that Save the Children International can hire in, please visit: SCI Careers
• Required Time Zone: Europe, WCA, ESA, MENAEE Time Zones (UTC/GMT + / - 3 hours)
• Right to Work: The successful candidate must have the right to work in the country where the role is based, for the duration of employment.
• International Travel: up to 5%
• Remit: Global

Principal Accountabilities

• 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 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)
• Proactively identify and elevate any technical risks/issues related to BI
• 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

Experience and Skills

• Experience of working with SQL Server databases, including creating & modifying T-SQL scripts, stored procedures, functions, triggers, writing ad-hoc queries and dynamic SQL
• 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
• Cultural awareness and experience of delivering solutions internationally
• Keen to learn new technologies, especially in BI
• Experience of working with Microsoft’s BI technology stack SSIS, SSRS and/or SSAS (tabular and multidimensional models), ADF, Azure Databricks
• Experience working with BI presentation tools (e.g. Excel, Power Pivot, Power View and Power BI)
• Experience working with BI reporting in SharePoint
• Experience working with finance systems
• Non-profit sector knowledge/experience
• Experience of working within an agile project delivery environment and with offshore project team members
• Experience working with JIRA

Education and Qualifications

• Demonstrated skills and experience are more important that formal education and qualifications in this role therefore none are considered essential
• Degree in appropriate computing or technology related subject
• Relevant, technology specific certifications
• Appropriate certification in technology methodologies (e.g. agile)
• Programming skills in python or R

Working at Save the Children International

Save the Children is the world's leading organisation for children, employing ~25,000 staff. We save children's 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 children's 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.

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 recruitment may 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 proces