Senior BI and Data Engineer

We’re looking for a SQL, data modelling and Azure Data Factory specialist who has a strong background in designing and building innovative BI solutions to join our fast-moving organisation; someone who can deliver with excellence on ambitious projects to revolutionise current data practices.

The role will cover the whole spectrum of BI/Reporting where you will design, build and maintain our central reporting infrastructure along with ingesting data from a variety of sources, cleaning, combining, processing and visualising to end users and other systems.

Working with stakeholders to capture future requirements, manage expectations where required and help open their eyes to the possibilities our data can deliver as we strive for a world-leading STEM education for all young people across the UK.

• SQL and data factory experience are essential.
• Experience implementing a variety of data warehouse design and data modelling techniques, knowing what works best in individual situations.
• Significant experience designing and delivering reporting/BI solutions using modern tools and current best practice 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 a great working 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, Dyamics365 CRM, Microsoft Common data service and flat files
• A knack for managing complex data, and developing insightful visualisations, 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.

At STEM Learning, we work to improve lives through STEM education. We are a purpose-driven organisation, supporting teachers through high-impact professional development, inspiring young people to build confidence and curiosity in STEM, and connecting schools with employers to grow the UK’s future talent. Guided by our values, we focus our effort where it can make the greatest difference - helping all young people, whatever their background, to see themselves in STEM.

• 30 days holidays plus bank holidays
• An additional day off on your birthday
• Access to an attractive pension scheme
• Our full-time hours are 37 hours per week
• Up to 3 paid 'volunteering leave' days per year
• A comprehensive employee assistance programme

Take a look at our benefits brochure to find out more about the benefits we offer.

• Your up-to-date CV including the contact details of two referees (please note, references will not be approached without your permission and will not be taken up until the offer stage)
• A covering letter (no more than the equivalent of 2 sides of A4) explaining your interest in the role and why you think you would be the ideal candidate.