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.
Next StepsClosing date for applications: There is no closing date for this appointment; applications will be reviewed on an ongoing basis so early applications are recommended.To ApplyPlease provide us with:- 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.
Top Skills
What We Do
Improving lives through STEM education - we're the largest provider of science, technology, engineering and mathematics (STEM) education and careers support to schools, colleges and community groups across the UK. We host STEM Ambassadors and National Centre for Computing Education. STEM Learning provides intensive residential courses for school leaders, teachers and technicians with our subject experts at the purpose-built National STEM Learning Centre in York. Our unique UK-wide infrastructure for STEM support includes STEM Ambassadors Hubs across the UK, Science Learning Partnerships and Computing Hubs in England, and delivery partners in Scotland, Wales and Northern Ireland, ensuring all schools and educators have access to support. For all things STEM Ambassador, follow @STEMAmbassadors.
