Royalty Data Analyst

Job Description Summary:

Job Description:

Primary Responsibilities

• Assist managers with music royalty audits of record companies music publishers and merchandising companies on behalf of clients that include many Multi-Platinum and Grammy-winning artists writers and producers

• Download and summarize royalty statements

• Work with large and complex datasets to identify trends discrepancies anomalies and opportunities for further investigation

• Maintain organization of electronic files and folder

• Review and interpret contractual agreements to identify relevant royalty provisions rates definitions deductions and other key terms

• Analyze various data flows and income types that contribute to royalty statements and assess the accuracy and completeness of reported information

• Develop maintain and improve databases and analytical tools used to support royalty audits and data analysis

• Utilize advanced Excel skills to manipulate analyze and present complex datasets; leverage Power BI and other data visualization tools as appropriate

• Maintain strong client relationships through professionalism integrity responsiveness and effective communication

• Conduct Internet research

• Other projects and duties as assigned

Qualifications

• 2 years of relevant experience in royalty auditing royalty accounting data analysis or a related field

• Demonstrable experience working across Recorded Music Music Publishing and Neighbouring Rights is required

• Advanced proficiency in Excel including Pivot Tables and formulas (such as VLOOKUP and SUMIF) bonus points for experience with Power Pivot and Power Query

• Solid interpersonal skills and other key soft skills (i.e. communication time management emotional intelligence adaptability active listening critical-thinking etc.)

• A genuine interest in the music business and music royalties

• The candidate must also:

  • Be a self-motivated and detail-oriented analytical thinker

  • Possess excellent verbal/written communication skills and reading comprehension

  • Understand basic mathematical and accounting principles

  • Work well independently and in a team environment

  • Be eager to learn new skills and concepts

  • Want to help creative artists

• While not required experience or education in the music business particularly music royalties and music royalty audits are beneficial

This position is a non-exempt position. The annualized base pay range for this role is expected to be between 35000 - 38000. base salary compensation range. Actual base pay may vary based on factors including but not limited to experience subject matter expertise geographic location where work will be performed and the applicants skill set. The base pay is just one component of the total compensation package. Other rewards may include an annual cash bonus and a comprehensive benefits package including but not limited to medical dental vision life insurance and 401(k). Please note that the job title is subject to change based on the selected candidates experience and education. Falsification of application information may be grounds for denying employment.

GRF Focus Partners Business Management is a leading full-service business management firm serving an exclusive clientele of entertainers athletes executives and select high-net-worth individuals. With approximately 40 Managing Directors and more than 700 professionals GRF provides comprehensive financial and advisory services across the music film television sports literary and broader entertainment industries as well as multi-family office services for ultra-high-net-worth individuals and families.

As part of Focus a leading financial services organization offering wealth management family office and business management solutions GRF combines deep industry expertise with personalized client service. Learn more at or follow the company on LinkedIn.

#LI-TN1

Focus is a leading financial services firm comprised of integrated wealth management family office and business management services. Blending deep expertise and expansive resources with a boutique client-first fiduciary philosophy Focus helps individuals families and institutions navigate complex financial situations with highly personalized solutions tailored to their unique needs. To learn more about Focus visit or follow the company onLinkedIn.

EEO Statement: Focus is an equal opportunity employer and bases its employment decisions on the employee or candidates skillset and without regard to an employee or candidates race color religion sex (including pregnancy) gender identity sexual orientation national origin age disability genetic information veteran status or any other characteristic protected by local state and/or federal law.

Focus complies with federal and state disability laws and makes reasonable accommodations for applicants and employees with disabilities. If reasonable accommodation is needed to participate in the job application or interview process to perform essential job functions and/or to receive other benefits and privileges of employment please contact

The following language is for US based roles only

For California Applicants:Information on your California privacy rights can be found here

For Indiana Applicants: It is unlawful for an employer to discriminate against a prospective employee on the basis of status as a veteran by refusing to employ an applicant on the basis that they are a veteran of the armed forces of the United States a member of the Indiana National Guard or a member of a reserve component.

For Maryland Applicants: I UNDERSTAND THAT UNDER MARYLAND LAW AN EMPLOYER MAY NOT REQUIRE OR DEMAND AS A CONDITION OF EMPLOYMENT PROSPECTIVE EMPLOYMENT OR CONTINUED EMPLOYMENT THAT ANY INDIVIDUAL SUBMIT TO OR TAKE A POLYGRAP OR SIMILAR TEST. AN EMPLOYER WHO VIOLATES THIS LAW IS GUILTY OF A MISDEMEANOR AND SUBJECT TO A FINE NOT EXCEEDING $100.

For Massachusetts Applicants: It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this shall be subject to criminal penalties and civil liability.

For Montana Applicants: If hired the employment relationship is governed by the Wrongful Discharge from Employment Act. Mont. Code Ann. Section.

For Rhode Island Applicants: Focus is subject to Chapters 29-38 of Title 28 of the General Laws of Rhode Island and is therefore covered by the states workers compensation law. If you willfully provide false information about your ability to perform the essential functions of the job with or without reasonable accommodations you may be barred from filing a claim under the provisions of the Workers Compensation Act of the State of Rhode Island if the false information is directly related to the personal injury that is the basis for the new claim for compensation. The Company complies fully with the Americans with Disabilities Act.