• Royalty and Data Analyst

    Location US-NY-New York
    Posted Date 3 weeks ago(9/4/2019 3:49 PM)
    Job ID
    # Positions
    Accounting/Finance - Credit and Collections
  • Overview

    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. 


    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


    • 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.


    The Orchard is committed to providing equal employment opportunity for all persons regardless of age, disability, national origin, race, color, religion, sex, sexual orientation, gender, gender identity or expression, pregnancy, veteran or military status, marital and civil partnership/union status, alienage or citizenship status, creed, genetic information or any other status protected by applicable federal, state, or local law.


    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed