Finance Automation Lead

**Company Description**: - This role is part of the European HQ Divisional Finance team and can be based at any of our European Country Head Offices_ **Rentokil Initial plc** Rentokil Initial (RI) delivers services that ‘Protect People, Enhance Lives’. We protect people from the risks of pest-borne disease, the risks of poor hygiene or from injury in the workplace. We aim to enhance lives with services that protect the health and wellbeing of people and the reputation of our customers’ brands. Throughout the world, demand for higher standards of public health, stricter food safety legislation and compliance with workplace safety regulations are driving demand for our service expertise. Rentokil Initial Norway is a global support services company, operating in all of the major economies of Europe, North America, Asia Pacific and Africa: - Rentokil Initial is a FTSE 60 company and operates in over 90 countries with revenues of over £5bn. - We are a ‘people business’ with over 60,000 colleagues. - We offer a wide range of services to businesses, the public sector and residential customers. - Our core market categories are Pest Control and Hygiene/Washroom services. - Market leading positions in major markets - UK, US, Australia, France and emerging Asian and Latin American markets. - Contract based businesses with >85% retention rates. Rentokil Initial has identified three core values that underpin our business - Service, Relationships and Teamwork. By living our values, we are better placed to offer consistently outstanding customer service. This role is part of the European HQ Divisional Finance team and can be based at any of our European Country Head Offices. The role will operate on a hybrid basis with an ad hoc requirement to travel to office locations around the Europe region. As a Finance Automation Lead, you will play a pivotal role in driving digital transformation within our finance department. You will lead the identification, design, and implementation of automation solutions, leveraging advanced analytics and data visualisation tools like Power BI, Anaplan, and Qlik Sense, to streamline processes, reduce manual effort, and enhance accuracy and efficiency. **Key Responsibilities**: **Regional Reporting and Consolidation**: Data Integration and Modeling: - Design and implement data integration pipelines to consolidate financial data from various regional sources. - Develop robust data models to support accurate and timely consolidation of regional financial results. Advanced Analytics and Forecasting: - Utilize advanced analytics techniques to support the identification of trends and anomalies in regional performance. - Leverage selected forecasting solution to build sophisticated financial models and forecasts for regional operations. - Develop early warning systems and alerts to proactively identify potential risks and opportunities. Data Visualization and Reporting: - Create interactive dashboards and reports using Power BI and Qlik Sense (or equivalent system) to provide timely insights into regional performance. - Customize visualizations to meet the specific needs of regional finance teams and executive leadership. - Automate report generation and distribution to streamline the reporting process. Automation and Process Optimization: - Identify opportunities to automate repetitive tasks, such as data collection, validation, and consolidation. - Integrate automation solutions with Power BI, Anaplan, and Qlik Sense to create end-to-end automated processes. - Continuously monitor and optimize automation processes to ensure efficiency and accuracy. **Country Reporting and Forecasting**: Data Integration and Modeling: - Design and implement data integration pipelines to consolidate financial data from various country sources. - Develop robust data models to support accurate and timely country-level financial reporting and forecasting. Advanced Analytics and Forecasting: - Utilize advanced analytics techniques to support the identification of trends and anomalies in regional performance. - Develop early warning systems and alerts to proactively identify potential risks and opportunities. Roll out Anaplan FP&A to the European Counties: - Review the existing Anaplan FP&A model and develop or build the complex modules so that it is appropriate for our needs - Roll out the finalised Anaplan model to the rest of Europe over time implementing at least 6 countries in 2025 - Continuously monitor and optimize processes to ensure efficiency and accuracy. - Develop early warning systems and alerts to proactively identify potential risks and opportunities. - Engage, train and assist new users on both Anaplan and its models - Provide support to the team during the preparation of the company’s budgeting / Forecasting cycles including Budget presentations - Administration of the Anaplan model and system Data Visualization and Reporting: - Create interactive dashboards and reports using Powe