The Save the Children Fund, commonly known as Save the Children, is an international non-governmental organization that promotes children's rights, provides relief and helps support children in developing countries

Read more about this company

Specialist, BI Developer

Job Type

Full Time

Qualification

BA/BSc/HND

Experience

Location

Nairobi

Job Field

Data, Business Analysis and AI , ICT / Computer

Principal 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 monthly end stock reconciliation data to Supply Chain and Finance Teams)
• Proactively identify and escalate 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 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

Essential

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

• 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 monthly end stock reconciliation data to Supply Chain and Finance Teams)
• Proactively identify and escalate 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 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 (eg 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

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