Data Analyst - Royalties Department

This job has now expired



Position:
Data Analyst - Royalties Department
Employer:
CC Young & Co.
Category:
Music
Location:
UK - London
Salary:
Competitive
Date Posted:
Sep 22nd 2021
CC Young & Co.

Based in the City of London, C.C. Young & Co are one of the leading music specialist firms of accountants and tax advisors. C.C. Young & Co. provides accountancy and taxation services to music industry clients.

Over the past 23 years, C.C. Young & Co. has enjoyed continued growth and now has departments specialising in tax, touring, recording, publishing, business management services for artists and managers, and royalty audits.

It is seeking a Data Analyst to join the Digital Royalties Team

What you will do

• Work closely with the section´s technical lead and one other data analyst
• Assist with the development of a project plan and the implementation the below:

o Build and maintain data warehouse of all royalty-related incoming data from upwards of 50 different sources, particularly DSP´s, CMO´s, labels and publishers
o Automate the ETL process
o Develop data-processing programs to work on the stored data and produce analyses across many data sources
o Develop dashboards for viewing the stored data by staff and clients

• Manage data preparation for royalty audits and other projects directly for clients

 Skills and Qualifications

• Experience with statistical analysis
• Experience with Excel (writing formulas, formatting, etc.)
• Ability to write SQL queries
• Data-cleaning experience
• Familiarity with Python

Desirable Expertise

• Experience with Microsoft SQL Server
• Knowledge of Transact-SQL syntax and functions
• Experience with Jupyter Lab/Notebooks
• Ability to use Pandas for data manipulation
• Ability to use Python-to-SQL connections with Pyodbc/SQLalchemy
• Familiarity with Excel Power Pivot
• Knowledge of the digital royalties landscape in music streaming and distribution

Equal Opportunities

C C Young & Co Ltd is committed to promoting equality of opportunity for all staff and job applicants. We aim to create a working environment in which all individuals are able to make best use of their skills, free from discrimination, and in which all decisions are based on merit.

Please apply to careers@ccyoung.co.uk

You May be Interested in...
Trinity College London

Production Manager

UK - London
BBC Studios

Music Strategy Manager

London but with flexible / agile working pattern.
Molto Music Group

Artist Relations

Covent Garden, London
subscribe link free-trial link

follow us...