Data Analyst

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