Collaborate with an amazing team to develop digital systems that make a real difference to young people.
Design, build and maintain the central reporting infrastructure.
Ingest data from a variety of sources, cleaning, combining, processing, and visualising to end users and other systems.
Work with stakeholders to capture future requirements and manage expectations.
Requirements
SQL and data factory experience are essential.
Experience implementing a variety of data warehouse design and data modelling techniques.
Significant experience designing and delivering reporting/BI solutions using modern tools in a Microsoft technology stack.
Significant experience delivering MI solutions through the PowerBI service.
Excellent PowerBI front-end design skills and back-end data manipulation including DAX.
A background in building solutions in an Azure environment with Data Factory, Azure SQL, Power apps/Logic apps and the Common data service.
Experience developing high quality SQL code with knowledge of stored procedures, analytical functions and common table expressions.
A proven background extracting complex data from multiple technologies including MS-SQL/MySQL/Postgres databases, Dynamics365 CRM, Microsoft Common data service and flat files.
Strong interpersonal skills and stakeholder management with the ability to influence, advise and consult at all levels.
Good working knowledge of Python code.
A background working in multi-department, complex business landscapes.
Experience working with and managing senior stakeholders, to CEO level.