Royalty Distribution Analyst (Contract) — Excel

ICE; Greater London; Hybrid; GBP 42,000 - 58,000; Full time

Benefits offered by this job

Competitive local benefits

Flexible working time/place

Mental and physical health initiatives

Corporate pension scheme

Training and development opportunities

Industry insider events, team socials

Enhanced holiday allowance

Job summary

ICE Services is seeking a Finance Distribution Analyst to support its monthly royalty distributions. You will plan, schedule, and perform quality control checks on distributions for customers.

This is a 1-year contract. You will reconcile accounts, review schedules, handle queries, and assist year-end and audits. Strong Excel, data analysis, and accounting systems experience required; Cognos BI is advantageous. Flexible, hybrid working options available.

Qualifications

• Strong financial modelling and analysis required.
• Experience with data gathering, reporting and analysis.
• Advanced Excel skills including pivot tables and VLOOKUP.
• Experience with accounting systems and principles.
• Familiarity with Cognos BI is advantageous.
• Experience in a high-volume transactional environment.
• Excellent attention to detail and communication.

Responsibilities

• Lead commitments to customers for online royalty distributions, reconciling outputs and quality checks.
• Review distribution schedules and perform checks and reconciliations with high accuracy.
• Reconcile balance sheet accounts related to Royalty Creditors.
• Assist with customer queries related to monthly distributions.
• Complete reconciliations for distribution accounts by deadlines.
• Review bank payment files for accuracy and unusual activity.
• Communicate issues to Finance Director/Senior Finance Analyst and liaise with support teams.
• Prepare finance journals as required.
• Support year-end and internal audit requests.
• Contribute to ad hoc analyses of finance and distribution systems.

Skills

Financial modelling

Data gathering & analysis

Excel (Pivot tables & VLOOKUP)

Stakeholder engagement

Attention to detail

Organisational skills

Tools

Accounting software

Cognos BI

Job description

ICE Services is seeking a Finance Distribution Analyst to support its monthly royalty distributions. You will plan, schedule, and perform quality control checks on distributions for customers.

This is a 1-year contract. You will reconcile accounts, review schedules, handle queries, and assist year-end and audits. Strong Excel, data analysis, and accounting systems experience required; Cognos BI is advantageous. Flexible, hybrid working options available.