
Senior Financial Modelling Analyst
Job description
The Senior Financial Modelling Analyst is a hands-on technical finance role responsible for rebuilding, controlling and maintaining PoloWorks’ core financial model and supporting data processes. The role combines exceptional Excel and financial modelling capability with strong management accounting knowledge, the ability to incorporate data from multiple sources, and practical use of Microsoft Copilot and other approved AI tools. The role will rebuild and roll forward the Excel model for the new financial year, creating reliable processes for cost allocation, forecasting, vacancies, budget inputs and contract-level reporting. It will make routine updates straightforward for Senior Finance Business Partners (SFBPs), while providing a robust solution until the business moves to a dedicated financial planning platform. Clear data structures, mappings and documentation will support that transition. This role is offered as a 12 month Fixed Term Contract Key Responsibilities
Model assessment, design and rebuild
- Assess and document the existing model, including its source data, dependencies, allocation logic, outputs and control weaknesses.
- Agree the target design and migration approach with Corporate Finance, the GL team, Operations and relevant system owners.
- Rebuild and roll forward the model using transparent, maintainable structures that distinguish source data, controlled inputs, approved planning versions, calculations and controls.
- Establish controlled mappings for employees, contracts, Statements of Work (SOWs), clients and reporting classifications, identifying ambiguous, duplicate and unmatched records.
- Preserve agreed reporting requirements and accounting treatments, with Finance approval for material methodology changes.
- Diagnose and correct broken references, formula errors and data-quality issues rather than masking unresolved problems.
Actual costs and time allocations
- Establish a repeatable process to extract and load actual time allocations from Sage Intacct timesheets, working with Finance, IT and system owners to select an appropriate method.
- Use approved timesheet data to allocate staff costs to contracts and SOWs under an agreed, documented methodology.
- Load actual costs from the general ledger and supporting schedules, reconciling source costs to allocated costs and showing unallocated balances separately.
- Maintain transparent treatment of direct and indirect costs, non-project time, overheads, new business, starters, leavers, contractors and other agreed exceptions.
- Operate validation and exception controls covering missing or incomplete data, invalid mappings, duplicate records and potential cost omissions or duplication.
Forecast allocations, vacancies and planning inputs
- Use historical actual allocations to prepare transparent baseline estimates for future quarters, clearly identifying the period and methodology used.
- Provide simple, controlled inputs for SFBPs to refine future allocations with Operations, while retaining visibility of baseline assumptions and overrides.
- Maintain the logic that translates approved allocations, staffing assumptions and cost schedules into forecasts, protecting actual periods and approved versions.
- Load and cost signed-off vacancies and approved additional FTE roles, enabling SFBPs to allocate them to SOWs and avoiding double counting as roles are filled.
- Import approved schedules supplied by the GL team and SFBPs, validating completeness, mappings, periods, units and phasing.
Contract-level reporting and analysis
- Produce reliable contract- and SOW-level P&Ls covering revenue, allocated costs, bonus, gross margin, gross margin excluding bonus, margin percentages and FTE.
- Maintain consistent actual, budget and forecast reporting by client, division, vertical and sub-vertical, including SOWs appearing in only one reporting version.
- Maintain agreed financial definitions, sign conventions and units, distinguishing new, continuing and ended contracts and percentage changes from percentage-point movements.
- Produce variance and exception reporting for SFBPs to investigate with the business, keeping technical and data exceptions separate from commercial performance issues.
- Maintain configurable, Finance-approved materiality thresholds and traceable exclusions.
Controls, governance and ongoing maintenance
- Maintain reconciliations to the general ledger, timesheet data and supporting schedules, together with an accessible summary of exceptions, owners and required actions.
- Document calculation logic, data sources, assumptions, mappings and operating procedures to support ongoing use and future migration to a dedicated planning platform.
- Maintain version control, change logs, testing evidence and approval of material changes, including controlled parallel runs against agreed existing outputs.
- Train SFBPs to use controlled inputs and outputs, provide cross-training and protect confidential employee, salary and commercial information.
AI, automation and continuous improvement
- Use Microsoft Copilot and other approved AI tools to support model development, review, testing, documentation and process improvement, independently validating outputs before use.
- Use appropriate Excel functionality and approved tools to create repeatable processes for importing, mapping, validating and reporting data, prioritising transparent and maintainable solutions.
Skills, Knowledge and Expertise
Essential
- Exceptional Excel and financial modelling skills, with evidence of rebuilding and maintaining complex financial models.
- Strong experience of importing, combining, cleaning, mapping and validating data from multiple sources within robust Excel models.
- Practical Microsoft Copilot or comparable approved AI experience, including independent validation of outputs.
- Strong management accounting knowledge, including P&Ls, GL structures, staff costs, FTE, cost allocation, budgets and forecasts.
- Experience designing reconciliations, financial controls and useful exception reporting.
- Ability to work collaboratively with Finance, Operations and system owners and challenge unclear requirements constructively.
Desirable
- Sage Intacct experience, particularly timesheet, project or dimensional data.
- Experience in a staff-intensive professional services or contract-based business.
- Experience taking a finance model rebuild through design, testing, implementation, parallel run and handover.
Demonstrates behaviours aligned to the PoloWorks PRIDE values:
- Pioneering - we don’t stand still.
- Responsible - we do the right thing.
- Inclusive - we all play a role.
- Delivery Focussed - we provide services we are proud of.
- Empowering - we equip people to be their best.
Benefits
As well as a competitive salary, discretionary annual bonus, and a minimum 26 days of annual leave (with the option to buy more), you will also get an excellent benefits package, including flexible, hybrid working, private health insurance, life assurance, income protection, enhanced pension contributions, and occupational maternity and paternity pay. You will also have access to company volunteering days, an Electric Vehicle (EV) leasing scheme, an employee assistance programme with retail discounts and savings, a generous employee referral scheme, regular sports and social events, and free Cheltenham bus travel.
Job details
- Published
- November 3, 2026
- Last checked
- November 18, 2026
- Experience
- Senior
- Job source
- pinpoint
- Workplace
- Hybrid · Cheltenham, GB
- First seen
- November 11, 2026
LiftmyCV exclusive data
Poloworks hiring intelligence
Poloworks currently has 14 active jobs tracked by LiftmyCV. 0 new jobs in the past 7 days.
Verified November 18, 2026
Active openings
14
Currently tracked by LiftmyCV
New in 7 days
0
3 new jobs in the past 30 days
Published salaries
—
Not published by this employer yet
Average opening age
148 days
Across 14 active openings
Workplace breakdown
Hiring countries
Top hiring cities
Most in-demand roles
- • Assistant Technician
- • Claims Oversight & Onboarding Manager
- • Client Finance Accounting Technician
- • Deputy Head of Capital
- • Finance Systems Analyst
- • Insurance Administrator
As of November 18, 2026
Hiring insights calculated from active jobs tracked by LiftmyCV.
See how well you match this job
Log in or sign up and Eva will compare your profile with this role, explain your strengths and show what to improve.
Sign up to see your matchAlready have an account? Log inMore at Poloworks
Similar jobs from this company
Across the market
Similar jobs from other companies
Related job searches
Third-party content disclaimer
Full job descriptions are sourced directly from third-party applicant tracking systems (ATS), job boards, recruitment platforms, and employer career pages.
LiftmyCV does not claim ownership of this content or guarantee its accuracy or current availability. All original content is the intellectual property of the respective employers or other rights holders.
LiftmyCV hiring intelligence, availability checks, and related-job recommendations are generated from LiftmyCV data and public sources.
If you prefer, you may apply directly via the original listing for transparency.