financial analyst - Albuquerque, United States - Sandia Resort & Casino

Description

:

Position Summary

The Financial Analyst is the primary support for maintenance of daily operation reports and other analytical reports. The Financial Analyst uses analytical techniques to identify business trends and relationships and effectively uses the analysis to assist in making and monitoring business decisions. The Financial Analyst assists the finance team in review and analysis of Resort & Casino and Enterprise operating budgets and revenue activity. The Financial Analyst will generally be assigned an area of focus in Gaming, Marketing or Food and Beverage.

Supervision Exercised

Reports to the Manager - Analytics and Financial Planning.

Major Duties and Responsibilities

Gaming Operations Focus:

1. Responsible for preparing, investigating, and analyzing slot machine variances in accordance with NIGC standards.
2. Reviews and reports on Bingo, Keno, and Table Games variances in accordance with NIGC standards.
3. Prepares statistical reports for slots department management in accordance with NIGC standards.
4. Monitors key gaming ratios and trends including volume of bets, drop, win percentages of bet and drop, win per unit, deviation from theoretical win or floor par and other relevant gaming statistics.
5. Analyzes gaming market trends and Sandia's market share trends.
6. Analyzes labor usage on casino floor (See Labor Management section).
7. Performs other duties as assigned.

Marketing Database Focus:

1. Tracks and analyzes database information to determine the effects that advertising campaigns, promotions, and entertainment have on gaming and resort revenue.
2. Develops and executes monthly marketing reports.
3. Monitors use of the Player's Club by gender, zip code, number of trips and spend per trip.
4. Develops, executes, and monitors analysis to increase marketing productivity.
5. Analyzes all direct mail campaigns to determine effectiveness, redemption rates, revenue generation, theoretical revenue, actual revenue and overall effectiveness of the campaign.
6. Compares post campaign analysis to marketing department pre-campaign expectations and identifies significant differences. Assists marketing department in refining estimates for future campaigns.
7. Prepares ad hoc analysis as requested.
8. Performs other duties as assigned.

F&B Cost Controller Focus:

1. Assists in establishing and maintaining standard operating procedures and internal controls for purchasing, receipt, issuance and inventory of food and beverage products, operating supplies, and related equipment.
2. Monitors and tracks daily revenues and costs and prepares a daily and month to date Food & Beverage (F&B) cost report.
3. Works with the Executive Chef and F&B management to maintain menu costs and system profiles on all food and beverage items and makes F&B management aware of any pricing issues.
4. Continually monitors all F&B controls to ensure compliance with policies and procedures. Performs inventory spot checks and audits as necessary to assist in controlling costs, identifying problem areas, and prescribing corrective action.
5. Attends F&B operations and financial meetings to review F&B operating results and highlight actions needed.
6. Researches, recommends and implements new processes and systems to improve effective management of labor including the establishment of labor productivity standards, volume indicators, forecast processes and labor scheduling processes.
7. Develops and maintains labor reporting processes and ensures accurate and timely distribution of reports to various levels of management that relate to schedule versus actual time; cost and budget variances and other information needed for effective labor management.
8. Performs periodic reviews and audits of scheduled work times and actual work time records to ensure compliance with policies, accurate tracking and reporting of labor hours and labor dollars by cost center.
9. Reviews labor operating requests such as reorganization of staff, new job positions, and staff levels submitted by various departments' enterprise-wide, providing analysis of recommendations on these requests, policy issues and alternatives (see Labor Management section).

Labor Management for Gaming and Food and Beverage Focus:

1. Researches, recommends and implements new processes and systems to improve effective management of labor including the establishment of labor productivity standards, volume indicators, forecast processes and labor scheduling processes.
2. Develops and maintains labor reporting processes and ensures accurate and timely distribution of reports to various levels of management that relate to schedule versus actual time; cost and budget variances and other information needed for effective labor management.
3. Maintains compendium of labor reports.
4. Performs periodic reviews and audits of scheduled work times and actual work time records to ensure compliance with policies, accurate tracking and reporting of labor hours and labor dollars by cost center.
5. Reviews labor operating requests such as reorganization of staff, new job positions, and staff levels submitted by various departments' enterprise-wide, providing analysis of recommendations on these requests, policy issues and alternatives.

General Duties:

1. Troubleshoots systems communications between all data sources and daily operation reports.
2. Develops and maintains instructions for access and maintenance for daily operation reports.
3. Reviews, validates, and maintains source documents for daily operation reports.
4. Verifies daily flash reports data as requested by staff or management.
5. Tracks, analyzes, and reports on budget trends and variances; participates in and performs special studies and projects related to budgeting, revenue, and management decisions.
6. Reconciles accounts in daily operation reports to month end financials.
7. Maintains models for all published packages in report/query applications.
8. Responds to general budget inquiries from Sandia Resort & Casino and Enterprise department managers.
9. Assists finance team in preparing, reviewing, and analyzing data for preparation of budgets.
10. Performs job-related projects and duties as needed.

Secondary Duties and Responsibilities

Knowledge, Skills and Abilities

1. Working knowledge of accounting principles and practices.
2. Knowledge of SQL strongly preferred for Marketing focused Analyst.
3. Ability to read, analyze and interpret data in conjunction with financial data sources.
4. Ability to define problems and draw valid conclusions.
5. Ability to respond to financial and budget inquiries from staff and management.
6. Ability to present information effectively in one-on-one and small group situations to staff and other department staff and management.
7. Working knowledge of multiple database management systems for daily operation reports, ad hoc queries, and financial reporting.
8. Ability to build complex queries and produce reports using various ad-hoc query and spreadsheet application.
9. Ability to read and interpret technical documents and communicate information to users.
10. Ability to train operational managers and supervisors in the ongoing use of specialized software and effectively communicate the benefits of its use.
11. Ability to provide management and staff with meaningful information that will help them manage their departments and employees more effectively.
12. Ability to read and interpret technical documents and communicate information to users.
13. Ability to work independently.
14. Ability to communicate effectively orally and in writing.
15. Proficient with spreadsheets, word processing and office applications are required.
16. Working knowledge of data management systems.

Requirements:

Minimum Qualifications, Education and Experience

Required:

1. Bachelor's degree in Accounting, Business, or Finance and four (4) years of budget, accounting, financial and/or analytical experience. Any combination of education from an accredited college or university in a related field and/or direct experience in the occupation totaling eight (8) years may substitute for the required education and experience.
2. Must be at least 21 years of age.

Licensing Status

1. Must be able to obtain and maintain the required Gaming License.
2. Will require a post-offer, pre-employment and random drug screening.

Working Conditions

1. Work performed indoors.
2. Tasks may be performed on uneven, inclined, hard and soft-carpeted floors, and cement surfaces.
3. Subject to hazards that may cause personal bodily harm: smoke, common colds, influenza, dust, odors and elevated noise levels.