Business Intelligence Engineer

About Westgate Resorts

Westgate Resorts stands as the world's largest privately owned timeshare enterprise, boasting over 60 resorts in premier destinations such as Orlando, Las Vegas, Gatlinburg, Park City, and Myrtle Beach. Acknowledged by U.S. News & World Report as a top workplace, the company fosters a nurturing and rewarding environment for its 9,000 employees. Since its inception in 1982, it has been committed to delivering exceptional vacation experiences through innovation, service excellence, and community engagement. With the acquisition of VI Resorts, the company’s reach now extends to the Pacific Northwest, Hawaii, Canada, and Mexico. This role offers a chance to join a team valuing passion, integrity, and excellence, crafting lasting memories for guests.

Role Overview

The Business Intelligence Engineer will architect and maintain scalable data pipelines, convert raw data into analytics-ready formats, and develop comprehensive reporting solutions that empower strategic decision-making. Approximately 65% of the work involves backend ETL development with SQL, Alteryx, Python, Snowflake, and Oracle, while 35% focuses on creating Tableau dashboards and analytical reports. This role supports multiple departments including Inventory Control, Yield, Operations, Call Center/Dialer, Loyalty/Owner Engagement, and Executive teams. Responsibilities include gathering business requirements, interpreting operational logic, and devising automated workflows and BI solutions that enhance data accuracy, operational efficiency, and revenue performance.

Key Responsibilities

• Design and sustain automated data pipelines leveraging SQL, Alteryx, Python, Snowflake, and Oracle.
• Collect and document business needs and operational rules from various organizational stakeholders.
• Convert complex business rules from multiple functions into scalable ETL processes.
• Cleanse, transform, and validate extensive datasets from LMS, TSW, Oracle, and other systems.
• Optimize pipeline speed, reliability, and data currency.
• Collaborate with IT on schema alignment and resolve integration issues.
• Develop and maintain Tableau dashboards supporting Inventory, Operations, Marketing, Call Center, Loyalty, and Executive leadership.
• Create and refine reporting tools for forecasting, budgeting, operational monitoring, and yield optimization.
• Conduct tests to assure data and logic accuracy.
• Provide analytical and reporting support for inventory control, operations, call center, loyalty programs, sales, finance, and executive leadership.
• Analyze performance trends and operational metrics to identify issues and opportunities.
• Partner cross-functionally to gather requirements and validate analytical solutions.
• Execute data validation, reconciliation, and quality assurance procedures.
• Perform additional duties as assigned.

Qualifications and Skills

• 3 to 5 years’ experience in developing ETL workflows using Alteryx, Python, or similar tools.
• Associate’s degree in Computer Science, Data Science, Statistics, Applied Mathematics, or related disciplines; bachelor's degree preferred.
• Knowledge of Snowflake, Oracle, LMS, TSW, and enterprise data ecosystems.
• Proficient in Tableau or equivalent data visualization software.
• Advanced Excel skills including pivot tables, formulas, and modeling.
• Strong ability to handle large datasets and perform detailed data reconciliation.
• Competent in interpreting complex business processes and translating them into technical specifications.
• Strong quantitative analytical ability to discern trends and business impacts.
• Understanding of sales forecasting, yield management, call center metrics, and KPIs.
• Effective communication skills to explain technical concepts to non-technical audiences, facilitate requirement gathering, and present insights clearly.
• Highly organized, detail-oriented with the ability to manage multiple projects independently and collaboratively.
• Demonstrates initiative, problem-solving aptitude, adaptability, and follow-through.

Additional Information and Benefits

• Comprehensive health insurance including medical, dental, and vision coverage.
• Paid time off for vacation, personal, and sick leave.
• Paid holidays.
• 401(k) retirement plan with generous company matching.
• Daily pay access to earnings.
• Family benefits like pregnancy, parental leave, and adoption support.
• Wellness initiatives.
• Flexible spending accounts.
• Tuition assistance for career development.
• Military leave options.
• Employee assistance programs.
• Life, disability, accident, critical illness, and hospital insurance options.
• Pet insurance coverage.
• Employee loyalty discounts on travel and entertainment.
• Affordable gym memberships.
• David A. Siegel Legacy Scholarship: up to $40,000 for dependents of employees.
• Career advancement and community involvement opportunities.

This role is not eligible for visa sponsorship (H-1B, L-1, O-1, CPT/OPT). Westgate Resorts is an equal opportunity employer committed to diversity and accommodation for individuals with disabilities upon request.