Robert Walters are proudly partnering with our market leading, well established, growing and progressive client based near Hemel Hempstead to source an experienced Commercial (Pricing) Analyst with proven ADVANCED Microsoft Excel skills. This is not an accounting role and a lot of data manipulation will be involved so someone with strong numerical skills and ability to synthesise meaning from data is needed. The ideal candidate would have Tableau experience and experience with subscription products as well as real estate.
The Role:
– Perform all calculation related to the billing of site fees including annual inflationary increases, capital investment increases, new customer site fees.
– Responsible for ensuring that all changes are reflected correctly and can be correctly billed.
– Undertake calculations for the annual fee budget and measure performance against budget and propose amendments where relevant.
– Calculation of rates for all current and future products with reference both to tariff and fees.
– Receive data on competitor fees and rates and benchmark against the wider market.
– Maintain site fee inflation model and site fee budget model at Group level.
– Communicate fee increases and amendments.
– Review rate of sale of new customers versus site fee.
– Maintain rolling forecast with formal updates via quarterly strategy days.
– Set letting rates for Fixed lettings and future letting products as relevant.
The Candidate:
– ADVANCED Excel Skills required.
– Strong Numerical skills and familiarity with Excel and data visualisation.
– Strong Communication skills and ability to work cross- functionally.
– Attention to detail and ability to synthesise meaning from data.
– Ability to influence across lines of business.
– Experience working in a commercial environment.
– Tableau Experience highly desirable.
– Experience working on cross-functional initiatives
On Offer:
Circa £(phone number removed) per annum, plus bonus. Hybrid working available.
Robert Walters Operations Limited is an employment business and employment agency and welcomes applications from all candidates