Founded in 2022, Las Vegas Grand Prix, Inc. (“LVGP” or the “Company”) is the promoter and operator of the Formula 1 Las Vegas Grand Prix, which takes place annually with the next grand prix in November 2024. LVGP has an exciting role available for the Financial Data Analyst position, reporting to the Senior Manager, FP&A.
POSITION OVERVIEW
This position plays a critical role within accounting and finance. The Financial Data Analyst will assist in supporting forecasting, budget management, and revenue analysis through financial modeling.
RESPONSIBILITIES
- Assist in the monthly, quarterly, and annual planning, budget and forecast processes; summarize budget estimates and forecast updates and review for completeness, accuracy and prepare special budget analysis reports.
- Assist in building key financial reporting and modeling, including historical financial data and updates from financial forecasts, for Finance and Executive Leadership Team.
- Develop ad hoc reports upon request in a timely manner.
- Assist in preparation of monthly reporting packages that includes full financial statements, comprehensive Key Performance Indicator (KPI) reporting, operational dashboard reporting, analysis of key business trends, actual versus budget variances and comprehensive executive level explanations of differences.
- Assist in identifying and implementing opportunities to simplify finance tools, technology, and processes across teams and the organization.
- Continually review and propose improvements to current processes with an objective to create efficiencies by automation.
- Prepare summaries and analysis results in a professional format and/or using graphical representations.
- Provide analysis for forward-looking financial and business-related projects.
- Collaborate with staff accountants during close process to ensure proper accruals are made.
- Other related special projects and assignments to support departmental and organizational goals related to financial planning and analysis.
SKILLS AND EXPERIENCE
- Bachelor or higher degree in Finance, Accounting, Data Science, or related field
- At least 2 years of experience in data analysis within a corporate finance setting is preferred
- Strong foundational modeling skills: advanced proficiency utilizing Microsoft Excel, including Pivot Tables, complex formulas, Macros, and data visualization techniques is required
- Experience in developing metrics, reporting, dashboards, and financial models
- Ability to develop and implement financial models to support business decisions
- Strong experience with database querying, data manipulation, and analysis
- Knowledge of Power Query and Power BI is preferred
- Proficiency in Microsoft PowerPoint with the ability to create clear, compelling and visually appealing financial presentations
- Foundational knowledge of generally accepted accounting principles (GAAP)
- Stong understanding of financial statements, budgeting, forecasting, and variance analysis
- Stong work ethic, time management and sense of urgency to address issues promptly is necessary in this role along with the ability to be flexible and agile
- Demonstrated commitment to ongoing professional development and learning
- Highly organized and detail oriented
- Excellent analytical and critical thinking skills
- Team player with ability to collaborate with other departments as needed
- Ability to communicate effectively, both orally and in writing
- Ability to maintain confidentiality and strong ethical standards
- Ability to quickly understand and comply with Company policies, procedures, and practices