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.
#J-18808-Ljbffr
Data Analyst employer: Morgan Law Partners Llp
Morgan Law Partners LLP is an exceptional employer, offering a dynamic work environment in South London where innovation and collaboration thrive. Employees benefit from a strong focus on professional development, with opportunities to enhance their skills while leading significant ERP transformation projects. The company fosters a supportive culture that values expertise and encourages growth, making it an ideal place for those seeking meaningful and rewarding employment.
