Financial Modeller – Hamilton, GlasgowJoin a leading utilities company that champions innovation and service excellence. At Last Mile, we take pride in delivering high-quality solutions across the multi-utility sector. Our Finance team is growing, and we're excited to welcome a talented Financial Modeller to join us.As a Financial Modeller, you'll be part of a hybrid role that combines financial modelling expertise with advanced data science techniques to provide comprehensive financial insights and predictive analytics. The ideal candidate will have a strong background in both finance and data science, with the ability to leverage data-driven approaches to enhance decision-making processes.You will be responsible for owning and pro-actively maintaining the Group financial model, delivering critical insight and enabling the business to make informed strategic decisions. As the sector is expecting unprecedented level of investments in the coming years, this is an exciting opportunity to help shape and make a real impact to the business. What's in it for you as a Financial Modeller?Here at Last Mile, we pride ourselves in providing a great range of benefits including a fantastic amount of annual leave, including a Christmas shut down.25 days holiday, increasing after 2 years by 1 day each year up to 30 days, plus 9 public holidaysHoliday buy schemeDiscretionary bonusEV and ULEV salary sacrifice scheme (subject to minimum length of service)Cycle to work salary sacrifice schemeUp to 7% employer pension contributionVolunteering DayLife assurance (x4 annual basic salary)Retail, travel and leisure discounts via our MilesMore benefits platformRefer a friend incentiveStream – Financial wellbeing platformEmployee assistance programmeCar allowanceHybrid working*Flexible start and finish times for eligible roles*Private medical insurance*Company sick paySome of our benefits are only applicable when you have successfully completed your probation period*Your responsibilities as a Financial Modeller:Developing and maintaining complex financial models to facilitate the accurate and timely consolidation of all financial data from within the group, demonstrating their impact on our financial and financing ratios and overall valuation of the businessThe candidate should be able to gather data from various sources and support in the production and maintenance of data architectures such as databases and other processing systems that populate the financial model.Utilise machine learning algorithms and statistical methods to analyse large datasets.Presenting data and modelling results to a variety of senior internal and external stakeholdersWork alongside external stakeholders on a regular basis in developing valuation reviewsRigorously identifying and resolving any inconsistencies or discrepancies in financial data/modelling, with a continuous improvement mindset, always looking for ways to enhance data quality, efficiencies and reliability of data.Supporting the Group Finance Team in the preparation of group-level financial reports, including board presentations and external reporting requirements.Participating in financial planning and forecasting initiatives to support the group's strategic goalsMust maintain a good knowledge of the changes to the price regulatory model.Leading on financial analysis for shareholders, as required Candidate Requirements:Experience / Knowledge:Experience building complex financial models over long-term planning horizons, ideally within a financial institution, regulated utility or similar organisation with a complex capital structureAbility to analyse large volumes of financial data to identify trends, using statistical methods and key financial and non-financial performance indicatorsProven experience gathering requirements from a range of stakeholders and incorporating these into financial modelsConfident presenting data to a variety of stakeholders, including senior leaders, and able to respond to detailed queriesAdvanced Excel skills including use of MATCH and INDEX, debt modelling, multi-level data structures, output design and a strong understanding of DCF valuation and sensitivitiesStrong programming skills in Python, R or similarExperience working with machine learning techniques and statistical analysisQualificationsBachelor's degree in Finance, Economics, Data Science, Statistics, or a related field. Master's degree preferred.CFA or Chartered Accountancy qualification preferred.Have you got the drive to go to the Last Mile as a Financial Modeller?Apply now!We aim to keep candidates informed throughout the process and encourage you to apply promptly as we may close the vacancy early if sufficient applications are received.About us:Last Mile is one of the largest last-mile multi-utility businesses in the UK. We understand construction and we know utilities. We design, build, own, and manage the 'last mile' of essential utilities infrastructure.With a proven history of delivering multi-utility connections across Great Britain, we provide a full suite of utility infrastructure, including clean heat networks, electricity, gas, water, wastewater and fibre.With a strong track record, deep industry knowledge and solid investor backing, we take a forward-thinking approach to the complex economic, social and environmental challenges of today, to innovate for a better tomorrow.Through Last Mile and our asset adoption businessLast Mile Asset Management, we provide a 'one-stop shop' for new utility connections.We're proud to be both aGreat Place to Work®certified business and a Living Wage Employer, reflecting our commitment to supporting and valuing our people.For further enquiries, contactrecruitment@lastmile.co.uk or visit our website atwww.lastmile.co.ukAt Last Mile, we are proud to be an equal opportunities employer. We consider all applications solely on the basis of skills and experience and actively encourage candidates from all backgrounds to apply.