Royalty and Data Analyst
Sony Music
New York, NYThis was removed by the employer on 10/11/2019 7:50:00 AM PST
Not to worry we have many other jobs on the site;
Browse all jobs
Browse the Accounting/Finance Category
Search for Royalty and Data Analyst jobs in New York-NY
Search all Royalty and Data Analyst postings
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