EntertainmentCareers.Net
Royalty and Data Analyst
Sony Music
New York, NY
It looks like you missed out on this one.
This was removed by the employer on 10/11/2019 7:50:00 AM PST
Not to worry we have a lot of 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
Are you an employer?
How do I hire a Royalty and Data Analyst? 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 This job is no longer available. Click here to view current job listings.
This was removed by the employer on 10/11/2019 7:50:00 AM PST
Not to worry we have a lot of 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
Are you an employer?
How do I hire a Royalty and Data Analyst? 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 This job is no longer available. Click here to view current job listings.
Per your acceptance of our Terms of Use, if you aggregate, display, copy, duplicate, reproduce, or otherwise exploit for any purpose any Content (except for your own Content) in violation of these Terms without EntertainmentCareers.Net's express written permission, you agree to pay EntertainmentCareers.Net three thousand dollars ($3,000) for each day on which you engage in such conduct.#10/7/2019 2:06:07 PM