Business Analyst Power BI

Sommet Education; Greater London; On-site; GBP 45,000 - 65,000; Full time

Job summary

A leading education group is looking for a Business Analyst with Power BI expertise to bridge Data Engineering and business stakeholders. The role involves designing data models, creating advanced dashboards, and ensuring data integrity. Ideal candidates will have Microsoft certification in Power BI, strong SQL skills, and a self-starter attitude. The position allows for remote work up to 60% of the time and requires fluency in English. Join us to make a significant impact in the world of education management.

Qualifications

• Strong SQL skills and understanding of performance optimisation in Power BI.
• Ability to test data solutions, troubleshoot issues.
• Fluent written and verbal English.

Responsibilities

• Build and optimise Power BI dashboards and reports.
• Reconcile data between Salesforce, Data Warehouse, and Power BI outputs.
• Conduct weekly audits to ensure data quality.

Skills

Power BI data modelling

DAX programming

SQL skills

ETL tool experience

Interpersonal communication

Education

Microsoft Certified Power BI Data Analyst

Job description

Business Analyst Power BI

Permanent contract / Central London

This position can be remote up to 60% of the weekly working time.

Sommet Education is a unique education group specialised in premium hospitality management and culinary arts, over 8 countries and 22 campuses. The group operates through 5 world-class brands: Glion Institute of Higher Education, Les Roches, École Ducasse, Invictus Education Group and Indian School of Hospitality.

Development, Distinctiveness, Joint Commitment, Openness and Sense of Service are the core values which drive us.

Your Role

You will act as the bridge between Data Engineering and business stakeholders, managing the process end-to-end. Responsibilities include gathering requirements, designing data models, building advanced Power BI dashboards, and ensuring data integrity through regular audits. You will also support training and collaborate closely with teams across Salesforce, Marketing, and Operations.

About You

• Microsoft Certified Power BI Data Analyst (Fabric Analytics Engineer Associate is a plus)
• Expertise in Power BI data modelling, advanced visualisation, and DAX programming
• Strong SQL skills and understanding of performance optimisation in Power BI
• Ability to test data solutions, troubleshoot issues; ETL tool experience is preferable
• Commercial mindset, self-starter approach, and excellent planning skills
• Accuracy, attention to detail, and strong interpersonal communication
• Fluent written and verbal English

Key Responsibilities

• Build and optimise Power BI dashboards and reports
• Reconcile data between Salesforce, Data Warehouse, and Power BI outputs
• Use DAX to enhance analytical capabilities
• Conduct weekly audits to ensure data qualityPrepare ad-hoc reports and support business users with training

If you’re passionate about data, eager to innovate, and ready to make a real difference, we want to hear from you!

Application deadline

11 February 2026

Please Note

We are unable to offer sponsorship for this position. Candidates must be based in the UK and have the right to work in the UK.