Business Analytics Specialist, IP

About the Role

Assists the IP Department with the global distribution of API products, ensuring efficient operations of licensing, customer service, royalty allocations, and sales report consolidation. Supports revenue growth by monitoring and reporting on sales, royalty approvals, and customer volume.

Key Responsibilities

• Perform high-volume review, validation, and processing of subscription, licensing, and royalty-related transactions, ensuring accurate application of business rules, fee structures, and approval requirements.
• Investigate and resolve data, formula, and reporting issues within complex Excel workbooks by identifying root causes, validating results, and implementing accurate solutions.
• Maintain accurate and updated program records, lists, and files for budget analysis and reporting.
• Monitor copyright infringement and register existing API IP with the U.S. Copyright Office.
• Transform raw data into meaningful recommendations to support decision-making.
• Develop KPIs, metrics, dashboards, and performance reports.
• Conduct ad hoc analyses to support strategic and operational initiatives.
• Apply critical thinking and problem-solving techniques to complex business issues.
• Monitor and track sales/royalty financials as they relate to business growth and report on progress towards meeting program business objectives.
• Aggregate and organize various data reports for IP products.
• Assist with watermarking documents for internal distribution.
• Work with internal programs to post API documents to an online platform.
• Assist with other self-supporting program operations in the Global Industry Services Department.
• Answer customer calls skillfully and effectively, document and relay messages accurately, identify urgent calls, and respond within 24 hours.

Key Relationships

• Works with data aggregators to ensure compliant third-party IP use.
• Works with API GIS Operations and API Finance.

Requirements & Tech Stack

• Advanced proficiency in Microsoft Excel, including Pivot Tables, XLOOKUP, SUMIFS, INDEX/MATCH, data validation, conditional formatting, and formula-driven analysis.
• Experience creating dashboards, reports, and visualizations.
• Familiarity with databases and order fulfillment, customer service, inventory management, financial systems, and other management systems and tools.
• Ability to research and assimilate information accurately from a variety of sources.
• Ability to manage simultaneous assignments with minimal supervision.
• Ability to follow instructions and adhere to program policies and procedures.
• Customer service aptitude.
• Financial Industry experience preferred.
• (Preferred) Experience with Power Query, Power Pivot, and Excel data modeling techniques.
• (Preferred) Familiarity with relational data concepts and building automated reporting solutions.

Qualifications

• Bachelor's degree in a relevant area or equivalent work experience. Some positions may only require an Associate's degree/technical diploma or equivalent work experience.
• Degree in a business discipline preferred.
• Strong analytical and problem-solving skills.
• Experience working with revenue-generating programs, preferably in intellectual property, publishing, data, and/or statistics areas.
• Ability to analyze, cleanse, validate, and reconcile large datasets.
• Ability to reconcile, validate, and audit data from multiple sources.
• Strong business, financial management, marketing, customer service, sales/analysis, and reporting skills.

Physical Requirements

• Able to remain in a stationary position working on a computer.
• Able to move about the office to access office machinery, meeting rooms, etc. on occasion.
• Able to operate a computer and other office machinery.
• Able to transport items and equipment up to 10 lbs. on occasion.

Travel Requirements

• Up to 25%