Senior BI Analyst Engineer

TN United Kingdom; London; On-site; GBP 50,000 - 80,000; Full time

Job summary

An established industry player is seeking a technical leader to drive business intelligence initiatives and enhance data governance. This role involves leading BI projects, mentoring teams, and engaging with stakeholders to deliver strategic insights. The ideal candidate will possess expertise in advanced BI technologies, including Microsoft Fabric and Power BI, and have a solid understanding of data governance and compliance. Join a dynamic environment that offers extensive benefits and the chance to make a significant impact in the realm of data analytics.

Benefits

41 days holiday

USS Pension Scheme

Life insurance (3x salary)

Cycle to work scheme

On-site gym

Enhanced maternity, paternity, and adoption pay

Qualifications

• Proven experience in business intelligence and data analytics.
• Expertise in data modelling, ETL, and strong SQL skills.

Responsibilities

• Lead end-to-end BI solution development and reporting.
• Engage with senior stakeholders to deliver insights.

Skills

Business Intelligence

Data Analytics

Data Modelling

ETL

SQL (T-SQL, PL/SQL)

Stakeholder Engagement

Data Governance

Power BI (DAX, Power Query)

Azure Data Services

Machine Learning Frameworks

Tools

Microsoft Fabric

Microsoft Purview

SQL Server Analysis Services (SSAS)

Azure Data Factory

Databricks

Job description

Social network you want to login/join with:

Role Overview

This role requires technical leadership, stakeholder engagement, and expertise in advanced BI technologies (including cloud technologies like Microsoft Fabric and Microsoft Purview) to advance UCL’s data modelling, governance, and analytics capabilities.

Key Responsibilities

1. Lead end-to-end BI solution development, including data modelling, ETL, analytics, and reporting.
2. Serve as a technical expert in data modelling, data integration, and data governance to ensure high-quality data for decision-making.
3. Engage with senior stakeholders across UCL to understand reporting needs and deliver insights for strategic decisions.
4. Provide technical leadership and mentoring to junior BI analysts and developers, promoting best practices in data governance, security, and compliance (GDPR, HESA, data protection).

About You

To be considered, candidates should possess a solid mix of skills and experience including:

• Proven experience in business intelligence, data analytics, and enterprise data solutions.
• Expertise in data modelling, ETL, data integration, and strong SQL skills (T-SQL, PL/SQL).
• Experience with Microsoft Fabric (Data Factory, Synapse, Lakehouse) and Microsoft Purview.
• Understanding of CRM data models (Salesforce, Dynamics) and enterprise data architectures.
• Hands-on experience with Power BI (DAX, Power Query) and SQL Server Analysis Services (SSAS).
• Knowledge of data governance, security, and compliance frameworks.
• Strong stakeholder engagement skills and the ability to influence at all levels.
• Experience leading BI projects, mentoring teams, and driving best practices.
• Experience with Azure Data Services (Azure Data Factory, Databricks, Synapse).
• Familiarity with AI-driven analytics and predictive modeling.
• Understanding of higher education data management (HESA, Heidi Plus, student analytics).
• Exposure to Python, R, or machine learning frameworks for advanced analytics.

What We Offer

In addition to exciting opportunities, we offer some great benefits, including:

• 41 days holiday (including 27 days annual leave, 8 bank holidays, and 6 closure days).
• Eligibility for the USS Pension Scheme, a defined benefit scheme with contributions from staff and UCL.
• Life insurance (3x salary).
• Cycle to work scheme and season ticket loan.
• On-site gym.
• Enhanced maternity, paternity, and adoption pay.