Job Description

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

Team and Job 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, maximizing the value they deliver and enabling our organization 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. 

Role purpose

Working with members of the global TDIT team, the role holder will be responsible for building, implementing, continuously improving, supporting and analyzing Business Intelligence (BI) solutions within the organization. This role will partner with business stakeholders and product owners in order to understand their analytical requirements and implement and maintain BI solutions to meet these needs, utilizing best practices.

Job Title: Specialist, BI Developer

Reports To: Manager, BI Development

Work Pattern: Hybrid/Remote with flexible working options available 

Contract Length: Permanent

Grade: P3

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

Time Zone (that the role holder must be available to work in): Europe, WCA, ESA, MENAEE, LAC Time Zones

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

International Travel Requirements: up to 5%

Main Accountabilities

• Collaborate inclusively with global TDIT team members, business stakeholders, and product owners to design and deliver comprehensive Business Intelligence solutions that support organizational goals, ensuring alignment with stakeholder requirements and best practices.
• Estimate and deliver tasks to agreed prioritization 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 
• Analyze and continuously improve BI systems and processes, ensuring they are efficient, robust, and capable of helping the organization make data-driven decisions.
• Collaborate with other IT Teams (eg testing, release management, infrastructure, architecture) to assist management in implementing and managing changes to the BI environment
• Provide agreed services to business functions (eg monthly KPI data to Program Operations team or month end stock reconciliation data to Supply Chain and Finance Teams)
• Proactively identify and scale 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 organization’s application support ways of working
• Collaborate with IT Operations team and take ownership of key elements of BI infrastructure eg. SQL high availability, performance and tuning, planning and scheduling backups and recovery pans
• Maintain accurate technical documentation

Experience and Skills

Essential

• 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

Desirable

• 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 (eg. Excel, Power Pivot, Power View and Power BI)
• Experience working with BI reporting in SharePoint
• Experience working with finance systems
• Non-profit knowledge/experience sector
• Experience of working within an agile project delivery environment and with offshore project team members
• Experience working with JIRA

Education and Qualifications 

Essential

• Demonstrated skills and experience are more important than 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
• Appropriate certification in technology methodologies (eg agile)
• Programming skills in python or R