Data Analyst (Royalties)

Bertelsmann; Colchester; Hybrid; GBP 15,000 - 25,000; Part time

Job summary

A leading publishing company is looking for a part-time Data Analyst (Royalties) to support the Royalty Operations team. You will ensure the accuracy of sales data, conduct reconciliations, and assist with reporting. Essential skills include strong numerical abilities and proficiency in Microsoft Office. This role allows for hybrid working, with attendance at the office required once a week.

Qualifications

• Experience in a high-volume transaction business area where accuracy is essential.
• Strong numerical skills and an attention to detail.
• Highly organised and able to prioritise work effectively to meet deadlines.

Responsibilities

• Reconciliations of sales data to Royalty System.
• Internal auditing of Author and ISBN records.
• Testing and documentation of new system developments.
• Assist with the Royalty Statement Portal.

Skills

Experience in high-volume transaction business

Strong capabilities in Microsoft Outlook

Strong capabilities in Excel

Strong capabilities in Word

Strong numerical skills

Attention to detail

Good communication skills

Ability to build strong relationships

Job description

Join our dynamic Royalty Operations team at Penguin Random House, where you will play a crucial role in ensuring the accuracy and efficiency of our royalty systems. As a Data Analyst (Royalties), you will support the Royalty Operations Team Leader in maintaining the integrity of sales data and its presentation on royalty statements.

In this role, you will be responsible for monitoring and verifying data feeds, conducting thorough testing of new system developments, and ensuring that all processes run smoothly without any negative impact. Your analytical skills will be key in supporting the team leader to guarantee that sales data is accurate and correctly reflected in royalty statements. If you have a keen eye for detail and a passion for data, we invite you to apply and become a vital part of our innovative team.

This is a part time opportunity at 21 hours per week.

Key responsibilities:

• Reconciliations of SAP, affiliate and co-edition sales to Royalty System and Business Objects.
• Internal auditing of Author and ISBN records.
• Manual adjustment of sales records.
• Analysis and distribution of weekly reports and investigation into anomalies in the database (Royalty exception reports, and warnings files)
• Testing and documentation of new system developments
• Production and analysis of Licensing Royalty Statements
• Analysis of unexpected Publication Prices in Royalty Sales file, and update whereappropriate
• Liaising with team members from within PRH and external partners in regard to adhoc queries.
• Escalate any ongoing issues to Royalty Operations Team Leader
• Assist with the maintenance of and querying coming from the Royalty Statement Portal
• Work with Royalty Operations Team Leader regarding mini-projects as they arise

What you’ll bring

Essential criteria:

• Experience in a high-volume transaction business area where accuracy is essential
• Strong capabilities in Microsoft Outlook, Excel, and Word
• Strong numerical skills and an attention to detail
• Highly organised and able to prioritise work effectively to meet deadlines
• Good communication skills including being able to build strong relationships with other parts of the business

Application instructions

Please apply with your CV and cover letter outlining why you are the right candidate for the role by 11:59pm on Monday 25th August.

Salary

Circa £25,000 FTE (Actual salary circa £15,000) dependent on how your skills and experience align to the role, plus bonus and benefits.


Hybrid working

While our offices across the UK are places to connect, collaborate and celebrate with colleagues, we recognise that flexibility around where you work is just as important. For this role we expect that you will work from our office in Frating, Essex, a minimum of one day per week, every Wednesday.

Company: The Random House Group Limited | Job ID: 281998