Mortgage Analytics Tableau Analyst Intern

Pay: $20/ Hour

About Westgate Resorts
Westgate Resorts provides a diverse range of vacation experiences. From sandy beaches on the Atlantic Ocean to snow-covered Utah mountains, families can affordably experience the country's most desirable vacation destinations. A world leader in the timeshare and hospitality industry, Westgate has resorts in Florida, Tennessee, South Carolina, Missouri, Utah, Nevada, and Arizona. Westgate meets every vacation expectation, for every family, for every budget. As we continue growing, we will continue offering the best and most-affordable vacation options out there!

Westgate Resorts has a one-year internship starting in Summer 2025 on the Mortgage Reporting & Analytics Team.  This internship is designed for undergraduates in their senior year or students in a graduate program, leveraging their degree background such as Finance, Accounting, or Computer Science.  Throughout the year, the intern will develop and utilize a blend of Excel, Tableau, and data development skills, to create reporting, analysis, and answer ad hoc questions.  This internship will provide:

• Real world experience working in a corporate environment; developing an understanding of culture, social norms, interacting with and communicating with others
• Direct exposure working on a specific team with other seasoned analysts and mentorship opportunities
• Technical skill development utilizing tools such as Excel, Tableau and SQL
• Soft skill development such as written and oral communication, collaboration, and prioritization management
• Exposure to working with senior management
• Developing a baseline understanding of Westgate’s business, systems, definitions, and industry terms
• An opportunity to pursue full-time employment on the team or at Westgate

The Mortgage Reporting and Analytics team is responsible for (i) overseeing and supporting performance reporting and analysis for Westgate’s mortgage portfolio, (ii) providing working capital by pledging those loans to banks and investors, and (iii) provide strategic business support.  The mortgage analytics internship will have an emphasis on Tableau development, and will be primarily focused on:

• Collections and support staff operations reporting
• Funding management support and reporting (how Westgate monetizes the loans it writes to owners)
• Mortgage portfolio performance reporting and analysis (e.g. how are loans performing based on FICO score?)
• Updating and enhancing our existing suite of Tableau reports
• Ad hoc operational support (e.g. how many loans were written for a particular sales center)
• Optimizing and organizing existing reporting where applicable
• New Tableau reporting supporting other groups such as Digital Marketing, Social Media, Loyalty
• Special projects as assigned

The first three to six months will be focused on establishing a base level understanding of the team, the business, our data and reporting systems, and owning a portfolio of routine operational reports.  This provides a learning foundation and path for success in the internship. 

Month’s six through twelve will build on your initial skills/experience to complete more complex ad hoc requests involving a higher degree of problem solving.  The internship is designed to offer progressively more challenging requests as you become proficient in successfully accomplishing tasks.  By the end of the internship, you will have:

• A foundational knowledge of the business of timeshare and Westgate with a primary focus on the mortgage portfolio
• Hands on experience updating and delivering a portfolio of routine reporting
• Exposure to our SQL based data warehouse; how it functions and serves as a cornerstone tool
• Learning data as a language and way of thinking; you will learn how to read and write SQL
• Experience using both Excel and Tableau to present information and create dashboards
• Understand the strengths, weaknesses, and appropriate application of when to use Excel vs Tableau
• Exposure to the funding management process
• Experience in receiving abstract direction and translating into a concrete deliverable
• Experience in prioritization management, handling complex requests, and working through competing priorities

• Coursework and advanced experience utilizing Excel – the internship is designed to build on a pre-existing skillset
• Coursework or experience using Tableau and working in a relational database environment
• Active undergrad in senior year or currently in Graduate School
• Anticipated or completed degree in Finance, FinTech, Engineering, or Computer Science
• Strong critical thinking, problem solving, and high attention to detail skills
• Excellent written and verbal communication skills
• Self-motivated and uses time effectively

Why Westgate?

• Get access to your pay as you need it with our Daily Pay benefit
• Wellness Programs
• Fun, family culture
• Exclusive discounts for Team Member (i.e., hotels, resorts, restaurants, entertainment, etc.)
• Advancement & development opportunities
• Community Involvement Programs

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 [email protected] with the job title and the location of the position for which you are applying.