Royalty Reporting & Systems Analyst

TIMEX GROUP USA INC•Shelton, CT

2d•Hybrid

About The Position

The Royalty Reporting & Systems Analyst is responsible for the preparation, validation, reconciliation, and timely submission of royalty reports for a portfolio of licensed brands. This role serves as a key contributor to the company's global royalty reporting process by extracting and analyzing revenue data, validating reporting accuracy, reconciling data to financial records, and ensuring compliance with licensing agreements. The position requires a strong commitment to data integrity, documentation, and audit readiness, ensuring that all royalty reporting can be fully traced, reconciled, and supported from source data through final report submission. Working closely with the Royalty Reporting Manager, along with Finance, IT, Commercial Operations, and Master Data teams, the analyst will leverage ERP and Business Intelligence tools to support royalty reporting, improve data quality, and enhance reporting effectiveness. The ideal candidate possesses strong analytical and data mining skills, exceptional attention to detail, and the ability to work independently while managing multiple reporting deadlines in a dynamic environment. The company has recently implemented a new enterprise Business Intelligence (BI) platform, creating significant opportunities to enhance royalty reporting capabilities. This role will play a key part in leveraging the BI environment to improve data visibility, automate reporting processes, develop dashboards and analytics, and strengthen global royalty reporting controls. There are many opportunities to leverage AI functionality.

Requirements

Bachelor's degree in Data Analytics, Finance, Accounting, Business Analytics, or a related field.
1 - 5 years of experience in financial analysis, royalty reporting, accounting, revenue reporting, data analytics, or a related discipline; experience in a large multi-national company preferred.
Advanced Microsoft Excel skills, including PivotTables, Power Query, XLOOKUP, SUMIFS, and analysis of large datasets.
Experience with Business Intelligence tools, preferably Power BI; demonstrated use of AI.
Understanding of ERP systems and associated data structures, such as Oracle, SAP, or similar platforms.
Strong ability to analyze, reconcile, and validate large volumes of transactional and financial data.
Experience reconciling operational reporting to financial records and the general ledger.
Strong problem-solving and investigative skills with the ability to identify root causes of data discrepancies.
Excellent organizational skills and ability to manage multiple priorities while meeting critical deadlines.
Strong verbal and written communication skills and the ability to present findings clearly to both technical and non-technical audiences.
Demonstrated attention to detail, commitment to accuracy and follow-through, and ability to work independently within a collaborative team environment.

Nice To Haves

Experience with SQL, database concepts, data modeling, or reporting automation is preferred.

Responsibilities

Assume full ownership of designated licensing agreements, including royalty report preparation, data validation, reconciliation, report submission, and maintenance of supporting documentation and audit-ready records. These licenses will typically consist of smaller or less complex agreements for which the analyst serves as the primary point of accountability.
Support the preparation and review of royalty reports for larger and more complex licensing agreements by performing data extraction, validation, reconciliations, and analytics.
Collaborate with the Royalty Reporting Manager and other team members to ensure the timely and accurate completion of all royalty reporting obligations across the broader license portfolio.
Extract, analyze, and validate sales and revenue data from ERP, Business Intelligence/Unified Data Platform, and other reporting systems used in royalty calculations.
Reconcile royalty reporting data to the general ledger and other financial reporting sources to ensure completeness and accuracy.
Investigate and resolve data and master data discrepancies, variances, and reporting exceptions through detailed analysis and collaboration with cross-functional teams.
Analyze large volumes of transactional revenue data across multiple business units, legal entities, countries, and sales channels.
Develop and maintain dashboards, reports, and analytical tools that enhance visibility into licensed product performance and royalty obligations.
Partner with Finance, IT, Commercial Operations, and Master Data teams to improve reporting processes, data integrity, and system efficiencies.
Support royalty audits by preparing schedules, gathering supporting documentation, responding to information requests, and maintaining audit-ready records.
Identify opportunities to automate reporting, improve controls, and leverage Business Intelligence and AI tools to increase efficiency and reporting accuracy.
Maintain a strong understanding of business processes, master data structures, and the flow of information from order entry through revenue recognition.
Consistently adhere to strict reporting deadlines and effectively manage multiple priorities across numerous licensing agreements.