Royalty Analyst

Position Summary

This position requires a highly organized individual who possesses strong initiative and has the ability to complete multiple projects in a deadline driven environment. This individual must be able to communicate effectively and understands the need to work in an integrated manner with other members of the department in furtherance of goals, objectives, and knowledge.

• Downloading and summarizing royalty statements from portals.
• Combining and formatting large electronic datasets.
• Maintaining organization of electronic files and folders.
• Aggregating, transforming, summarizing, and analyzing various datasets by creating databases, designing pivot tables, and running queries.
• Reconciling royalty subledger activities to the general ledger.
• Reconciling various third-party liability account balances.
• Analyzing existing royalty system terms to ensure alignment with agreements.
• Analyzing data to find underpayments of royalties and create claim schedules.
• Preparing accurate and timely monthly, quarterly, and semi-annual royalty statements to comply with contractual obligations, ensuring all costs and advances are reconciled to the general ledger.
• Preparing royalty schedules for insurance applications and/or renewals.
• Preparing customized royalty reports as requested.
• Conducting Internet research.
• Communicating client change of address and direct deposit information to income sources.
• Responding to inquiries from internal teams.

• Experience with an accounting system (Quick Books, Dynamics, SAP, Oracle).
• Experience with data mining tools (Access, SQL, BI).
• Experience developing metrics for reporting, using data visualization tools Tableau or Power BI.
• Prior experience working in accounting, audit, royalty accounting, music and/or licensing.
• Experience or education in the music business, particularly music royalties or audit.
• Eagerness to learn new skills and concepts.
• Strong written and verbal communication skills with the ability to interact across the organization.
• Extremely detail-oriented to create accurate and timely reports.
• Strong work ethic with a positive attitude & a fit with the company’s culture & values.

• Ability to reliably commute and report to the Tri Star office.
• BA or BS in Finance, Accounting, Business, or related field.
• 3+ years of work experience, preferably in the music or entertainment industry working with music royalties, publishing, and/or licensing.
• Proficiency in Excel, including Pivot Tables and formulas (such as VLOOKUP and SUMIF).
• Strong analytical and problem-solving skills, with clear attention to detail.
• Ability to set goals, manage timetables and meet deadlines.

• A collaborative, team oriented working environment
• Exposure to unique projects in a variety of industries
• Opportunities to contribute ideas and propose solutions alongside industry leading experts
• Competitive salary and benefits
• Encouraged work/life balance, including generous time off policies

At Tri Star, you will have the opportunity to work in fast-paced, ever evolving environment with dedicated professionals. As an integral part of our team, you help drive the company’s success and help bring our client’s vision to life, while having support to develop your skillset and grow professionally. If you thrive in high-pressure situations and are passionate about providing white glove service to clients, we would love to hear from you.

PERFORMANCE: We provide clients with excellent reporting and service

HONEST & INTEGRITY: We are transparent and accountable, always being truthful to staff and clients

TEAMWORK: We actively participate in group discussions, tasks, and projects

COMMITMENT: We are dedicated to our roles within Tri Star, the core values of the firm and the clients

TECHNOLOGY: We seek to capitalize on innovative technologies and contribute to positive change in the firm

This job description is not intended to be a comprehensive list of all requirements of this position.

The salary offered to an applicant will be based on individual qualifications, skills, experience and education. This position is also eligible for performance-based bonuses and competitive benefits.