Business Intelligence Developer

The Business Intelligence (BI) Developer is an onsite/non-remote role that will design, build, and maintain scalable data solutions that support operational performance, financial analysis, and strategic decision-making across the organization. This role partners with IT, Finance, and Operations to deliver accurate, reliable, and high-performance data assets.

• Design, develop, and maintain scalable data solutions for analytics and reporting
• Develop and optimize complex SQL queries, stored procedures, and database objects
• Build and maintain ETL pipelines using SSIS
• Integrate and reconcile data across Agilysys LMS, IGT Advantage, and other systems
• Contribute to data warehouse design including dimensional modeling
• Develop semantic models and datasets for Power BI and Tableau
• Translate business requirements into technical data solutions
• Identify and resolve data quality and performance issues
• Optimize BI reports and dashboards for performance and usability
• Implement monitoring, logging, and error handling for data pipelines
• Support audit and compliance reporting requirements
• Collaborate with cross-functional teams to ensure trusted data delivery
• Perform other duties as assigned

• Advanced SQL expertise including query optimization and execution plans
• Experience with SQL Server; DB2 preferred
• Strong data modeling and relational design skills
• Hands-on ETL experience using SSIS
• Data warehousing experience (star schema, fact/dimension modeling)
• Power BI and Tableau development experience
• Strong analytical and problem-solving skills

• Current, legal, and unrestricted ability to work in the United States
• 3+ years of experience in BI, analytics, or data development
• Advanced SQL expertise required
• Experience with ETL development (SSIS preferred)
• Experience with BI tools such as Power BI or Tableau

• Experience with Agilysys LMS and/or IGT Advantage preferred
• At least two years of development experience preferably in a high volume, complex casino environment
• Bachelors' Degree in Computer Science, Data Science or a related field

• Work in an environment that is subject to varying levels of sound, temperature, smoke, and vibration
• Review and comprehend all necessary documentation
• Use a computer keyboard
• Effectively and efficiently move from floor to floor as needed
• Lift up to 20 pounds
• Must be able to withstand prolonged standing, stretching, climbing, bending, and kneeling without restriction, work indoors and be exposed to various environmental factors such as, but not limited to, CRT fatigue, noise, dust, cigarette smoke, and pet dander/hair
• Must be able to work in a fast-paced, busy, and somewhat stressful environment, and maintain physical stamina and mental attitude while dealing effectively with guests, management, team members, and outside contacts while working under pressure and meeting deadlines

• 50% logical / 50% creative / 100% AWESOME
• Enjoy working with a team and alone as the situation dictates
• Adaptive, Flexible!
• Embody "great attitude"
• Unwavering integrity and endless work ethic
• Appreciate constructive feedback, as well as graciously providing the same
• Tenacious and self-motivated