Business Intelligence Analyst

Spirit Mountain Gaming Inc; Oregon; On-site; USD 80,000 - 110,000; Full time

Job summary

Spirit Mountain Casino in Grand Ronde, Oregon is seeking a Business Intelligence Analyst to transform raw data into actionable insights. You will build dashboards, automate reports, and partner with leadership to drive data-driven decision making.

Responsibilities include SQL data pulls, data modeling, ETL processes, and mentoring staff while delivering accurate visuals in Power BI and Tableau. A Bachelor's degree and 2 years in BI are required; casino IT experience is a plus.

Qualifications

• Bachelor's degree in a relevant field.
• Two years of BI/Analytics experience required.
• Experience with databases and data reporting.
• Casino IT environment experience is preferred.

Responsibilities

• Collect, organize, and analyze data to create dashboards, visuals, and reports.
• Develop SQL queries to pull data from SQL Server databases for ad hoc analysis.
• Automate monthly reporting using BI tools currently in use.
• Evaluate processes and automate reporting and leadership dashboards.
• Capture business data requirements and document them for testing.
• Provide training and mentoring to staff on BI tools.

Skills

Data visualization

SQL queries

Data modeling

ETL processes

Decision support

Communication with leadership

Project multitasking

Education

Bachelor's degree in Mathematics, Data Analytics, Economics, CS, Statistics, or related field

Tools

Tableau

Power BI

Job description

Spirit Mountain Casino
27100 Salmon River Hwy
Grand Ronde, OR 97347, USA

Description

TITLE: Business Intelligence Analyst LAST UPDATED: October 14, 2026

DIVISION: Finance DEPARTMENT: Information Technology

COMP LEVEL: 14

________________________________________________________________

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.

This description intends to provide a representative summary of this position’s significant duties and responsibilities. Employee(s) may be required to perform position-related tasks other than those specifically listed in this description.

Essential Job Functions:

• 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.

Required Knowledge of:

• 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.
• 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.

Equipment and Tools Utilized:

• Equipment utilized includes personal computers and standard office equipment.

Equal Opportunity Employer
This employer is required to notify all applicants of their rights pursuant to federal employment laws.For further information, please review the Know Your Rights notice from the Department of Labor.