Royalty and Data Analyst

  • Sony Music
  • New York, NY, USA
  • Sep 10, 2019
Full time Data Science Royalties

Job Description

The Orchard is a leading music distribution company operating in over 40 markets worldwide –  distributing music from independent artists including Ozuna, Skepta, Jorja Smith, John Prine, and Kelsea Ballerini. With cutting edge operations and an unparalleled global team, The Orchard partners with labels of all sizes to make their music and video available across hundreds of digital and physical retailers around the world. At The Orchard, the focus is to provide a comfortable, social and engaging environment to encourage productivity and creativity.

The Orchard is hiring a Royalty and Data Analyst to join our NYC team. 

Responsibilities

30% Royalty Processing

  • Process bi-weekly monthly and quarterly royalty payments to music labels
  • Prepare quarterly consultant commission statements
  • Reconcile payment files against generated payment report
  • Correspond with client service team to assist with royalty-related payment inquiries
  • Review contract terms to assure that royalty payments are calculated according to agreement
  • Liaise with Western Union to troubleshoot and resolve payment issues
  • Liaise with growing set of Sony affiliates to support royalty payment processing and reconciliation of payment calculations

70% Data Analysis

  • Generate monthly and quarterly ad hoc reports for royalty, finance and legal department from relational databases through SQL and Excel
  • Serve as point person to provide reporting support within relational databases where data populates within user interface
  • Troubleshoot system-generated calculations against raw data from databases for discrepancies
  • Support film team with reporting to support transition of de-merger of film department from company
  • Support report automation through SQL software or Looker
  • Provide experience insights of user-interface experience to product team to support build of new accounting software

Qualifications

  • Understanding of the music industry and/or music royalties data
  • Technical language required: MySQL
  • Experience with the following SQL software, such as SQLYog or Snowflake
  • Advanced knowledge of MS Excel, including use of pivot tables, Vlookups and various formulas
  • Experience with Looker or other BI software preferred
  • Basic comprehension of accounting principles

About The Orchard

The Orchard is a leading music distribution company operating in over 40 markets worldwide. With a comprehensive artist & label services offering including full-service marketing, sync licensing, comprehensive video services, transparent data analysis, advertising, rights management, digital and physical distribution and more, The Orchard empowers creators and businesses to grow and adapt in the dynamic global industry. For further information, visit www.theorchard.com.