Data Analyst - Accounting
Los Angeles, California, United States
8 days ago
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 aim 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, or upgrading our knowledge in finance. There’s always something to improve, and we’re always challenging ourselves
You will work with the Accounting team reporting to the Director of Accounting - Revenue to modify and run SQL queries over large datasets to calculate accounting estimates. This includes getting and understanding of the tables, running existing queries or modifying them to reflect new business activities, and analyzing the results with the accounting team. Python is preferred to help with this process. You will also work with the broader Accounting team to help automate processes, often though an RPA (Robotic Process Automation) tool. RPA may involve programming systematic steps, using an OCR (Optical Character Recognition) tool, and some Excel. Finally, you will work on ad hoc projects, Tableau, or other process improvements.
- Modify and analyze SQL queries to calculate accounting estimates; these queries are on very large tables
- Automate existing processes using RPA (Robotic Process Automation) tools
- Ad hoc projects involving data pulls, Tableau, or process improvements using Python, SQL, or another tool
- 2+ years experience with SQL
- Attention to detail; can do an essential self review of work and analyze results
- Independent; able to work without similar craft professionals nearby
- BA/BS in relevant field from an accredited university
- Python experience
- Databricks or Hadoop experience
- Interest in RPA and process efficiency
- Proficient with Excel - can perform vlookup/pivot is sufficientExperience with large datasets and analysis of query results
For this role, you'll find success through craft expertise, a collaborative spirit, and decision-making that prioritizes your fellow Rioters, who are the customers of your work. Being a dedicated fan of games is not necessary for this position!
We offer medical, dental, and vision plans that cover you, your spouse/domestic partner, and children. Life insurance, parental leave, plus short-term and long-term disability coverage are also available. Riot will support your retirement benefits with a company match, and double down on your donations of time and money to non-profit charitable organizations. Balance between work and personal life is encouraged with open paid time off, and a play fund so you can broaden and deepen your personal relationship with games.
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, including the City of Los Angeles’ Fair Chance Initiative for Hiring Ordinance relating to an applicant's criminal history (LAMC 189.00).
Don’t forget to include a resume and cover letter. We receive many applications, but we’ll notice a fun, well-written intro that shows us you Dare to Dream and Execute with Excellence.