The Specialist, BI Developer will collaborate inclusively with global Technology Development and Information Technology (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. This position is central to enhancing the organization's ability to make data-driven decisions by analyzing, improving, maintaining, and supporting BI systems and processes.
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 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 (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 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, e.g., SQL high availability, performance and tuning, planning and scheduling backups and recovery plans.
- 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 (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
- A BA/BSc/HND qualification is generally expected.
- Demonstrated skills and experience are considered more important than formal education and qualifications for this role; formal education is not considered essential.