Business Intelligence Developer

Virgin Hotels, LLC; Las Vegas, Northern (NV, KY); Hybrid; USD 90,000 - 120,000; Full time

Job summary

Virgin Hotels, LLC is seeking an on-site BI Developer to design, build, and maintain scalable data solutions that empower analytics, finance, and operations. You will optimize SQL objects, develop ETL pipelines with SSIS, and deliver reliable data assets for Power BI and Tableau dashboards.

The role emphasizes data quality, performance, and collaboration with IT, Finance, and Operations to support auditing and strategic decision making across the organization.

Qualifications

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

Responsibilities

• 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 systems and data sources.
• Contribute to data warehouse design including dimensional modeling.
• Develop semantic models and datasets for BI dashboards.

Skills

Advanced SQL

SQL Server

DB2

Data modeling

ETL development

Power BI

Tableau

SSIS

Education

Bachelor's degree in Computer Science or related field

Tools

SSIS

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*