Senior Specialist, BI Developer at Save the Children

Role purpose

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

Principal Accountabilities

• Trains BI Developers, analysts and end-users on key analytic and reporting systems and databases. Works with new and existing product and BI Developers to share knowledge in methods of data analysis, summarization and presentation.
• 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, escalate risks and issues 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)
• 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
Essential

• Experience in a variety of BI roles, including ‘senior level’ responsibilities
• Experience delivering BI solutions using Azure technologies such as Azure Data Factory, Azure Synapse, Azure Databricks as well as SSAS solutions in both Multidimensional and Tabular modes including the ability to script MDX and DAX
• Extensive knowledge of ETL tools such as SSIS and Azure Data Factory
• Extensive knowledge of Reporting tools such as Power BI and SSRS
• In-depth knowledge of MS SQL Server 2019, 2014 and/or 2012
• Experience of working with SQL Server databases, including creating & modifying T-SQL scripts, stored procedures, functions, triggers, writing ad-hoc queries and dynamic SQL
• Extensive knowledge of dimensional modelling and database modelling theories
• 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 

Desirable

• Experience working with finance systems
• Experience working with the full MS BI suite in it’s different variations IaaS, PaaS and SaaS (e.g. Power BI, PerformancePoint, DataZen, etc.)
• Non-profit sector knowledge/experience
• Experience of working within an agile project delivery environment and with geographically dispersed team members
• Cultural awareness and experience of delivering solutions internationally

Education and Qualifications 
Essential

• Demonstrated skills and experience are more important that 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 (e.g. Microsoft certified (MCSE in Business Intelligence)
• Appropriate certification in technology methodologies (e.g. agile)
• Experience with Big Data and Cloud Data Warehousing: Familiarity with tools like Databricks, Spark, or Snowflake for handling large-scale data integration is beneficial.
• Programming skills in python or R