Business Intelligence Analyst

Summary: This position is responsible for supporting leadership throughout the organization by gathering, organizing, verifying, and visualizing data to gain insight and improve decision-making. This position is expected to work closely with the executive leadership team and data specialists to develop dashboards and reporting that drive data-centric business management. This position relies on business experience and judgment to plan and accomplish various goals and complicated tasks. A wide degree of creativity and latitude is expected., * Collect, organize, and analyze data to create meaningful visualizations, presentations, dashboards, and reports. Identify data sources and transform raw data into usable, organized data that connects with other datasets.

• Evaluate business processes, recurring meetings, and leadership reports to automate these processes through business intelligence tools.

• Understand the links between data sources, processes, systems, business issues, and people to support analytical business management, assess data quality and correlation, and analyze and interpret trends or patterns in large complex datasets.

• Capture and document detailed business, functional, and data requirements in a traceable, testable, and verifiable manner.

• Create and execute user acceptance test cases and test datasets to validate system functionality.

• Develop SQL queries to pull data from SQL Server databases to deliver ad hoc analysis.

• Ensure data accuracy and consistency in all visualizations while continuously improving and enhancing existing visualizations, dashboards, presentations, and reports

• Automate monthly reporting leveraging the tool of choice for Spirit Mountain Casino (Currently PowerBI, among other systems)

• Help design, document, and maintain system processes.

• Provide technical assistance in training, mentoring, and coaching professional and technical staff.

• Track and fully document changes for functional and business specifications and write detailed procedures for permanent records and for use in training.

Spirit Mountain Standards:

• Delivers Spirit Mountain’s Spirit of Excellence by consistently modeling attitudes and behaviors in alignment with SMGI’s Pride Values, Brand Promise, and Business Vision.

• Learns, comprehends, and complies with all Company and departmental policies and procedures, MICS, gaming regulations, and Title 31 Regulation requirements.

• Follows all Corporate and departmental safety policies and procedures.

• Ability to communicate technical concepts effectively to executive leadership.

• Experience with BI/Data Visualization tools (Tableau, Power BI, etc.).

• Ability to prioritize tasks and deliverables.

• Results-oriented with the ability to make tough decisions to achieve goals.

• Experience with data modeling and ETL processes

• Working knowledge of collaboration, file sharing, and version control tools.

• Experience leading requirements gathering sessions and documenting associated business requirements for large-scale Business intelligence projects.

Required Skills in:

• Demonstrates powerful communication skills (written and verbal).

• Interacts well with business users/technical team/project managers/senior management/vendors.

• Experience writing SQL queries.

• Excellent Excel skills.

• Proven business analysis and problem-solving skills.

• Strong collaboration and facilitation skills with cross-functional teams.

• Excellent communication skills and can translate complex data into actionable insights.

• Establishing and maintaining effective working relationships with others.

• Ability to work independently and manage multiple projects simultaneously

Education, Experience, Licenses, Registrations, and Certifications:

• Bachelor’s Degree in Mathematics, Data Analytics, Economics, Computer Science, Statistics, Business, or a related field or equivalent combination of education, training, and experience.

• Two (2) years of Business Intelligence/Analytics experience required.

• Experience with databases and data reporting.

• Prior experience in a casino IT environment is preferred.

• High-security gaming license issued by the Grand Ronde Gaming Commission.

• Must be 21 years of age.

• Due to the nature of the interactions with other employees and the public we serve, employees may be required to provide documentation of, or receive, certain health vaccinations.

Environmental Factors and Conditions/Physical Requirements:

• Work is performed in an office environment with occasional exposure to tobacco smoke and noise common to gaming environments.

• Work is subject to frequent sitting and occasional walking, bending, reaching, and lifting up to 25 pounds.