Business area: Finance

Location: London

Contract type: Fixed-Term

Full Time/Part time: Full Time

Contract duration: 6 months

Reporting into: Senior Commercial Analyst

Our Vision

Our vision is to inspire brands and people to impact the world. To create big ideas that make a significant contribution to the planet, society, and the bottom line. We believe in today’s world this is the best way for our clients to achieve sustainable growth.    

We achieve this by breaking down the barriers that restrict talent and ideas, we call this Borderless Creativity.          

Which is why our teams work fluidly across five capabilities: Advertising, Consulting, Experience, PR and Influence, and Health. This allows us to not only operate but innovate at the intersection of capabilities and talent.  We believe impact and magic lie at this intersection. Ogilvy scales this by seamlessly connecting and accessing the deep and diverse cultural expertise of 132 offices in 83 countries in a way that celebrates our commitment to inclusion.    

Our mission: We inspire brands and people to impact the world 

How we do it: We innovate and operate at the intersection of people and capabilities

What we do: Borderless creativity  

About this role

The Financial Reporting Team covers 4 areas: management accounting, staff costs, commercial analysis, and compliance. The Financial Reporting Team will manage the overall P&L for Ogilvy UK and will have overall responsibility for reporting to WPP. The Commercial Finance Team will focus on revenues whilst the Financial Reporting Team will report revenues and manage all agency costs including staff costs. The Financial Reporting team will work with the Commercial Finance team to deliver a commercially focused collaborative and compliant agency for Ogilvy UK.

You will mainly be responsible for the preparation for monthly reporting of profitabilities, team utilisation and forecasting of resources. You will need to quickly familiarise with the sources of OpCo data, where it is stored and how, and to possess the right skills to easily extract the data, process, share where required, and ensure the processing and storage is compliant.

As Ogilvy moves towards automation of reporting & data integration into the Delivery 2.0 Tool set, data quality is of paramount importance. The business will be making key decisions from the Quantum dashboards and the PMO teams will be Scoping, Estimating and Resourcing using this data, so Quality Control of this data is an important part of business improvement.

Key Responsibilities:

Systems and Data Integration

• Strengthening the internal reporting system (Client, Craft and Capabilities dashboards)
• Using the systems (Quantum, Maconomy, CapPlan, Talent Tree, Scope, etc) effectively and efficiently
• Ensuring accuracy of the data pulled out of the systems (Quantum, Maconomy, CapPlan, TT, etc)
• Ensuring the accuracy and credibility of all data being shared with the wider business
• Have an understanding of what the numbers mean and proactively investigating those that don’t appear to make sense
• Improving the data flow between the systems (TT, Maconomy, CapPlan/Quantum, etc.) and ensuring the full and accurate transfer of information between them
• Question the current systems and suggest improvements, other tools

Internal Reporting and Analysis:

Supporting and providing the commercial analyst with accurate data to ensure the following tasks are performed and delivered in a timely manner:

• Preparing the profitabilities for WPP reporting and budgeting
• Ensuring the monthly internal reporting of Client Dashboards
• Using the systems effectively and efficiently (Maconomy, CapPlan, Quantum, etc.)
• Liaising with the Commercial Controllers, and assisting with analysis
• Working with the Commercial team in relation to the internal reporting, investigating large variances or problematic clients
• Ensuring the monthly internal reporting of Craft Dashboards

Commercial Reporting and Analysis

• Preparing the profitabilities for WPP reporting and budgeting
• Ensuring the monthly internal reporting of Client Dashboards
• Using the systems effectively and efficiently (Maconomy, CapPlan, Quantum, etc.)
• Working with the Commercial team in relation to the internal reporting, investigating large variances or problematic clients
• Ensuring the monthly internal reporting of Craft Dashboards

Teamwork and systems

• Working with the Commercial team to understand the reasons behind client margins
• Making suggestions for change and efficiency in all areas or reporting including ensuring efficient use of all systems
• Following best practice for all internal procedures and systems
• Ensuring best utilisation of data: mapping all local data to Master data values via the Q-admin, managing standard cost and charge out rates by Profile in Q-admin, checking employee data quality, reviewing Dashboards on a regular basis to ensure there are no issues, setting-up client rate table and maintaining for each reported client by business unit, setting-up new Reported client if required and mapping them accordingly, etc.

Other responsibilities

• Ad hoc projects as directed by the Senior Commercial Analyst

Skills

• Advanced Excel (ideally some PowerQuery & VBA experience).
• Previous experience with system implementation(s) a benefit.
• Knowledge of Maconomy preferred, but not essential.
• Excellent communication, both oral and written.
• Interpreting data to non-financial colleagues.
• Candidate with both IT and financial experiences preferred.
• Willingness to question current processes/data.

At Ogilvy UK, we want to make sure that you’re set up to grow and develop in your role and enjoy some of the best times of your working career. Our learning and development team are on hand to provide training for you, to help you excel in every aspect of your role. So, if you think you may not have experience in some aspects of this position, don’t worry, and apply away. We’re here to help you grow and nurture your skills.  

How we help you Thrive: 

• 25 days annual leave + 1 Volunteer Day 
• Bupa Healthcare (including Bupa health assessment and menopause support) 
• Enhanced leave policies or parents and carers

• We have a flexible working policy with core working hours between 10am – 4pm. We also operate a 3:2 hybrid working structure 
• A 1.5:1 matching pension structure 
• Up to £25.00 per month towards physical or online exercise class membership
• Opportunity to sign up for Unmind membership, LifeWorks tool and annual eye tests
• Learning and development budgets plus enhanced and ongoing wellbeing incentives and activities throughout the year 

• Season ticket loan and cycle to work scheme  
• Life Assurance x4 salary  
• [email protected] – our employee networks Ogilvy ReWired, Roots, Equals, PROUD and Parents and Carers. See here for more information  

Dedicated to our people, we provide additional perks to help support your work life balance 

If this sounds like the right role and company for you, we’d love to hear from you.

Our ambition is to attract the very best diverse talent to Ogilvy, and to be the employer of choice in the UK. We want everyone to feel welcome when they join us, and once they’re here, for them to want to stay with us, grow their career, and to feel they belong with us. 

We are an equal opportunity employer and we’re committed to creating an inclusive, welcoming environment for everyone who wants to work at Ogilvy. For us, diversity, equity and inclusion is integrated into everything that we do. We believe that for creativity to flourish, everything about how we work must have diversity at its core. Your race, colour, ethnic, religion, gender, gender identity, national origin, sexual orientation, age, marital status, disability, have no bearing on our hiring decisions, but we encourage everyone to feel free to express their true selves in an environment we are consistently striving to make as inclusive as possible.  

We aim to facilitate an accessible and positive application experience for all candidates. If you require any adjustments from us to support you through the process or expect to require any adjustments to working conditions to be able to best perform in the role, please let us know. We are happy to consider all reasonable adjustments.