Business Intelligence Analyst
Spirit Mountain Casino•Grand Ronde, OR
About The Position
This position supports leadership across the organization by gathering, organizing, verifying, and visualizing data to improve insight and decision-making. The Business Intelligence Analyst works closely with the executive leadership team and data specialists to develop dashboards and reporting that support data-centric business management. The role uses business experience and judgment to plan and accomplish varied goals and complex tasks, with a wide degree of creativity and latitude.
Requirements
- Bachelor's degree in Mathematics, Data Analytics, Economics, Computer Science, Statistics, Business, or a related field, or an equivalent combination of education, training, and experience.
- Two years of Business Intelligence/Analytics experience.
- Experience with databases and data reporting.
- Experience with BI/data visualization tools such as Tableau or Power BI.
- Experience with data modeling and ETL processes.
- Experience leading requirements-gathering sessions and documenting business requirements for large-scale business intelligence projects.
- Experience writing SQL queries.
- Excellent Excel skills.
- Working knowledge of collaboration, file-sharing, and version-control tools.
- Ability to communicate technical concepts effectively to executive leadership and translate complex data into actionable insights.
- Strong written and verbal communication, collaboration, and facilitation skills, including the ability to work effectively with business users, technical teams, project managers, senior management, and vendors.
- Proven business analysis and problem-solving skills.
- Ability to prioritize tasks and deliverables, work independently, and manage multiple projects simultaneously.
- Results-oriented approach and ability to make tough decisions to achieve goals.
- Ability to establish and maintain effective working relationships.
- High-security gaming license issued by the Grand Ronde Gaming Commission.
- Must be at least 21 years of age.
- May be required to provide documentation of, or receive, certain health vaccinations due to interactions with employees and the public.
Nice To Haves
- Prior experience in a casino IT environment.
Responsibilities
- Collect, organize, and analyze data to create visualizations, presentations, dashboards, and reports; identify data sources and transform raw data into usable, organized data connected with other datasets.
- Evaluate business processes, recurring meetings, and leadership reports for automation through business intelligence tools.
- Understand relationships among data sources, processes, systems, business issues, and people; support analytical business management, assess data quality and correlation, and analyze 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 retrieve data from SQL Server databases for ad hoc analysis.
- Ensure accuracy and consistency in visualizations and continuously improve existing visualizations, dashboards, presentations, and reports.
- Automate monthly reporting using the tool selected by Spirit Mountain Casino, currently Power BI among other systems.
- Help design, document, and maintain system processes.
- Provide technical assistance in training, mentoring, and coaching professional and technical staff.
- Track and document changes to functional and business specifications and write detailed procedures for permanent records and training.
- Model Spirit Mountain's Spirit of Excellence in alignment with SMGI's Pride Values, Brand Promise, and Business Vision.
- Learn and comply with company and departmental policies and procedures, MICS, gaming regulations, and Title 31 Regulation requirements.
- Follow corporate and departmental safety policies and procedures.
