Cost Intelligence Analyst

Job Purpose

See compensation detail in our 'What We Offer' section below.

Remote working - base location flexible within easy access to any of our current main Hubs:  Leeds, Liverpool, Burnley, Newark, Birmingham, Milton Keynes, Gloucester, London.

We are the charity who look after and bring to life 2,000 miles of waterways across England and Wales, because we believe that life is better by water. Every role across the Trust plays it's part in transforming our canals and rivers into spaces where local people want to spend time and feel better, bringing wellbeing benefits to millions.

Our plans to deliver a substantial increase in expenditure on our waterway network to improve its resilience, given the growing impact of climate change, demand that we make improvements in our approach, making changes to how we organise the development, planning and delivery of our work. Drawing from the best examples in the wider industry, we have identified the changes to our processes and organisational structure we need to achieve our ambitious plans. As a result, we have created a new Programme Management Office (PMO) and Cost Intelligence team.  The PMO will define the standards of programme delivery and provide governance, oversight and assurance around the delivery of our expanded work programme.

Working within the Cost Intelligence team, the Cost Intelligence Analyst role is responsible for a number of activities including the development of the Trust’s Excel based corporate estimating and cost capture tools, conducting analysis to help inform effective decision making and developing a standardised method and structure for cost capture across our supply chain.  We’re therefore looking for someone that’s got an advanced understanding of Excel, VBA, SQL, Power App’s / BI / Query, & databases.

Location & coverage

Our Cost Analyst role will be offered on a remote working basis, with a requirement to attend our main hub spaces as and when required for team working and collaborative meetings.  Travel throughout the regional waterway network will also be expected to enable site visits, liaise with team members, and to assess/conduct necessary improvements.

The regularity & flexibility of travel will be discussed further at interview stage.

See our canal network here: (https://canalrivertrust.org.uk/enjoy-the-waterways/canal-and-river-network).

Knowledge, Skills/Qualifications & Experience

Key accountabilities

• Development and maintenance of the Trusts corporate Excel and Power App’s based estimating, cost capture, and cost analysis tools.
• Design and roll out data capture requirements with internal delivery teams and the supply chain.
• Support the development and implementation of cost capture and cost base reporting processing.
• Support the estimating of internally and externally delivered projects.
• Validation and verification of estimates and cost capture submissions completed by Trust employees and Delivery Partners.
• Undertake value for money analysis of framework contract partner performance.
• Benchmarking of works against historical costs and external organisations.
• Tracking of works throughout the estimating process including reporting against SLA‘s.
• Support the roll-out of the Cost Intelligence brand across the Trust.
• Manage workload and ability to work unsupervised.

About you

Technical:

• Working Knowledge of VBA / SQL / Power Query and an advanced Excel user.
• Proven working experience as a data analyst or cost analyst.  Experience of working in an infrastructure or civil engineering organisation would be beneficial.
• Experience in handling complex data sets.
• Technical data modelling, database design development, data mining and segmentation techniques.
• Knowledge of Statistical Techniques such as linear and multinomial regression.
• An understanding of cost codes and cost breakdown structures as well as cost capture templates is desirable.
• Excellent analytical skills to interrogate historical costs and identify key cost drivers.

General:

• Have an analytical mindset and great problem solving ability.
• Ability to meet tight deadlines.
• Have strong organisational skills, with the ability to present information clearly, accurately, succinctly and in a logical manner.
• Proven experience within customer focused environment.
• Have an understanding of current construction issues.
• Be methodical, conscientious and organised.
• Be able to use own initiative.
• Self motivated, especially when under pressure.
• Be a good communicator, both in writing and verbally.

To Apply: click on the "Apply for this job" button and follow the process - complete the application form, upload current CV and supporting statement.

If you have any questions about the role please contact CRT.recruitment@canalrivertrust.org.uk

We reserve the right to close this vacancy early if we receive sufficient suitable applications for the role. Therefore, if you are interested, please submit your application as early as possible.

What We Offer

In addition to your salary of £30,000 - £35,000 (depending on experience), you will benefit from a competitive contributory DC Pension scheme arrangement, great holiday entitlement and numerous other employee benefits, including several salary sacrifice benefits, all of which can be found here (https://canalrivertrust.org.uk/about-us/work-for-us/our-benefits).

Other benefits include:

• Competitive contributory DC Pension scheme arrangement, where we will double your contribution to a maximum of 10%.
• 25 days paid holiday (plus paid Bank Holidays), increasing to 30 days after 5 years.
• Expense scheme.
• Home working status with ‘hub’ facilities available should you need the flexibility to work outside of home.
• Annual £200 personal learning & growth award to spend on any learning related activity.
• Free access to specialist counselling on a range of issues, e.g. health, financial, well-being and domestic matters.
• Access to a range of employee benefits including store discounts, boating holiday discounts and holiday purchase scheme.
• 2 days paid volunteering leave per annum, allowing you to volunteer for a local community project etc.
• Free fishing facilities across our canal network.

At the Trust we care passionately for our waterways, and as importantly, for those who look after and use them. We strongly believe that a diverse workforce brings with it a diversity of ideas, thinking and ways of working which enhances what we do as a Trust. We are striving to represent the diverse communities that we are a part of and welcome applicants from across all sectors of the community.

All candidates will be treated on the basis of their merits, skills and abilities and solely by being assessed against the requirements for the job.

When you join the Canal & River Trust you become a member of an engaged team working to preserve our heritage for future generations. Come and share your passion and knowledge with a team that makes a difference to millions of people every day.

Find out more about us on our website: https://canalrivertrust.org.uk/about-us