FPA Data Automation Analyst

RLB International; Greater London; Hybrid; GBP 55,000 - 90,000; Full time

Benefits offered by this job

Hybrid Working

Healthcare options

APC and mentoring

Season ticket loan

Job summary

RLB International in London is seeking an FPA Data Automation Analyst to join the Finance team. You will build scalable reporting frameworks, manage ETL of ERP data, automate workflows (Alteryx) and support long-range planning and multi-jurisdiction cash flow modelling.

You will partner with IT and BI teams, improve data quality, and help standardise tools to enable data-driven decision making. A strong FP&A background with advanced Excel and ETL experience is essential.

Qualifications

• Proven FP&A experience within finance/accounting.
• Experience in a consultancy organisation with multiple currencies.
• A strong finance education with experience in the wider finance team outside of FP&A.
• Advanced Excel capabilities (formulas, Power Query, VBA) and ability to automate manual processes.
• Strong experience with ETL and data tools such as Alteryx, Knime, SQL, R, Python, Tableau, Power BI.
• Excellent data communication and presentation skills, with the ability to convey financial concepts to stakeholders.
• Prior experience with Dynamics 365 (Finance & Operations and Project Operations) and ERP implementation desirable.

Responsibilities

• Building scalable reporting frameworks to meet the demands of a fast-growing business.
• ETL of ERP data for use in business reporting, ensuring accuracy and reliability.
• Manage and maintain process automation workflows used by the Finance team and wider organisation (Alteryx).
• Develop and maintain models for long range planning, budgeting, forecasting, and multi jurisdiction cash flow modelling.
• Partner with the wider business to understand needs and develop standardised commercial tools for data-driven decisions.
• Monitor and improve data quality, completeness, and integrity across multiple source systems.

Skills

Advanced Excel

Power Query

VBA

ETL

Alteryx

Knime

SQL

R

Python

Tableau

Power BI

Education

Finance education

Tools

Dynamics 365

ERP

Job description

FPA Data Automation Analyst

Department: Finance

Employment Type: Permanent - Full Time

Location: London

Reporting To: Marc Doiron

Description

Title: Senior Associate Project Manager

Sector: Finance Location: London (With Hybrid Working)

Why RLB?

At RLB, we live by four simple ideas: Truth, Trust, Together, Tomorrow. Four values that live at the heart of RLB. A place where People Make Progress.

We value your skills, talents and unique perspectives – we think they are priceless.

Bring them to RLB and you’ll be empowered to shape our future and your career in new and meaningful ways.

We’ll give you opportunities to work on some of the most ambitious and exciting projects currently being designed and developed in the built environment sector.

You’ll continue to learn and advance as everyone who works for us is provided with a tailored training programme. Our mentoring and reverse mentoring schemes will enable you to share your expertise while gaining fresh insights.

What makes RLB unique is our inclusive culture. As an independent, employee-owned business, teamwork and collaboration lies at the heart of everything we do. Hybrid and flexible working arrangements and family-friendly policies are just some of the ways we invest in employee wellbeing.

Join us and you will thrive personally as well as professionally.

Overview of role

Reporting directly to the FP&A Transformation Lead, the business is looking for an FP&A Associate to assist with building and maintaining the finance reporting functions with a focus on delivering a high level of output and quality while working closely with FP&A, IT / business intelligence teams and the finance team.

Role Responsibilities

• Building scalable of reporting frameworks to meet the demands of a fast-growing business.
• Extraction, transformation, and loading (ETL) of ERP data for use in business reporting, ensuring its accuracy and reliability.
• Manage and maintain process automation workflows used on a routine basis by the Finance team and wider organisation (Alteryx).
• Develop and maintain models for long range planning, budgeting, forecasting, and multi jurisdiction cash flow modelling.
• Partner with the wider business to understand their needs, challenges, and goals and develop and standardise commercial tools to foster a culture of data driven decision making.
• Monitor and improve data quality, completeness, and integrity across multiple source systems.

Person Specification: Experience:

• Proven track record within FP&A function, with significant experience and background in finance / accounting.
• Proven experience working in a consultancy organisation with multiple currencies.
• A strong finance education with experience in the wider finance team outside of FP&A.
• Advanced excel capabilities (advanced formulas, Power Query, VBA) and ability to leverage native excel functionality to automate manual processes.
• Strong experience with ETL and data tools such as Alteryx, Knime, SQL, R, Python, Tableau, Power BI.
• Excellent data communication and presentation skills, with the ability to convey financial concepts to both financial and non-financial stakeholders.
• Prior experience with Dynamics 365 (Finance & Operations and Project Operations) and ERP implementation desirable.

RLB Employee Benefits

• Hybrid Working - Working patterns to support your work-life balance. As well as competitive maternity and paternity packages.
• Well-Rewarded - A competitive salary and generous holiday entitlement. As well as the opportunity to purchase up to five extra days.
• Focus On Wellbeing - We offer a number of health and wellness options, including gym membership and cycle to work schemes.
• Healthcare Packages - Private healthcare insurance and medical support, including dental insurance and eyecare vouchers.
• Personal Development - A continuous learning and development programme, including established APC and in-house mentoring schemes.
• Additional Benefits - We offer a wide range of benefits including a season ticket loan and professional membership subscriptions.
• Exceptional Exposure - You’ll have the opportunity to work on diverse projects across different sectors and regions.
• Social Responsibility - We hold team and social events as well as charity fundraising and volunteering activities.

Our Diversity, Equity & Inclusion Commitment

We believe in building a diverse and inclusive environment where each person can be themselves, feel valued for their contribution and be challenged and supported to reach their full potential. We have a responsibility to support the communities in which we live and work, and that our workforce should reflect these communities and our clients. Our talent strategy should enable us to overcome bias in the construction industry by recruiting, retaining, developing, and promoting a diverse and inclusive workforce. Find out more here: Diversity, Equity & Inclusion - RLB | Europe.

If you require any reasonable adjustments to support you during any stage of the application or interview process, please contact our recruitment team at: [e-mail]