Claims out Lead in London

(Hybrid working role, between remote and office based - 3 days minimum in the London office)

About the team

PPL’s Repertoire team are experts when it comes to music data. Through managing the PPL Repertoire Database, they provide services and analysis on data submitted by PPL Members and Licensees to ensure that requirements set out in the PPL Data Policy are met. Their work ensures that we can maximise revenue generation and pay-through. The Repertoire team also works to resolve key data gaps at source wherever possible, as well as promoting industry standards and working on international projects to improve music data quality.

What you’ll be doing:

You will be part of a highly motivated team processing complex datasets relating to music use around the world in order to collect and distribute over £80m of international collections revenue each year. You will be responsible for producing rightsholder and performer claims to send to other CMOs to tight deadlines. You will therefore manage, facilitate and report on the efficient receipt, validation, cleansing, transformation, matching and reporting of large and complex music industry datasets, through the use of various analytical tools.

Key Responsibilities:

• Overseeing the transformation of incoming music use datasets into standardised and workable formats; validate and, where appropriate, address the quality deficiencies of files and datasets.
• Manipulate large and complex music use data sets in efficient manners.
• Identify and support the implementation of robust solutions to resolve recurring problems and repeatable time-consuming otherwise labor-intensive tasks.
• Running utilities and tools in order to coordinate activities such as matching reported music usage to recordings on PPL’s Repertoire Database.
• Regular manipulation of data using advanced Excel skills (e.g. lookups, filtering).
• Running SSIS packages and from time to time creating or modifying SSIS packages to make the processing of statements or the running of claims.
• Use of basic SQL to write and run queries and reports.
• Overseeing the delivery of performer and rightsholder claims.

What you’ll need:

• Experience of working in a complex, high volume, data analysis and reporting environment.
• Experience in using the Microsoft BI stack or other BI software (e.g. Qlikview or Tableau).
• Competence in the Microsoft Office Suite – Word, PowerPoint and Outlook.
• A high level of computer literacy.
• Advanced Excel skills.
• Attention to detail is important; a good eye for spotting anomalies and patterns in data.
• Excellent written and verbal communication skills.
• The ability to communicate complex information in a concise and simplified manner.
• Some experience of SQL databases and analytics tools, ideally across a Microsoft SQL Server platform.

What we can offer you…

When you come on board at PPL you can expect to be rewarded for your hard work. Employees are entitled to a wide range of benefits which support their needs and lifestyles including private medical care, cycle to work scheme, flexible working hours, £120 annually to be spent on music and many more!

PPL is currently offering hybrid flexible working which will be a mixture of office based and home working along with our flexible start and finish times, should employees wish to utilise this. This could be subject to change.

Next Steps

If this sounds like you, then we’d love to hear from you!

Equity, Diversity and inclusivity at PPL

PPL are committed to equity of opportunity, diversity and inclusivity; therefore, we welcome and encourage applicants from all sections of the community.

Here at PPL we are proud to operate in a genuine, open and straightforward way while continuing to maximise all opportunities as they arise striving to represent PPL’s members. Our job is to protect our members’ rights, and make sure their talent and investment is rewarded fairly. We take an entrepreneurial approach, working together to create new ways to deliver better service and solve business challenges. Collaboration creates great things; everyone’s talent deserves recognition and each of our members is important to us. We are the professional face for our clients. We serve with a smile and go the extra mile when representing them. We share a passion for music – that’s why we do what we do.