Data Analyst

Morgan Law; Greater London; Hybrid; GBP 32.000 - 45.000; Vollzeit

Zusammenfassung

Royal Albert Hall seeks a Data Analyst to join its business intelligence team on a 12-month fixed-term maternity cover. The role is hybrid, combining home-based work with time at the historic venue.

You'll turn business questions into actionable analyses using Microsoft SQL Server and Power BI, building reports and data products to support better decisions across departments.

Qualifikationen

• Experience turning data into clear, actionable insights.
• Strong analytical and problem-solving skills; comfortable questioning results.
• Proficient with Power BI, SQL and Excel for reporting and analysis.
• Ability to explain data and findings to non-technical stakeholders.

Aufgaben

• Translate business questions into clear analyses and insights.
• Explore data to identify trends and anomalies and interpret their meaning.
• Produce recurring and ad-hoc reports and analyses that are timely and relevant.
• Present findings with clear limitations and uncertainty where applicable.
• Build and maintain reliable reports and dashboards in Power BI and related tools.
• Support regular MI and assist BI Developers with data prep and testing.

Kenntnisse

Data analysis

Analytical skills

Problem solving

T-SQL

Excel

Power BI

DAX

Python

Tools

Power BI

T-SQL

Excel

Python

R

Jobbeschreibung

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.