Experian is the world’s leading global information services company, unlocking the power of data to create more opportunities for consumers, businesses and society.
We are thrilled to share that FORTUNE has named Experian one of the 100 Best Companies to work for. In addition, for the last five years we’ve been named in the 100 World’s Most Innovative Companies by Forbes Magazine.
Experian GL Accounting team is seeking a Royalty Reporting Analyst to meet our growing needs in Costa Rica. As a Royalty Reporting Analyst, you will be in charge of ensuring completeness, timeliness and accuracy of royalty monthly calculation and associated reporting and payments, while being an integral part of the month end / quarter end / year end closes.
You will also drive the alignment of new royalty rate cards, as well as visualizations of the data in Tableau.
What you’ll be doing
Prepare and review monthly royalty calculation
Analyze applicable Tableau and mainframe reports and determine if they accurately represent appropriate royalty related data
Apply any manual adjustments as per royalty contract to ensure accuracy
Update, implement and review Pricing exceptions to the monthly calculation
Incorporate new Pricing exceptions into the ongoing process
Prepare and post journal entries associated with month end closes
Report and present to the royalty support and GL management the monthly calculation and comparables to obtain sign off
Prepare and drive analytical analysis to ensure payments are in line with expectations
Work closely with finance teams to provide necessary data to support their close and reporting activities
Ensure external royalty reporting is correctly formatted and files are delivered on a timely and consistent basis
Interpret, build consensus on, and respond to direct inquiries to our monthly files
Troubleshoot mainframe and Tableau reports for issues and solutions
Communicate with royalty management team and BU Finance team any issues, as well as adjustments to liabilities
Collaborate with Tableau, mainframe, royalty management and BU Finance teams on any process improvements
Develop a deep understanding of royalty related data process and serve as a process and subject matter expert
Demonstrate dedication to be a leader from the data and audit perspective
Enhance and build visualization for royalty data, as well as work on expanding data sets to revenue
Ensure alignment with correct score card and alignment with historical cards, if needed
Work with Tableau information technology team to implement a new rate card
Test and ensure accuracy of the calculation logic in Tableau and offline process for the new rate cards
Build processes around new carve outs for newly carded royalty revenue
Support enforcement of controls and external / internal audits, including royalty specific audits
Develop and implement procedures to achieve efficient and effective month end close with a continuous improvement mindset
What your background looks like
5 years experience in Accounting and financial reporting, preferred royalties revenue experience
Bachelor’s degree in Accounting
Previous experience with Tableau or any data visualization related tool
High level of attention to detail combined with an understanding of royalty calculation process
Excellent English written and verbal communication skills (C1 Level)
Advanced Excel, Oracle and Power Point knowledge
Strong analytical and problem-solving skills
Strong ability to demonstrate complete ownership of assigned tasks
Strong business partnering skills
Works effectively across other departments / business units to ensure business issues are resolved for the success of the company
Effective organizational skills and ability to manage multiple responsibilities under tight time frames
Team oriented with a positive attitude
Highly deadline driven with the ability to demonstrate ownership of the tasks assigned
High level of curiosity and self-motivation
Strong relationship building skills and a highly professional client service orientation
Demonstrated record of process improvements and desire to implement best practices
Proven previous job stability, including maintaining long-term work relationships with former employers
Must be able to clear the company’s pre-employment screening
Experian is proud to be an Equal Opportunity and Affirmative Action employer. Our goal is to create a thriving, inclusive and diverse team where people love their work and love working together.
We believe that diversity, equity and inclusion is essential to our purpose of creating a better tomorrow. We value the uniqueness of every individual and want you to bring your whole, authentic self to work.
For us, this is The Power of YOU and it ensures that we live what we believe.