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