Advanced Excel - Data Analyst

London
1 week ago
Create job alert

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

Related Jobs

View all jobs

Defence Digital Finance Business Partner

Systems Engineer

Data Analyst

Senior Python Developer

Sr Associate Data Analytics

Location Analytics Consultant - Spatial Analysis - GIS

Get the latest insights and jobs direct. Sign up for our newsletter.

By subscribing you agree to our privacy policy and terms of service.

Industry Insights

Discover insightful articles, industry insights, expert tips, and curated resources.

Job-Hunting During Economic Uncertainty: Machine Learning Edition

Machine learning (ML) has firmly established itself as a crucial part of modern technology, powering everything from personalised recommendations and fraud detection to advanced robotics and predictive maintenance. Both start-ups and multinational corporations depend on machine learning engineers and data experts to gain a competitive edge via data-driven insights and automation. However, even this high-demand sector can experience a downturn when broader economic forces—such as global recessions, wavering investor confidence, or unforeseen financial events—lead to more selective hiring, stricter budgets, and lengthier recruitment cycles. For ML professionals, the result can be fewer available positions, more rivals applying for each role, or narrower project scopes. Nevertheless, the paradox is that organisations still require skilled ML practitioners to optimise operations, explore new revenue channels, and cope with fast-changing market conditions. This guide aims to help you adjust your job-hunting tactics to these challenges, so you can still secure a fulfilling position despite uncertain economic headwinds. We will cover: How market volatility influences machine learning recruitment and your subsequent steps. Effective strategies to distinguish yourself when the field becomes more discerning. Ways to showcase your technical and interpersonal skills with tangible business impact. Methods for maintaining morale and momentum throughout potentially protracted hiring processes. How www.machinelearningjobs.co.uk can direct you towards the right opportunities in machine learning. By sharpening your professional profile, aligning your abilities with in-demand areas, and engaging with a focused ML community, you can position yourself for success—even in challenging financial conditions.

How to Achieve Work-Life Balance in Machine Learning Jobs: Realistic Strategies and Mental Health Tips

Machine Learning (ML) has become a cornerstone of modern innovation, powering everything from personalised recommendation engines and chatbots to autonomous vehicles and advanced data analytics. With numerous industries integrating ML into their core operations, the demand for skilled professionals—such as ML engineers, research scientists, and data strategists—continues to surge. High salaries, cutting-edge projects, and rapid professional growth attract talent in droves, creating a vibrant yet intensely competitive sector. But the dynamism of this field can cut both ways. Along with fulfilling opportunities comes the pressure of tight deadlines, complex problem-solving, continuous learning curves, and high-stakes project deliverables. It’s a setting where many professionals ask themselves, “Is true work-life balance even possible?” When new algorithms emerge daily and stakeholder expectations soar, the line between healthy dedication and perpetual overwork can become alarmingly thin. This comprehensive guide aims to shed light on how to achieve a healthy work-life balance in Machine Learning roles. We’ll discuss the distinctive pressures ML professionals face, realistic approaches to managing workloads, strategies for safeguarding mental health, and how boundary-setting can be the difference between sustained career growth and burnout. Whether you’re just getting started or have been at the forefront of ML for years, these insights will empower you to excel without sacrificing your well-being.

Transitioning from Academia to the Machine Learning Industry: How PhDs and Researchers Can Thrive in Commercial ML Settings

Machine learning (ML) has rapidly evolved from an academic discipline into a cornerstone of commercial innovation. From personalising online content to accelerating drug discovery, machine learning technologies permeate nearly every sector, creating exciting career avenues for talented researchers. If you’re a PhD or academic scientist thinking about leaping into this dynamic field, you’re not alone. Companies are eager to recruit professionals with a strong foundation in algorithms, statistical methods, and domain-specific knowledge to build the intelligent products of tomorrow. This article explores the essential steps academics can take to transition into industry roles in machine learning. We’ll discuss the differences between academic and commercial research, the skill sets most in demand, and how to optimise your CV and interview strategy. You’ll also find tips on networking, developing a commercial mindset, and navigating common challenges as you pivot your career from the halls of academia to the ML-driven tech sector.