Business Analyst II

Job Description:

Top 3 Hard Skills Required + Years of Experience
1. Minimum 3-5 years' experience with Excel for in-depth revenue tracking as well as financial analysis and reporting - this role will help build and manage large excel revenue databases.
2. Minimum 2-4 years' experience with royalty tracking and reporting
3. Minimum 2-4 years' experience with the invoice and Purchase Order (PO) process from beginning to end.

We are looking for a Financial and Business Analyst to support the Business Team and help us shape the future of the franchise. As a Business Analyst for the Business Team, you will be responsible for processing and analyzing the financial performance of the franchise across Console, Mobile, PC, and new platforms. By ensuring accurate revenue reporting, you will contribute to the success of our internal and external partners, and drive impact through informed decision-making across the franchise.

Key Responsibilities
* Reconcile revenue statements from the Console, Mobile and PC businesses, spanning financials and user engagement
* Contribute to monthly close processes by taking ownership of tasks such as creating journal entries, accruals, and variance reporting, adhering strictly to GAAP accounting principles
* Create reports and manage processes for royalty statements and payments to partners
* Aid Business Managers with ad hoc sales performance report creation and data validation
* Support Business Analytics Specialist with rhythm of business reporting and reconciliation
* Audit financial processes and recommend improvements to the team
* Document existing and new business operations processes

Responsibilities
* Acquire data, develop, and maintain Excel based databases/data collection systems.
* Monitor performance and quality control to identify efficiencies and improvements.
* Evaluate business processes, anticipate requirements, uncover areas for improvement, and developing and implementing solutions
* Effectively communicate insights and plans within the Business Team
* Monitor and maintain accurate financial records and status of partners to facilitate effective financial management, invoicing, and reporting
Qualifications/Skills
* Advanced knowledge of MS Excel and competency in MS Word and Outlook
* Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy

Crucial Projects/Areas of Need
1. Royalty Payment Data Validation (Quarterly)
o Track receipt of and validate data from multiple sales statements (direct from platform partners and from internal tools)
o Once Excel data is validated, format and send for approvals

2. 3P Platform Partner Revenue Statements (Weekly)
o Reconcile each platform partners revenue statements and collaborate with our Stockholm based team to issue PO/invoices for 3P platforms
o Monitor platform partner statement status through the Royalty Workbook (Excel), jointly managed by our team and Stockholm Finance Team

3. Calculate Mobile Accruals for Month End Process (ROB)
o Utilize sales information from our Mobile platform partners sales dashboard to calculate accruals for month end
o Once Excel data is validated, format and send for approvals
o Once approved, partner with Studio Finance partner to ensure accurate entry into month end close files

Qualifications
* 2-4 years of experience in business operations and financial analysis
* Bachelor's degree in business management, finance, accounting or relevant field
* Excellent analytical and problem-solving skills, with strong financial background and understanding of GAAP accounting principles
* Attention to detail and accuracy along with excellent verbal, visual and written communication skills
* Track record of strong collaboration across teams
* Passion for gaming and entertainment preferred

Interested candidates please send resume in Word format Please reference job code 240588 when responding to this ad.