Data Analyst

Morgan Law; City Of London; Hybrid; GBP 38,000 - 52,000; Full time

Job summary

Morgan Law are recruiting a Data Analyst for the Royal Albert Hall to join the business intelligence team. This 12‑month fixed‑term maternity cover role is hybrid, offering a mix of home and venue work.

The BI team consolidates data from Tessitura, Artifax and other sources, delivering analysis, reporting and data products. You’ll build hands-on capability in SQL Server and Power BI with BI support, turning questions into clear insights.

Qualifications

• Translate business questions into clear analysis, agreeing what a useful answer looks like with the stakeholder.
• Explore data to identify trends, patterns, opportunities and anomalies, and explain what they may mean.
• Produce recurring and ad‑hoc reports and analysis that is accurate, timely and relevant.
• Present findings clearly, including limitations or uncertainty in the data.
• Build and maintain clear, reliable reports and dashboards in Power BI and other appropriate reporting tools.
• Support regular management information and help improve how it is produced.
• Support BI Developers with data preparation, testing and analysis.
• Help gather and document requirements, definitions and acceptance criteria.

Responsibilities

• Turn business questions into clear analysis and actionable insights.
• Create recurring and ad-hoc Power BI reports for stakeholders.
• Present findings with clear communication of data limitations.
• Assist BI Developers with data prep, testing and validation.
• Document requirements and acceptance criteria for BI requests.

Skills

Analytical thinking

Data analysis

T-SQL

Excel

Power BI

DAX/Python/R

Communication

Stakeholder engagement

CRM data

Tools

SQL Server

Power BI

Job description

Morgan Law are excited to be working with the Royal Albert Hall to recruit a Data Analyst as part of their business intelligence team.

The role is for 12 months on a fixed term contract, providing maternity cover in the team. It is a hybrid position, allowing some time working from home and some time working within the historic venue.

The business intelligence team helps colleagues across the Hall turn data into better decisions. Bringing together data from systems including Tessitura (our CRM and ticketing database), Artifax and other operational sources, and make it useful through analysis, reporting and data products.

Their core environment is built on Microsoft SQL Server and Power BI alongside established reporting and integration tools. This role is designed to build hands‑on capability in these technologies with support from experienced BI colleagues.

The purpose of the Data Analyst is to help people across the Hall understand what the data is telling them. You will turn business questions into clear analysis, reliable reporting and practical insight that supports better decisions.

Requirements

• Translate business questions into clear analysis, agreeing what a useful answer looks like with the stakeholder.
• Explore data to identify trends, patterns, opportunities and anomalies, and explain what they may mean.
• Produce recurring and ad‑hoc reports and analysis that is accurate, timely and relevant.
• Present findings clearly, including limitations or uncertainty in the data.
• Build and maintain clear, reliable reports and dashboards in Power BI and other appropriate reporting tools.
• Support regular management information and help improve how it is produced.
• Support BI Developers with data preparation, testing and analysis.
• Help gather and document requirements, definitions and acceptance criteria.

Experience

• Experience analysing data and turning it into clear, useful findings.
• Strong analytical and problem‑solving skills, including the confidence to question unexpected results.
• Working knowledge of T‑SQL, including joins, filtering, aggregation and basic data investigation.
• Confident use of Excel for analysis, validation and working with structured data.
• Working knowledge of Power BI
• Knowledge of DAX, Python or R, or evidence of learning one of these.
• Able to explain data and findings clearly to people with different levels of technical knowledge.
• Able to build positive working relationships, listen well and ask useful questions.
• Experience working with CRM, ticketing, membership, fundraising or other transactional data.