Business Intelligence Analyst

Job Description

We're looking for passionate professionals who can teach us a thing or two. We promise to return the favor. We embrace those who see things differently and aren't afraid to experiment. That's where you come in.

Accountants, analysts, and advisors comprise the core of the Finance discipline at Riot, and our work ensures Riot's offices and partners around the world are optimized for strength, speed, and intelligence -- financial and otherwise. We strive to innovate and break the mold of finance organizations without forgoing our fiduciary responsibilities.
Our team contains experts from fields like tax and treasury, travel and purchasing, FP&A, and more. If we're not crunching numbers, you'll find us playing some of the latest games, pursuing our passions or upgrading our knowledge in finance.

As a Business Analyst II - Revenue Accounting, reporting into the Director of Accounting - Revenue you build analyses that help Rioters make sound decisions. You'll collaborate with Rioters from an array of other disciplines (Game teams, Insights, Payments, Data, etc.) to conduct studies and analyses related to player activity that will inform the accounting for our products. You will work with the Accounting team to run SQL queries over large datasets, analyze results and help automate processes through various automation tools. Your work ensures Riot's offices and partners around the world are optimized for strength and speed -- financial and otherwise.

Responsibilities:
• Design, develop, validate, and maintain high value reports, analytics tools, and creation of tableau reports used by the revenue accounting team
• Transform and analyze complex data sets to understand player behavior around monetization
• Critically review reports and data for completeness and accuracy
• Maintain and update existing automation projects using UiPath, Python or other tools
• Partner with other disciplines and Finance teams to level up our analyses
• Operate with a consultative approach, managing multiple stakeholder expectations simultaneously
• Collaborate with revenue team on upcoming revenue initiatives
• Handle multiple projects and ad hoc requests. Communicate status and deadlines effectively

Required Qualifications:
• 3+ years of experience writing complex SQL queries on large datasets
• 3+ years of experience using Python for data analysis and workflow automation
• 3+ years of experience with data analysis tools such as Databricks and Spark
• 3+ years of experience designing and building reports using Excel
• Experience in data reconciliation, validation, and root cause analysis
• Experience with automating manual processes with Python
• Experience translating Accounting and Finance business questions into analysis and dashboards
• Good time management skills and ability to complete projects with less oversight
• Pro-active with the ability to positively cope with change

Desired Qualifications:
• Familiarity with ASC 606 and demonstrated knowledge of US GAAP standards
• Experience with Tableau
• Experience in building and managing data pipelines

For this role, you'll find success through craft expertise, a collaborative spirit, and choices that focus on your fellow Rioters, who are the customers of your work. Being a dedicated fan of games is not necessary for this position.
Our Perks:

Riot focuses on work/life balance, shown by our open paid time off policy and other perks such as flexible work schedules. We offer medical, dental, and life insurance, parental leave for you, your spouse/domestic partner, and children, and a 401k with company match. Check out our benefits pages for more information.

Riot Games fosters a player and workplace experience that values teamwork embodied by the Summoner's Code and Community Code. Our culture embraces differences as a strength, and our values are the guiding principles for how we approach work. We are committed to putting diversity and inclusion (D&I) at the center of everything we do, and promoting a fair and collaborative culture where Rioters treat one another with dignity and respect. We encourage you to read more about our value of thriving together and our ongoing work to build the most inclusive company in Gaming.

It's our policy to provide equal employment opportunity for all applicants and members of Riot Games, Inc. Riot Games makes reasonable accommodations for handicapped and disabled Rioters and does not unlawfully discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity or expression, national origin, age, handicap, veteran status, marital status, criminal history, or any other category protected by applicable federal and state law. We consider for employment all qualified applicants, including those with criminal histories, in a manner consistent with applicable federal, state and local law, including the California Fair Chance Act, the City of Los Angeles Fair Chance Initiative for Hiring Ordinance, the Los Angeles County Fair Chance Ordinance for Employers, the San Francisco Fair Chance Ordinance, and the Washington Fair Chance Act.

Per the Los Angeles County Fair Chance Ordinance, the following core duties may create a basis for disqualifying candidates with relevant criminal histories:
• Safeguarding confidential and sensitive Company data
• Communication with others, including Rioters and third parties such as vendors, and/or players, including minors
• Accessing Company assets, secure digital systems, and networks
• Ensuring a safe interactive environment for players and other Rioters

These duties are directly related to essential operations, safety, trust, and compliance obligations within our organization. Please note that job duties may evolve based on business needs and additional responsibilities may be assigned as necessary to maintain operational efficiency and security.
• (Los Angeles Only) Base salary range between $116,800.00 - $163,600.00 USD + incentive compensation + equity + 401K with company match + medical, dental, vision, and life insurance + short and long-term disability + open PTO.

Jobcode: Reference SBJ-g4np2y-3-141-192-36-42 in your application.