C.C. Young & Co – Data Analyst (UK)

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:
  • 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
  • Automate the ETL process
  • Develop data-processing programs to work on the stored data and produce analyses across many data sources
  • 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 [email protected]

Related Music Business Jobs