Repertoire Data and QA Analyst

Repertoire Data and QA Analyst (X2 Roles available)RepertoirePermanent, Full Time(Hybrid working role, between remote and office based - 3 days minimum in the London office)About the teamPPL’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:To support the Repertoire Reporting & Analysis Manager in delivering high quality reporting and analysis of repertoire data to the business, increasing its awareness and understanding of patterns and issues within this data. The role will involve working with licensees and rightsholders to improve the quality of data registrations and PPL’s distributions to its members.Key Responsibilities: To work under the direction of your manager to deliver a high quality regular and ad hoc reporting and analytics service to the business, enabling key statistics and insights to be identified clearly, quickly and accuratelyTo complete regular quality assurance tasks relating to airplay and repertoire data being used for UK and Business Services distributionsTo complete compilation of genre surrogates data for use in PPL distributions as regularly as the operational plan requiresProactive use of third party data from our music industry data sources to complete quality assurance tasksTo analyse and interpret licensee music returns data in order to identify trends, patterns and anomalies and to drive communication of issues for resolutionTo investigate apparently anomalous, incorrect or incomplete data in order to identify the root causes and any remedial actions requiredTo proactively raise system or technology issues with line manager and Technology team to prevent bottlenecks of data problemsTo use music usage data to provide recommendations to Finance and Client Services on performer and rightsholder advancesTo provide charts, statistics and relevant commentary to PPL’s Communications team in order to create press and media opportunitiesTo contribute to tracking of risks that arise from data management processes within the Repertoire teamTo proactively make use of ADP and new technologies in order to automate workflows and improve efficiencyWhat you’ll need:Experience of working in a complex, high volume, data analysis and reporting environmentExperience of producing analytical and reporting outputsProficient user of database systems such as Snowflake and able to design Snowflake and SQL queriesAdept in research skills (thorough analysis of primary and secondary data, identifying and delivering to stakeholder requirements in timelines required)Excellent written and verbal communication skillsWhat 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 morePPL 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 StepsIf this sounds like you, then we’d love to hear from youEquity, 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.