FINANCIAL ANALYST

Financial Analyst

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.

Our philosophy is built on the principles of integrity, fairness, collaboration, communication, and recognition for performance excellence. Meeting all performance standards leads to attracting and retaining a qualified workforce, provide opportunities for qualified team members, and contribute towards the ongoing success at Pueblo of Sandia today and in the future.

Essential Duties and Responsibilities

Gaming Operations Focus:

• Responsible for preparing, investigating, and analyzing slot machine variances in accordance with NIGC standards.
• Reviews and reports on Bingo, Keno, and Table Games variances in accordance with NIGC standards.
• Prepares statistical reports for slots department management in accordance with NIGC standards.
• 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.
• Analyzes gaming market trends and Sandia's market share trends.
• Analyzes labor usage on casino floor (See Labor Management section).
• Performs other duties as assigned.

Marketing Database Focus:

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

F&B Cost Controller Focus:

• 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.
• Monitors and tracks daily revenues and costs and prepares a daily and month-to-date Food & Beverage (F&B) cost report.
• 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.
• 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.
• Attends F&B operations and financial meetings to review F&B operating results and highlight actions needed.
• 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.
• 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.
• 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.
• 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:

• 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.
• 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.
• Maintains compendium of labor reports.
• 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.
• 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:

• Troubleshoots systems communications between all data sources and daily operation reports.
• Develops and maintains instructions for access and maintenance for daily operation reports.
• Reviews, validates, and maintains source documents for daily operation reports.
• Verifies daily flash reports data as requested by staff or management.
• Tracks, analyzes, and reports on budget trends and variances; participates in and performs special studies and projects related to budgeting, revenue, and management decisions.
• Reconciles accounts in daily operation reports to month end financials.
• Maintains models for all published packages in report/query applications.
• Responds to general budget inquiries from Sandia Resort & Casino and Enterprise department managers.
• Assists finance team in preparing, reviewing, and analyzing data for preparation of budgets.
• Punctual and regular attendance is an essential responsibility for all team members and are expected to report to work based upon the assigned schedule each day in accordance with the Attendance Policy for Pueblo of Sandia.

Additional Responsibilities:

Performs additional duties as necessary.

Key Performance Indicators:

This position has Key Performance Indicators (KPI's) identified as a measurement of success. KPI's will be shared with all team members who work in this job title and feedback will be provided regarding the successful completion of the KPI's as part of the performance review process.

Knowledge, Skills, and Abilities:

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

Education and Experience:

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

License/Certifications/Registrations:

CPA License is preferred Must be able to obtain and maintain the required STGC Gaming License Will require a pre-employment and random drug screening.

Physical Requirements/Working Conditions:

The following selected physical activities are required to perform the essential functions of this position

Physical Requirement - Description:

Balancing - Maintaining body equilibrium to prevent falling and walking, standing, or crouching on narrow, slippery, or erratically moving surfaces. This factor is important if the amount of balancing exceeds that needed for ordinary locomotion and maintenance of body equilibrium.

Crouching - Bending the body downward and forward by bending leg and spine.

Feeling - Perceiving attributes of objects, such as size, shape, temperature,