FPA Data Automation Analyst

Rider Levett Bucknall; Greater London; Hybrid; GBP 55,000 - 75,000; Full time

Benefits offered by this job

Hybrid Working

Private healthcare

Competitive salary

Generous holiday

APC mentoring

Season ticket loan

Professional memberships

Diversity & Inclusion

Team events

Job summary

Rider Levett Bucknall in London is seeking an FP&A Data Automation Analyst to join the Finance team. You will build and maintain finance reporting frameworks, drive data automation, and partner with IT/BI to deliver high-quality outputs across multiple currencies and jurisdictions.

The role requires strong ETL, Excel, and BI skills, with experience in Alteryx, Power BI, SQL and ERP data. Hybrid working and a focus on data-driven decision making define the environment.

Qualifications

• Proven FP&A experience in finance / accounting.
• Experience in consultancy with multi-currency exposure.
• Strong finance education outside FP&A.
• Advanced Excel with Power Query, VBA.
• Experience with ETL and data tools (Alteryx, Knime, SQL, Python, Tableau, Power BI).
• Familiarity with Dynamics 365 Finance & Operations and Project Operations desirable.

Responsibilities

• Build scalable reporting frameworks to meet a fast-growing business.
• ETL of ERP data for reporting, ensuring accuracy.
• Manage and maintain automation workflows (Alteryx).
• Develop and maintain models for long-range planning, budgeting, forecasting, and multi-jurisdiction cash flow modelling.
• Partner with the business to standardise commercial tools for data-driven decisions.
• Monitor and improve data quality across multiple source systems.

Skills

Advanced Excel

Power Query

VBA

ETL

Alteryx

Knime

SQL

Python

R

Tableau

Power BI

Education

Finance degree

Tools

Alteryx

Knime

SQL

Python

R

Tableau

Power BI

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

Our culture is built around enabling you to fulfil your potential, so you can look forward to benefits that include:

• 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].