Business Intelligence Developer

Virgin-Hotels; Las Vegas (NV); On-site; USD 90,000 - 130,000; Full time

Job summary

Virgin Hotels in Las Vegas is seeking a Business Intelligence (BI) Developer to design, build, and maintain scalable data solutions supporting analytics, finance, and operations. This onsite role partners with IT, Finance, and Operations to deliver trusted data assets.

The position involves developing SQL queries, building ETL pipelines with SSIS, and creating semantic models for Power BI and Tableau to deliver high-performance dashboards and reliable data delivery across the company.

Qualifications

• Strong SQL expertise with performance optimization.
• Experience with SQL Server and DB2 preferred.
• Data modeling and dimensional design experience.
• ETL development using SSIS and data warehousing knowledge.

Responsibilities

• Design, develop, and maintain scalable data solutions for analytics and reporting.
• Develop and optimize complex SQL queries and database objects.
• Build and maintain ETL pipelines using SSIS and integrate data across systems.
• Create semantic models and datasets for Power BI and Tableau.

Skills

Advanced SQL

Data modeling

Analytical thinking

BI tooling

ETL with SSIS

SQL Server knowledge

Education

Bachelor's degree in CS/Data Science

Tools

SSIS

Power BI

Tableau

SQL Server

DB2

Job description

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.

Requirements

THE NITTY-GRITTY (The Essential Job Duties)

• 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

WHAT IT TAKES (The Qualities We Look For)

• Advanc ed 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)
• Strong analytical and problem-solving skills

MUST HAVE'S

• 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

WOULD BE NICE TO HAVE'S

• 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

THE WORKING CONDITIONS

• 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 deadline s

VALUABLE TRAITS

• 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

This is not an exhaustive list of duties, responsibilities, and conditions.

*Virgin Hotels celebrates diversity and is proud to be an Equal Opportunity Employer*