London Metal Exchange
FP&A Transformation & Insights Lead
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
Assistant Vice President – FP&A (Financial Planning & Analysis)
United Kingdom – London
Shift Pattern & Hours
- Standard 40 Hour Week (UK)
- Scheduled Weekly Hours: 40
- Corporate Grade: D – Assistant Vice President
- Reporting Line: UK Division – CFAO Office
- Worker Type: Permanent
About the Role
This role sits within the FP&A (Financial Planning & Analysis) function, combining core financial planning, analysis, and business partnering with a strong focus on enhancing reporting, automation, and data visualisation.
The FP&A professional will drive improvements in how financial information is produced, analysed, and communicated, leveraging tools such as Power BI and Power Automate to:
- Boost efficiency
- Reduce manual processes
- Deliver insightful, decision-ready outputs for senior stakeholders
The role is hands-on, requiring both strong technical FP&A expertise and the ability to design and implement practical improvements in reporting and analytical processes.
Key Responsibilities
FP&A & Reporting
- Lead critical aspects of the monthly management accounts and reporting cycle, ensuring:
- Accuracy
- Timeliness
- High-quality, actionable insights
- Produce and continuously enhance management reporting packs, including:
- Variance analysis
- Commentary for senior stakeholders
- Support financial reporting to Group ExComs and Boards, delivering clear and concise narratives
- Play a leading role in budgeting and rolling forecast processes, including:
- Scenario analysis
- Run-rate analysis
- Provide proactive financial analysis to identify:
- Risks
- Opportunities
- Key business drivers
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
Business Partnering
- Act as a trusted finance partner for stakeholders across the business (e.g., Commercial, Operations, HR, Technology)
- Supply decision support and analysis for >>Director / VP<< level stakeholders
- Translate complex financial data into clear, commercially meaningful insights
- Build strong cross-functional relationships to improve understanding of financial performance
Process Improvement, Automation & Capability Building (~40%)
- Drive the automation and optimisation of FP&A processes, reducing manual effort
- Design and build Power BI dashboards to enhance reporting and enable self-service analytics
- Implement automated reporting solutions using:
- Power BI
- Power Automate
- Excel
- Reduce reporting cycle times and manual interventions, particularly during month-end
- Partner with Technology/Data teams to improve:
- Data quality
- Accessibility
- Reporting infrastructure
- Support and coach team members in:
- Adopting new tools
- Improving data literacy
- Promote a culture of continuous improvement and innovation
- Develop and share best practice approaches in reporting and analysis
Requirements
Academic & Professional Qualifications
- Qualified Accountant (ACA, ACCA, CIMA or equivalent)
- Minimum 2 years of Post-Qualification Experience (PQE), with experience in FP&A or commercial finance roles
Technical Skills & Experience
Required:
- Advanced Excel (financial modelling, complex formulas, data manipulation, ideally VBA)
- Strong PowerPoint skills (ability to deliver board-level presentations)
- Power BI (essential – dashboard development, data modelling with DAX, report automation)
- Experience with ERP systems (e.g., Oracle, SAP, Workday or similar)
- Experience with planning tools (e.g., Hyperion or similar) Desirable:
- Experience with Power Automate or similar workflow tools
- Exposure to SQL or Python for data extraction and automation
- Experience working with large datasets and multiple data sources
Get help with your application
Your very own career expert that helps elevate your application to the next level.
Experience: ✔ Proven experience in FP&A, commercial finance, or management reporting ✔ Demonstrated delivery of process improvement or automation initiatives ✔ Experience replacing or enhancing manual reporting with automated solutions ✔ Track record of working with senior stakeholders and influencing decision-making
Skills & Core Competencies
- Strong financial analysis and modelling capability
- Ability to translate data into clear, actionable business insights
- Process improvement and efficiency-driving experience
- Strong data visualisation and reporting skills
- Excellent stakeholder management and influencing ability
- Problem-solving mindset with attention to detail
- Ability to manage multiple priorities in a deadline-driven environment
Personal Qualities
- Curious and innovative, with an interest in leveraging technology in finance
- Enthusiastic about driving change and improving how finance operates
- Strong team player, capable of building effective relationships
- Resilient and comfortable working under pressure
- High level of ownership and accountability
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills
Location