Junior Finance Analyst London, England
Job description
About ExCeL London
We are a world class venue based in the heart of London’s Royal Docks, hosting over 400 events and welcoming 4 million visitors annually. We recognise the role that every member of our team plays in our success. We pride ourselves on placing our people at the heart of our business, with a positive culture that inspires, develops, recognises and rewards our team.
You can read more about working with us here: https://www.excel.london/working-at-excel
Purpose of the role:
The role holder works across the business to assist in the preparation of key financial information to ensure that the business makes well-informed decisions to for future stability, growth and profitability. The Junior Finance Analyst helps to establish and maintain a range of reports to assist the business and support the Financial Planning & Analysis (“FP&A”) team across month end reporting, budgeting and forecasting as well as business intelligence. The role requires a thirst for knowledge, attention to detail as well as strong number skills.
Key Responsibilities:
1. Month End:
Preparation and reconciliation of month end files across all areas of the business
Assist with variance analysis and commentary against Budget, Forecast and Prior Year by event.
Prepare monthly utilisation and yields providing insights on variances to prior years.
Prepare and distribute event P&Ls including variances to Budget, Forecast and prior years
Be responsible for running all final month end reports and ensuring they reconcile
Update forecast files with actuals including P&L, event budgets and overheads.
Provide visitor number reporting
Identify and implement process improvements and automation
Support Finance Analysts with preparation of management pack and ADNEC reporting
2. Sales Reporting:
Maintain Event ID matrix for Exhibitions and Conference & Events (“C&E”) on an ongoing basis.
Work with sales team to confirm all events are correctly recorded on Ungerboeck, flagging issues and ensuring they are resolved in a timely manner.
Work with sales team to develop best practise and improve data quality.
Assist in creation and amendment of Power BI reports.
3. Budgeting and Forecasting:
Assist in the budgeting and forecasting process supporting the Finance Analysts.
Update Budget and Forecast templates with latest events list and ensure prior year comparisons are provided where applicable.
Update sales forecast based on latest data warehouse prior to weekly meetings with FP&A and Sales
Liaise with Sales Support and Sales to understand the space (GSMD) and footfall assumptions included in the Budget/Forecast and the implications this has on yield and utilisation.
Assist with data gathering requests
4. Business Intelligence/Systems
Assist in development of Jet Reporting capabilities to provide automation to processes and increase accuracy in reports
Provide support in building excel based modelling and identify ways to improve existing files. Present data clearly and professionally formatted.
Work with Systems team and Finance Analyst to assist development of Business Intelligence reporting and dashboards. Ensure that any financials reported reconcile.
Identify automation that can be made through working closely with Business Systems team, understand limitations and be able to resolve these.
5. Ad Hoc
Develop an in-depth knowledge of relevant industry information.
Produce event specific reports/assessments that will add value to the business.
Provide cover for Finance Analysts and an understanding of their day to day duties.
Self-learning to improve and build upon Excel, Jet Reporting and Power BI skills to an advanced level
Providing ad hoc requests for historical data
Core Competencies:
Knowledge of the Business - Is in touch with the needs of internal & external customers and is alive to threats and opportunities. Considers the long-term business implications of issues and situations. Is aware of the main thrust of competitor activity and has a strategic business focus. Provides leadership in placing our customers at the forefront of our objectives.
Results Focus & Profit Delivery - Works well towards challenging objectives, has high standards for self and others, meets agreed deadlines. Allocates time to longer-term activities, always looking for opportunities to do things faster, better, more cost effectively, eliminating non-value added activities. Is clear-minded in pursuit of objectives. Achieves/ exceeds targets by focussing on key deliverables, ensuring plans are followed through. Regularly measures performance against key success indicators.
Negotiation Skills - Uses listening skills to effectively understand the needs of the other party, gathers information and views and enters into a dialogue designed to reach agreement on an equal level between the parties. Adept at objection handling, using strong influencing skills to persuade others rounds to their own way of thinking or to achieving a planned outcome to a business deal.
Has a competitive drive that results in the achievement of well negotiated deals/outcomes, whilst maintaining a commercial perspective.
Communications Skills - Excellent verbal and written communication skills and ability to glean information on the phone, confident communicating with commercial stakeholders (demonstrate business acumen and financial awareness).
Team Orientation/ Achieving with Others - Able to build relationships with team, company colleagues and customers. Positively and actively engages with and supports the activities of the team in the achievement of their objectives and freely shares knowledge and information.
Planning and Organising - ability to time manage; ensuring tasks are completed to deadline and to agreed standards.
Work Quality: The ability to deliver consistently high-quality work under pressure and within deadlines, exceptional attention to detail and ensures all work is thoroughly checked.
Attitude: Self-motivated individual achieving deliverables, displaying a positive, helpful and approachable attitude towards colleagues and customers. Smart and presentable appearance.
Adaptability & Versatility: Flexible and dynamic attitude with strong customer awareness skills, able to adapt quickly and calmly when emergency situations arise. A flexible individual capable of evolving with the changing requirements of a developing role.
To ensure we cultivate a truly great place to work we expect all our people to uphold the values we express as our ‘ways of working’, you can find more detail about these here: https://www.excel.london/working-at-excel
Experience:
Proficient user of full Microsoft Office suite (Excel intermediate to advanced level – sumifs/vlookups/pivots)
Confident/accurate user of databases – able to adapt to new systems quickly
Numerate
Problem Solver
Logical thinker
Inquisitive mind
Ability to construct reports and analyse data presenting in an easily digestible format
A highly organised individual
Critical Thinker.
Education:
Relevant Degree preferable
