Business Intelligence Engineer

Westgate Resorts; Town of Florida (NY); On-site; USD 120,000 - 150,000; Full time

Benefits offered by this job

Health benefits

Paid time off

401(k) matching

Daily pay

Parental leave

Wellness programs

Tuition assistance

Career growth

Employee discounts

Job summary

Westgate Resorts is seeking a Business Intelligence Engineer to design and maintain scalable data pipelines and analytics datasets. You will transform raw data into analytics-ready datasets and develop robust reporting solutions to support strategic decisions across Westgate.

The role focuses ~65% on backend ETL development using SQL, Alteryx, Python, Snowflake, and Oracle, and ~35% on Tableau dashboards and business insights. Not eligible for visa sponsorship.

Qualifications

• Experience building ETL workflows (65% backend ETL; 35% reporting) using SQL, Alteryx, Python, Snowflake, Oracle.
• Proficient in designing dashboards with Tableau and data storytelling for multiple stakeholder groups.
• Strong understanding of data quality, reconciliation, and scalable data pipelines.

Responsibilities

• Design, build, and maintain automated data pipelines and analytics datasets.
• Develop Tableau dashboards for Inventory, Operations, Marketing, Call Center, Loyalty, and executives.
• Provide analysis and insights across Inventory, Yield, Operations, and Revenue streams.
• Collaborate with IT and business teams to translate requirements into ETL workflows and reporting outputs.
• Ensure data integrity and accuracy across data sources.

Skills

ETL development

SQL

Alteryx

Python

Snowflake

Oracle

Tableau

Analytical skills

Data modeling

Education

Associate’s degree in Computer Science, Data Science, Statistics, Applied Mathematics

Bachelor’s degree preferred

Tools

LMS

TSW

Job description

Westgate Resorts is the largest privately held timeshare company in the world, with 60+ resorts in top destinations like Orlando, Las Vegas, Gatlinburg, Park City, and Myrtle Beach. Recognized by U.S. News & World Report as one of the Best Companies to Work For, we’re committed to creating a supportive, rewarding workplace where our 9,000 Team Members can grow and thrive. Since 1982, we’ve delivered unforgettable vacations through exceptional service, innovation, and community engagement. With the recent addition of VI Resorts by Westgate, our footprint now includes the Pacific Northwest, Hawaii, Canada, and Mexico. Join us and be part of a team that values passion, integrity, and excellence, where your work helps create memories that last a lifetime.

Westgate Resorts is the largest privately held timeshare company in the world, with 60+ resorts in top destinations like Orlando, Las Vegas, Gatlinburg, Park City, and Myrtle Beach. Recognized by U.S. News & World Report as one of the Best Companies to Work For, we’re committed to creating a supportive, rewarding workplace where our 9,000 Team Members can grow and thrive. Since 1982, we’ve delivered unforgettable vacations through exceptional service, innovation, and community engagement. With the recent addition of VI Resorts by Westgate, our footprint now includes the Pacific Northwest, Hawaii, Canada, and Mexico. Join us and be part of a team that values passion, integrity, and excellence, where your work helps create memories that last a lifetime.

Job Description

The Business Intelligence Engineer is responsible for designing and maintaining scalable data pipelines, transforming raw data into analytics-ready datasets, and developing robust reporting solutions that support strategic decision-making across Westgate. Approximately 65% of this role consists of backend ETL development using SQL, Alteryx, Python, and Snowflake, and 35% involves building Tableau dashboards, analytical reports, and business insights. The Engineer supports a wide range of business functions including Inventory Control, Yield, Operations, Call Center/Dialer, Loyalty/Owner Engagement, and Executive leadership. This role gathers business requirements, interprets operational logic, and translates them into automated workflows and scalable BI solutions that improve data quality, operational efficiency, and revenue performance.

This position is not eligible for employment visa sponsorship (H-1B, L-1, O-1 or CPT/OPT).

Backend ETL Development (≈ 65%)

• Designs, builds, and maintains automated data pipelines using SQL, Alteryx, Python, Snowflake, and Oracle.
• Gathers and documents business requirements and operational logic from stakeholders across the org.
• Translates nuanced business rules from Yield, Inventory, Operations, Dialer, and Loyalty into accurate and scalable ETL processes.
• Cleans, transforms, reconciles, and validates large datasets from LMS, TSW, Oracle, and other systems.
• Optimizes pipeline performance, reliability, and data freshness.
• Partners with IT on schema alignment, integration issues, and resolving data flow inconsistencies.
• Maintains documentation for data models, transformation logic, and pipeline dependencies.

Reporting Development & Dashboarding (≈ 35%)

• Develop, enhance, and maintain Tableau dashboards used across Inventory, Operations, Marketing, Call Center/Dialer, Loyalty/Owner Engagement, and executive teams.
• Build reporting assets that support forecasting, budgeting, operational oversight, and yield optimization.
• Conduct unit testing and validate output logic to ensure accuracy and consistency.
• Improve report design, automation, usability, and performance for business stakeholders.

Business Support, Analysis & Insights

• Provide analytical and reporting support across multiple operational domains, including:
• Inventory Control & Yield Management
• Operations & Resort Performance
• Call Center / Dialer Performance & Workforce Management
• Loyalty / Owner Engagement & Retention
• Sales, Finance, and Executive Leadership
• Analyze trends, performance drivers, call behavior, channel utilization, and operational metrics to identify risks, inefficiencies, or opportunities.
• Develop insights and recommendations that inform staffing, revenue strategies, inventory allocation, owner engagement, and overall operational efficiency.
• Support ad hoc business questions by building quick-turn analyses and clearly presenting findings.

Cross-Functional Collaboration

• Partners with stakeholders across Inventory, Marketing, Operations, Loyalty, Finance, Call Center, and IT to gather requirements and understand process logic.
• Facilitates requirement-gathering sessions to ensure ETL workflows and reporting outputs reflect real business rules and KPIs.
• Works with IT to ensure accuracy, alignment, and performance across data sources.
• Collaborates with operational leaders to implement analytical solutions and validate results.

Data Integrity & Quality Assurance

• Performs routine validation, reconciliation, and quality checks across systems and automated workflows.
• Investigates anomalies and escalate issues appropriately.
• Ensures final reporting outputs meet high standards of accuracy, reliability, and consistency.

Other duties as assigned.

Qualifications

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skills, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Experience

• 3-5 years of relevant experience developing ETL workflows in Alteryx, Python, and/or comparable tools.

Education & Certifications

• Associate’s degree in Computer Science, Data Science, Statistics, Applied Mathematics, or related field.
• Bachelor’s degree preferred.

Skills/Knowledge

• Familiarity with Snowflake, Oracle, LMS, TSW, and enterprise data ecosystems.
• Proficiency with Tableau or similar data visualization tools.
• Advanced Excel proficiency (pivot tables, formulas, modeling).
• Ability to manage large datasets and perform detailed reconciliation.
• Ability to understand complex operational processes and translate them into technical requirements.
• Strong quantitative skills, with the ability to interpret trends and identify business impacts.
• Understanding of sales forecasting, yield concepts, call center metrics, and operational KPIs.
• Ability to learn and adapt quickly to new processes and technologies.
• Ability to communicate technical concepts clearly to non-technical stakeholders.
• Strong verbal and written communication skills.
• Comfortable facilitating requirement sessions and documenting business rules.
• Ability to present insights and findings clearly and professionally.
• Highly organized with the ability to manage multiple projects simultaneously.
• Strong attention to detail and a commitment to accuracy.
• Ability to work independently and cross-functionally.
• Demonstrated initiative, follow-through, and problem-solving ability.
• Ability to independently analyze complex situations, identify patterns and trends, and evaluate multiple options for solving complex or ambiguous problems.
• Ability to adapt to changing circumstances.

Additional Information

Why Westgate?

• Comprehensive Health Benefits – Medical, Dental, and Vision Coverage
• Paid Time Off – Vacation, Sick, and Personal Time to Recharge
• Paid Holidays
• 401(k) with Generous Company Match to Support Your Future
• Daily Pay – Access Your Earnings When You Need Them
• Family-Focused Benefits – Pregnancy, Parental Leave, and Adoption Assistance
• Wellness Programs to Support Your Well-Being
• Flexible Spending Accounts (FSA)
• Tuition Assistance to Help You Grow Your Career
• Military Leave
• Employee Assistance Program (EAP) – Support When You Need It Most
• Life, Disability, Accident, Critical Illness, and Hospital Insurance
• Pet Insurance for Your Furry Family Members
• Loyalty Program – Exclusive Discounts on Hotels, Cruises, Resorts, Restaurants, Entertainment, and More
• Low-Cost Gym Membership
• NEW! David A. Siegel Legacy Scholarship – Up to $40,000 for Team Members’ Dependents
• Career Growth and Advancement Opportunities
• Community Involvement – Give Back and Make an Impact

Westgate Resorts is an Equal Employment Opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, disability status or any other protected status under federal, state or local law. If you have a disability and believe you need a reasonable accommodation in order to complete your application or any part of the recruiting process, please email [e-mail] with the job title and the location of the position for which you are applying.

This job posting is intended to provide a general overview of the position and may not include every responsibility, duty, or qualification required. Duties, responsibilities, and activities may change at any time with or without notice.