Solutions Developer (BI) at Save the Children

KEY AREAS OF ACCOUNTABILITY

• Provide the organisation with accurate and timely BI solutions based on requirements gathered through business partnering activities
• Maintain and support existing BI solutions
• Proactively source new and innovative solutions that provide clear business value and construct 'proof of concepts' to demonstrate the new solutions
• Proactively identify any technical project risks/issues related to BI
• Estimate and deliver BI project tasks to agreed prioritisation and timeframes
• Support the IT Service Delivery team with the BI reporting environment
• Assist product owners in designing, agreeing, implementing and managing changes to the BI environment
• Maintain accurate technical documentation
• Communicate data and insights

QUALIFICATIONS AND EXPERIENCE

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
• Proven understanding of Data Modelling and Analytics
• Experience of working with Microsoft's BI technology stack SSIS, SSRS, SSAS (tabular model), Power BI, DAX, Power Query, Excel.
• 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
• Experience maintaining source control in Git
• Strong experience with various Software Development Life cycles (SDLC) methodologies: Agile or Standard waterfall initiatives
• Proven experience working with various Project Management practices and disciplines
• Demonstrated strong interpersonal skills to augment a close working relationship with cross functional teams
• A history of designing and implementing reporting solutions that are both functional and engaging
• Meticulous attention to detail
• Commitment to Save the Children's aims, values and principles including willingness to abide by and enforce the Child Safeguarding policy.

Desirable

• Experience building data analytics solutions using Azure Synapse Analytics, Azure Data Factory, Azure Data Bricks, HD Insight.
• Proficiency in Python/Scala/Spark SQL
• CRM/ERP knowledge
• Non-profit sector knowledge/experience
• Experience of working within an agile project delivery environment and with offshore project team members
• Stream Analytics
• Event Hubs
• Cosmos DB
• Machine Learning