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.

The role involves:

The delivery of bonus and commission to monthly deadlines to ensure timely payments
Monthly calculation and processing of bonus and commission payments; resolving queries based on practice and precedence as appropriate
Producing MI/League tables on revenue/bonus related data to assist in key business decisions
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. Presenting the outputs of the scheme modelling to help support and drive the best business outcome
Working with other teams in order to ensure problems are resolved and effective solutions put in place
Continuously identifying areas of improvement within existing processes and ensure those changes are effectively implemented
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

Competency

Behaviours / Performance Indicators

Financial Acumen

Commercial Awareness

Work with your brands to devise incentive schemes that reward profitable performance and incentivise and motivate the sales community.
Document all incentive proposals and ensure adequate approval papers for submission to Remco for approval.
Model the structure and guidelines to your brands incentive schemes.

Financial Control

Financial Modelling - forecast and budget of bonuses, bonus accruals and management of bonus database.
Track HR leavers reports in order to flag issues which need to be dealt with.
Produce and maintain databases and data flow processes for all relevant commission plans and brands.
Deal with fraudulent deals and bonus calculations.
Provide support to the Brand Leads by providing information on revenue/bonuses and schemes.
Manage and calculate bonuses to strict monthly/quarterly deadlines.
Respond to business queries in relation to bonus and commissions on a timely basis.
Carry out financial reconciliations to ensure all commissions have been paid and processes have been followed.

Results driven

Adhere to month end timelines, ensuring quality is not compromised for speed.
Plans and organizes activities in order to achieve results and to deliver on commitments.
Stays focused on priorities.
Customer orientation

Understanding, defining and agreeing customer requirements.
Adapts customer service to satisfy the customer.
Always seeks to create a valuable customer experience while keeping customers up to date.
Resolve disputes and conflicts accordingly and as appropriate escalate in order to achieve satisfactory resolution.
Problem Solving and Analysis

Analyses information in order to make sound recommendations.
Learns from experience and takes actions to avoid recurrence.
Identifies key decisions that need to be taken.
Knows when to escalate or hand over.
Supports team to find solutions.
Early identification of risks to delivery to prescribed timelines.

Embracing & Adapting to Change

Is open to accepting other approaches, perspectives and opinions.
Is positive and remains calm in the face of uncertainty. Strives for emotional balance in challenging situations.
Continued focus on core responsibilities despite the changing environment, ensuring required performance results are maintained.

Self-Management and Development

Proactively seeks feedback.
Acknowledges personal strengths and development areas.
Has the courage to admit mistakes.
Is aware of his/her image and impact on others.
Maintains self-motivation and shows an optimistic attitude.
Communication

Gives and receives appropriate feedback.
Handles different communication channels and chooses the most appropriate for the situation and the audience.
Demonstrates empathy and actively listens to show interest in other viewpoints.
Considers both factual and emotional aspects to have greater impact in communication.
Is appropriately assertive and persuasive.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