About the role
This role requires technical leadership, stakeholder engagement, and expertise in advanced BI technologies (including cloud technologies like Microsoft Fabric and Microsoft Purview) to drive UCL’s data modelling, governance, and analytics capabilities forward.
As the Senior BI Analyst Developer you will get the opportunity to lead end-to-end BI solution development, including data modeling, ETL, analytics, and reporting. In tandem, you will act as a technical expert in data modeling, data integration, and data governance, ensuring high-quality data for decision-making
Equally important is liaising with senior stakeholders across UCL to understand their reporting needs and deliver insights that drive strategic decisions. Provide that technical leadership and mentoring to junior BI analysts and developers, ensuring best practices in data governance, security, and compliance (GDPR, HESA, data protection).
About you
To be considered for this role candidates will need a solid mix of the solid skills and experience:
1. Proven experience in business intelligence, data analytics, and enterprise data solutions.
2. Expertise in data modeling, ETL, and data integration techniques.
Strong SQL skills (T-SQL, PL/SQL) for query optimization and performance tuning.
3. Experience with Microsoft Fabric (Data Factory, Synapse, Lakehouse) and Microsoft Purview.
4. Deep understanding of CRM data models (Salesforce, Dynamics) and enterprise data architectures.
5. Hands-on experience with Power BI (DAX, Power Query) and SQL Server Analysis Services (SSAS).
6. Knowledge of data governance, security, and compliance frameworks.
7. Strong stakeholder engagement skills, with the ability to influence at all levels.
8. Experience leading BI projects, mentoring teams, and driving best practices.
Desirable Skills
9. Experience with Azure Data Services (Azure Data Factory, Databricks, Synapse).
10. Familiarity with AI-driven analytics and predictive modeling.
11. Understanding of higher education data management (HESA, Heidi Plus, student analytics).
12. Exposure to Python, R, or machine learning frameworks for advanced analytics.
What we offer
As well as the exciting opportunities this role presents we also offer some great benefits some of which are below:
13. 41 Days holiday (including 27 days annual leave 8 bank holiday and 6 closure days)
14. This post is eligible for USS Pension Scheme defined benefit scheme
15. Staff contribute and UCL will contribute
16. Life insurance is included (3x salary)
17. Cycle to work scheme and season ticket loan
18. On-Site nursery
19. On-site gym
20. Enhanced maternity, paternity and adoption pay
21. Employee assistance programme
22. Discounted medical insurance