Advanced Excel - Data Analyst

Job Description

This job description describes the principal purpose and main elements of the job. It is a guide to the nature and main duties of the job as they currently exist but is not intended as a wholly comprehensive or permanent schedule and is not a contractual document.

Job title

Commissions and Bonus Analyst

Business

Central Services

Location

London

Function

Finance

Reports to

Commissions Manager

General Profile

Reporting to the Commissions manager, ensuring bonus and commission payments are calculated accurately and processed on a timely basis. Acting as a business partner to support bonus and commission related matters and to encourage bonus appropriate activities and drive profitability. The role will involve significant contact with non-finance departments and senior members of the organisation. Credibility in the eyes of directors is therefore key to the effectiveness of this post holder.

Responsibilities

1. The delivery of bonus and commission to monthly deadlines to ensure timely payments.
2. Monthly calculation and processing of bonus and commission payments; resolving queries based on practice and precedence as appropriate.
3. Producing MI/League tables on revenue/bonus related data to assist in key business decisions.
4. Financial modelling requests, both as part of the end of year review of bonus and commission schemes and in response to ad-hoc requests during the year.
5. Working with other teams in order to ensure problems are resolved and effective solutions put in place.
6. Continuously identifying areas of improvement within existing processes and ensure those changes are effectively implemented.
7. Involvement with ad-hoc projects; this may include scheme reviews including its data, or providing ad-hoc information and analysis as an example.

You will possess good interpersonal skills, strong organisational skills and an eye for detail in order to succeed in this role. You will have an ability to see the bigger picture making the link between day to day activity and business goals. You will be naturally inquisitive and look to understand the context and reasoning for all we do within the team. This will include being naturally interested in understanding your colleagues' approach and processes. The ability to communicate often complex subject matter is essential as is a highly diplomatic nature. Strong Excel and financial modelling skills are a must.

The role is part of a team and team working is an important aspect of our success. As well as taking responsibility for your own portfolio of work, you will be required to cover for other team members if they are not at work due to annual leave etc.

Key Role Competencies

1. Financial Acumen: Work with your brands to devise incentive schemes that reward profitable performance and incentivise and motivate the sales community.
2. Financial Control: Financial Modelling - forecast and budget of bonuses, bonus accruals and management of bonus database.
3. Results driven: Adhere to month end timelines, ensuring quality is not compromised for speed.
4. Customer orientation: Understanding, defining and agreeing customer requirements.
5. Problem Solving and Analysis: Analyses information in order to make sound recommendations.
6. Embracing & Adapting to Change: Is open to accepting other approaches, perspectives and opinions.
7. Self-Management and Development: Proactively seeks feedback.
8. Communication: Gives and receives appropriate feedback.

Adecco acts as an employment agency for permanent recruitment and an employment business for the supply of temporary workers. The Adecco Group UK & Ireland is an Equal Opportunities Employer.

By applying for this role your details will be submitted to Adecco. Our Candidate Privacy Information Statement explaining how we will use your information is available on our website.