Royalty and Data Analyst

This is a Full Time Job

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