About this role
Salary: £40,000 - 45,000 per year
Requirements
- Experience analysing data and turning it into clear, useful findings
- Strong analytical and problem-solving skills, including confidence in questioning 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
- Ability to explain data and findings clearly to people with different levels of technical knowledge
- Ability to build positive working relationships, listen well and ask useful questions
- Experience working with CRM, ticketing, membership, fundraising or other transactional data
Responsibilities
- Translate business questions into clear analysis, agreeing with stakeholders what a useful answer looks like
- Explore data to identify trends, patterns, opportunities and anomalies, and explain what they may mean
- Produce accurate, timely and relevant recurring and ad-hoc reports and analysis
- 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
Technologies
- Business Intelligence
- CRM
- DAX
- Excel
- Support
- Power BI
- Python
- SQL
More
We are recruiting a Data Analyst to join the Royal Albert Halls business intelligence team. This is a 12-month fixed-term maternity cover role, offered on a hybrid basis, with time working from home and at our historic venue. Our team helps colleagues across the Hall turn data into better decisions by bringing together information from Tessitura, Artifax and other operational sources, then making it useful through analysis, reporting and data products. Our core environment uses Microsoft SQL Server and Power BI alongside established reporting and integration tools. The role offers hands-on development in these technologies, supported by experienced BI colleagues.
last updated 44 week of 2026