Financial Data Analyst with Vba in London

ATG Entertainment is an exciting, fast-paced company at the heart of live entertainment, and we are looking for a Finance Data Analyst who shares our passion for innovation and continuous improvement.

We are seeking a technically capable and analytically minded individual to join our Commercial Finance team, based at our Shaftesbury Avenue office in London. This role sits at the intersection of finance and data engineering, acting as the primary day-to-day liaison between the Commercial Finance function and the Group’s Data Engineering team.

This role would suit a detail-oriented and technically proficient finance professional with a passion for data, systems, and process improvement. The ideal candidate will be equally comfortable working with financial concepts and data stores and will thrive in a role that bridges the gap between finance and technology.

The successful candidate will play a central role in maintaining and developing the Group’s Commercial Finance data infrastructure, driving data quality and governance, and enabling the Commercial Finance team to report, plan, and analyse with confidence.

This role reports to the Lead Business Partner, Group Commercial & Central Functions and will work closely with the Data Engineering team, Finance Product Owners, and the wider Commercial Finance team.

• Act as the primary day-to-day liaison between the Commercial Finance function and the Data Engineering team, translating finance requirements into data solutions, and managing ongoing development priorities.
• Own the day-to-day administration and ongoing development of the Global Finance Data lake and the Forecasting & Budgeting (FaB) tool, supporting the relevant Finance Product Owners — including user access management, process configuration, and governance practices.
• Liaise with Finance data stakeholders across the Group to troubleshoot system issues, share best practice, and support the continuous improvement of data tools and processes.
• Manage data hygiene and interim manual data feeds, bridging the gap between current system coverage and full automation — ensuring Finance data is complete, accurate, and timely.
• Build and maintain Power BI reports and dashboards, including DAX development, KPI data maintenance, and ensuring reporting outputs meet the analytical needs of the Commercial Finance team.
• Support the smooth running, governance, and development of other Commercial Finance data tools — including TM1 Planning Analytics and Microsoft Fabric — with particular focus on system architecture and the way these tools interact with one another.
• Provide ad hoc data and analytical support to the wider Commercial Finance team as required.
• Support the Commercial Finance team in the transformation project as we automate reporting and embed AI tools.

Your skills, qualities, and experience:

• A strong understanding of key financial principles, including double-entry bookkeeping and P&Ls, with the ability to apply these in a data context.
• A working understanding of data structures and how data flows between source systems, data warehouses, and reporting layers.
• Some exposure to coding and query languages (DAX, SQL, or Python), the ability and appetite to learn is more important than existing depth.
• Demonstrable experience building Power BI reports, with strong knowledge of DAX and an understanding of data modelling best practices.
• Excellent communication skills, with the ability to translate technical data concepts clearly to non-technical finance stakeholders, and vice versa.
• Some experience working with HTML — whether in a reporting, tooling, or web context.
• A proactive, detail-oriented mindset with a natural inclination towards continuous improvement and data quality.
• Strong proficiency in Excel, with the ability to work confidently with complex data sets.
• Preferable: experience with TM1 Planning Analytics, Microsoft Dynamics 365, and/or Microsoft Fabric.
• Experience with D365 and enterprise reporting or data lake tools preferred; prior exposure to a finance function beneficial.
• Must be comfortable operating in a fast-moving, data-rich environment and taking ownership of problems through to resolution.
• Part-qualified or qualified accountant (ACA, ACCA, CIMA) preferred, though candidates from a data or analytical background with strong financial acumen will also be considered.

ATG Entertainment’s values set the tone for how we work, how we treat one another, and the culture we continue to build across the UK and the wider organisation.

Everyone at ATG Entertainment is expected to be flexible and adapt as the needs of the business change, taking on new or different responsibilities as the need arises.

Our Inclusion, Diversity, Equity and Access Mission Statement - A Stage for Everyone. Our stages are a platform for compelling stories – stories that are for all, by all, and of all. We are passionate about the pursuit of true diversity and equality. We strive to make our venues beacons of these ideals in our communities. We are a Disability Confident Committed Employer, which means that we are taking action to ensure that people with disabilities and long-term health conditions feel supported, engaged, and able to fulfil their potential in the workplace.