Costing Specialist

Who we are

Together we are Trusted to Serve Scotland. Are you enthusiastic, innovative, and creative and can work collaboratively across different functions of an organisation? Scottish Water’s Strategic Pricing and Cost Analytics teams are looking for an individual who enjoys working with project cost data and is able to interpret, evaluate and form conclusions on the outcome of such analysis.

The Strategic Costing team, who are responsible for using historical cost data to produce cost curves (models) which are then used to establish early project estimates and business plan prices, are planning to increase the depth and range of the cost curves provided to our internal stakeholders. The Cost Analytics team provide quality insights from our cost data by supporting Project Investment Appraisals, via a Cost Intelligence Packs whilst analysing cost trends between Gates, increasing cost analytics database, cost benchmarking and optimism bias metrics capability.

A Costing Specialist is required to work across dual teams to help ensure that the increased workload can be delivered.

In this role, your responsibilities include using our BEA (Benchmark Estimating Analytics) costing system to develop cost curves from historical cost and carbon data, manipulate data from multiple sources and to turn these into meaningful information and insight, using statistical techniques to provide solutions and drive value with analytics, trend analysis, translate conclusions and outputs in a way that can be easily understood by others.

Support the creation of a strong reputation through delivery of required outputs and the building and maintaining relationships with all key stakeholders. It's crucial to follow established processes and procedures to ensure the credibility and robustness of the outputs. Additionally, you'll play a key role in planning, producing, and ensuring compliance with internal SLAs with Finance and Regulation for regulatory returns and audits.

The role holder will also be required to provide support to the Senior Costing Specialist in the maintenance and updating of the Corporate Costing tools.

You will have excellent Excel skills, encompassing complex formulas and the use of Macros/VBA along with strong numeric, analytical, and literary skills, and a proven ability to understand, interpret, and manage large volumes of complex data. A proven ability to extract patterns, trends or models from real-world data-sets and the ability to proactively problem solve and seek continuous improvement in the quality of analysis and service delivery is crucial, as is effective communication to liaise with internal and external stakeholders.

We are also looking for a few ‘nice to haves’. Some technical awareness of the water industry, specific understanding of costing capital projects, the ability to work across disciplines within a specialist team, knowledge of the Scottish Water Business and Delivery Plans, and presentation skills. Ability to create Power BI reports and Power Apps would also be advantageous. This role is mainly remote working, however, travel to our hubs in central belt will be required.

While the work we do is important, we know it’s not the only thing that matters. That’s why we make sure you have everything you need to find a good work-life balance.

• You’ll get plenty of time to recharge with 38 days of holiday every year (including public holidays).
• And you can even buy five more if you need a little extra time.
• You can also take paid time off to volunteer in your community.
• When it comes to major life events we have family-friendly policies around adoption, maternity, and parental leave.
• We embrace flexible working.
• For your future, there’s our defined benefits pension (the ‘know-what-you’ll-get-when-you-retire’ kind), as well as life assurance.
• You will participate in a company bonus scheme.
• Not to mention access to SW Splash – handy rewards that can save you money on holidays, bills, and shopping.

This role will be a Grade 6. If you’re new to Scottish Water, you’ll join us on a starting salary of £37,815. Performance-driven pay…