Role Summary
As Data Analytics & AI Specialist within our Financial Reporting, Planning and Analysis (FRP&A) team, you will work to transform how we use data for reporting, long range planning, and decision-making.
The FRP&A function is responsible for supporting regional heads with their reporting needs for our entire estate including operating company and property companies (Data Centres).
Reporting into our Head of FRP&A, you will combine advanced Excel, data automation, and AI tools to build scalable models, automate reporting, and ultimately enhance our team’s analytical capability.
As a result, we believe that our role would suit a data analytics specialist who may have had some finance / FP&A exposure.
The Job in More Detail
Key Accountabilities
- Manipulate and transform large datasets into clear, accurate, and actionable financial reports
- Design and maintain KPI dashboards and reporting packs for senior stakeholders
- Ensure consistency and integrity across multiple data sources
- Build and automate complex financial models (e.g. long-range planning, forecasting)
- Develop scalable solutions using:
- Advanced Excel (Power Query, data modelling, complex formulas)
- Automation tools to reduce manual processes
- Integrate data from multiple systems into unified reporting outputs
- Work closely with Head of FRP&A and team, regional finance teams and business to:
- Understand reporting needs
- Ensure outputs support decision-making, not just reporting
- Apply AI tools (e.g. Copilot, automation platforms) to accelerate reporting cycles
- Provide scalable solutions using anaplan
- Identify opportunities to embed AI into workflows
- Upskill the wider FRP&A team on practical AI usage and act as AI champion for the team
- Drive adoption of best practices in data and AI
Key Relationships / Contacts
- FRP&A team
- Regional heads of finance
- Central finance team
- Finance shared service centre
Key Skills / Experience
- Power Query, complex formulas, data transformation
- Experience in FP&A / financial reporting / planning environments
- Proven ability to build automated models and reporting processes
- Strong understanding of how data is used in commercial decision-making
- Experience using AI tools to improve productivity and workflows (e.g. Co-pilot / claude)
- Advance knowledge and experience of financial systems and Excel
- Excellent collaboration and communication skills to convey complex financial information to various stakeholders / functions, including senior levels
- Strong problem solving skills to improve processes and address data challenges
- Profieciency in analysing financial data and providing actionable insight
- Experience in financial modelling supporting long term business planning
- Track record of improving efficiency within finance teams
Advantageous
- Power BI / Anaplan / dashboarding tools
What we offer
Colt DCS is a growing business that is investing in its people. We offer skill development, learning pathways and accreditation to help our people perform at their best, regardless of role and location. In addition to offering competitive salaries and incentive plans, a range of benefits and local rewards packages are offered to staff. Colt DCS recognises and is committed to the importance of a work-life balance.
#J-18808-Ljbffr…