Business Analyst- Greensburg

Overview

Function (Scope and Main Purpose of Job)The Business Analyst will gather and analyze data from various databases and sources, develop reports and visual representations, and provide analytics of all financial/operational processes within the company.  This will include develop reporting and analysis on forecasting/staffing, budgeting, operating/payroll costs, revenue, and Marketing programs  

• Supports, develops, and maintains effective communication and excellent relationship with internal customers ensuring their reporting requirements are identified and consistently met.
• Create and utilize SQL queries to provide visual representations and analysis of data for marketing management.
• Assist corporate team with metrics used company-wide for tracking staffing levels, accurate forecasting, and reporting of results to departments.
• Assist with reporting of industry and regional competitive intelligence and strategic planning.
• Review Standard Operating Procedures, streamline processes, and identify areas for improvement.
• Assist with planning and preparation for annual operating budgets including working closely with operating department management.
• Other duties as assigned.

Responsibilities

Core Service Standards

CLEAN: Must make the property shine and look impeccable while maintaining a neat CLEAN and crisp personal appearance

SAFE: Must make guests feel SAFE and comfortable through creating a worry free, carefree experience.

Fast: Provide FAST and efficient service with accuracy. Meet service time requirements and anticipate guest needs.

FRIENDLY: Greet each guest with FRIENDLY welcomes, making eye contact and smiling. Use H.E.A.R.T. steps to ease guest concerns. Say thank you to departing guests.

FUN: Work passionately as a team to create a FUN experience both for everyone who works and plays here

Specific Responsibilities and Duties

• Supports, develops, and maintainseffective communication and excellent relationshipwith internal customers ensuring their reporting requirements are identified and consistently met.
• Develop and support of a workforce managementsystem used company-widefor tracking staffing levels, accurate forecasting,and reporting of results to departments.
• Assist with reporting of industry and regional competitive intelligence and strategic planning.
• Review Standard Operating Procedures, streamline processes, and identify areas for improvement.
• Assistwith planning and preparation for annual operatingbudgets including working closely with operating department management.
• Other duties as assigned.

Qualifications

Job Requirements (skills, knowledge, and abilities)

• Ability to produce high quality reports with consistency, accuracy, and completeness.
• Ability to listen effectively, process information, ask appropriate questions for clarification and execute tasks accordingly.
• Ability to anticipate situations, tools needed, and obstacles through critical thinking and review of data.
• Flexibility and ability to work within a high growth, high stress, and fast paced environment and changing priorities. Must possess ability to prioritize conflicting duties and meet established deadlines, including occasional evenings and weekends.
• Ability to self-manage while consistently exercising good judgment and maturity.
• Strong research and business writing skills required.
• Must have initiative, strive for continuous improvement.  Proven ability in implementing innovative ideas or business solutions.

Educational Requirements

• One (1) to Three (3) years of experience in analytical reporting including development, data mining, and data analysis.
• A four (4)-year degree in Business or related field or equivalent work experience is preferred.
• Advanced knowledge of Microsoft Excel including SUMPRODUCT, XLOOKUP, pivot tables, conditional formatting, and other advanced calculations/functions is required.
• Experience with the following is preferred but not required: SQL, SSI,  Tableau, Kronos, Casino Insight, SSI, SWS and Aristocrat Oasis v12. 
• Knowledge of database layouts including table structures, joins, and relationships.
• Experience with Continuous Improvement programs is preferred but not required.
• Basic accounting experience or education is preferred but not required.
• Must be able to obtain and maintain a valid gaming license as determined by the Pennsylvania Gaming and Control Board for the position.

 Physical Requirements

• Ability to stand and walk for extensive periods of time and move up and down steps daily
• Ability to work in various weather conditions and assist guests in the loading and unloading process
• Ability to lift 20-30 pounds

Working Conditions

• 24/7 high energy casino with over 100,000 sq. ft of gaming and entertainment space and approximately 500 employees
• Exposed to alcohol, cigarette and cigar smoke, bright lights, and loud noises.
• You will work in an environment where smoking is allowed.