Business Intelligence Analyst

Job Description : Position Summary :

Position Summary :

Under direct supervision of the Planning & Analysis Supervisor, the Business Intelligence Analyst develops and performs financial, operational, marketing, budgetary and technical analysis projects.

Uses the cost benefit approach to analyze all aspects of interdepartmental operations to maximize growth and return. Maintains confidentiality of all privileged information.

This list of duties and responsibilities is illustrative only of the tasks performed by this position and is not all-inclusive.

Essential Duties & Responsibilities :

• Assists the Planning & Analysis Director with developing revenue forecasts and expenditure projections to provide insight into the Enterprise meeting its budgetary goals
• Creates queries and maintains databases to develop analysis that answer key questions about gaming statistics and operational performance
• Identifies and evaluates areas of revenue impact to the hotel and food & beverage departments
• Actively participates in the development of the annual budget by working closely with departments to assist them in the creation their respective departmental budgets
• Analyzes financial statements, scorecards, and key performance indicators and investigates variances
• Develops reports pertaining to industry benchmarks, key performance metrics, scorecards, return on investment analysis and other reports and presentations to management
• Prepares reports related to finance, marketing and operational information in order to evaluate results in terms of profitability, performance against budget, performance against competitors and industry standards
• Prepares a variety of sensitive ad-hoc project reports based on requests from departmental leadership
• Evaluates gaming activity of the player database, marketing expenses, and reinvestment of casino players
• Reviews business processes and information flows to help improve the quality of business decision making
• Assists in the auditing of unusual transactions and budgetary variances
• Prepares reports on database activity to determine marketing return on investment.
• Prepares pro-forma event analysis and analyzes marketing, entertainment, and player development event performance to ensure effectiveness and gauge revenue impact
• Provides daily income statement reports to continuously track performance as compared to budget and prior year
• Actively reviews the health of the player database to evaluate growth and identify areas for improvement
• Serves as a resource and provides training within the Planning & Analysis department and to other departments as requested
• Provides daily updates on revenue trends for each operational area of the Enterprise
• Holds regular meetings with department management to review analysis and provide feedback
• Evaluates potential capital investment projects to determine return-on-investment
• Works independently on special projects as assigned
• Contributes to a team effort and accomplishes related results as required
• Actively tracks key performance indicators of the Enterprise to identify if targets are being met and actions to be taken to meet revenue and expense targets
• Performs other duties as required.

Job Requirements :

Minimum Qualifications :

Education and Experience :

Bachelor's Degree in Business Administration, Finance, Economics or related field plus five (5) years of analysis experience;

at least two (2) of the five (5) years must be in a casino environment; or equivalent combination of education and experience.

Relevant and direct experience may be considered in lieu of degree requirement. Masters' degree in related field preferred.

No felony, theft or stealing convictions. Must be able to pass a pre-employment drug / alcohol screen, background investigation, obtain and maintain a gaming license and to include the following :

Knowledge, Abilities, Skills, and Certifications :

• Skill in preparing, reviewing and analyzing operational and financial reports
• Skill in analyzing problems, projecting consequences, identifying solutions, and implementing recommendations
• Skill in statistical compilation and analysis
• Skill in database manipulation such as Crystal or SQL
• Skill in operating business computers and office machines, including working in a Windows environment, specifically Word, Excel, Access, presentation software (such as PowerPoint), and PC-based computerized accounting software
• Advanced Excel ability
• Ability to maintain confidentiality
• Ability to analyze situations and adopt appropriate courses of action
• Ability to work independently and meet strict time lines
• Ability to make solid decisions and exercise independent judgment
• Ability to work with mathematical concepts such as probability and statistical reference
• Ability to apply concepts such as fractions, percentages, ratios, and proportions to practical situations
• Ability to demonstrate outstanding guest service at all times
• Ability to establish and maintain professional relationships with individuals of varying social and cultural backgrounds and with co-workers at all levels
• Ability to interpret a variety of instructions furnished in written, oral, diagram, or schedule form
• Ability to meet time lines
• Ability to work under pressure
• Ability to work within a team, goal oriented environment
• Ability to solve practical problems and deal with a variety of concrete variables in situations where only limited standardization exists
• Ability to demonstrate excellence in everything, and continually seek improvement in results
• Ability to interpret applicable federal, state, county, and local laws, regulations, and requirements
• Ability to communicate, read, and write clearly in English
• Knowledge of business English, proper spelling, grammar, punctuation, and basic arithmetic

Physical Demands :

• While performing the duties of this job, the team member regularly is required to sit; use hands to finger, handle, or feel;
• reach with hands and arms; and talk or hear. The team member frequently is required to walk. The team member occasionally is required to stand;

and stoop, kneel, crouch, or crawl. The team member must occasionally lift and / or move up to 25 pounds.

Work Environment :

Work is generally performed in an office and casino setting with exposure to second-hand smoke and a high noise level. Evening, graveyard, holiday and / or weekend work may be required.

Extended hours and irregular shifts may also be required.