Data Analyst Full-time $61,880 - $74,360/year, DOE

at  Breckenridge Grand Vacations

Description:
Consistently recognized as a Top National and Colorado Workplace, Breckenridge Grand Vacations builds, markets, and operates luxurious resort properties. Breckenridge Grand Vacations seeks a Data Analyst. This position is responsible for quantitative & qualitative analysis, reporting, and data mining across BGV’s finance, marketing, operations, and sales divisions. At its highest level, this position identifies the business’ analytical needs, collaborates with the analytics team & business intelligence, develops thoughtful analyses, and effectively communicates findings and recommendations to key decision-makers including executive leadership. The application window closes on November 5th, 2024.

In 2018, based on anonymous employee feedback, the Denver Post named BGV the top large workplace in Colorado. In 2020, we were again ranked in the top five. In 2023 and 2024, USA Today recognized us as a national top workplace! BGV is all about Sharing Smiles, including putting smiles on the faces of our employees! Learn more about BGV, including our three-decade history of success, here at breckenridgegrandvacations.com. The salary offered to the successful candidate will be based on job-related education, training, and experience. The salary offer will not be based on a candidate’s salary history at other jobs, and by law, BGV will not seek information about salary history or applicant age. This position also includes BGV’s Total Compensation package

• Group life insurance
• Health, vision, and dental insurance plans
• Retirement plan
• Twice yearly bonus
• Employee recruiting bonus
• Tuition reimbursement program
• Professional development
• Employee Wellness programs to support physical and mental health
• Sustainability programs to support the health of the planet
• BGV’s unique FUN benefits include programs for ski/rec center passes and ski medallions, lodging and purchase discounts, outdoor gear discounts, access to BGV’s Ball Arena suite in Denver for concerts and events, Rockies, Avalanche, Nuggets and Rapids tickets, access to local events, employee outings, team sports, discounted vacations through Interval International, and the legendary BGV Holiday Party.

SUMMARY: The Data Analyst is responsible for quantitative & qualitative analysis, reporting, and data mining across all of BGV’s finance, marketing, operations, and sales divisions. At its highest level, this position identifies the business’ analytical needs, collaborates with the analytics team & business intelligence, develops thoughtful analyses, and effectively communicates findings and recommendations to key decision-makers including executive leadership.

ESSENTIAL DUTIES AND RESPONSIBILITIES: Including but not limited to:

• Understand and facilitate the integration of various business processes, people, software, data, and relevant technology to identify, configure, and communicate meaningful information that supports and drives decision making across all divisions of the company.
• Leverage Tableau, MS Excel, and other BI tools for analysis, reporting, data visualization, self-service support, across disparate systems. Analysts must stay abreast of changes and improvements within the software to maximize value.
• Provide pertinent information to BGV managers and executives by assembling and summarizing data, developing thorough analyses, preparing reports, identifying business solutions, making presentations of findings, and recommending courses of action.
• Build and maintain analytical models, dashboards, reports, and templates to drive awareness and understanding of key performance indicators while ensuring quality, accuracy, and a focused analytic review.
• Utilize data analysis skills to perform full lifecycle analytics including gathering requirements, design and development of analytic data sets, data mining, data quality assessment, data profiling, analytical infrastructure maintenance, and predictive analytics support.
• Convert business expectations into data analysis while recognizing the audience and effectively communicating complexities at an executive level.
• Financial Analysis and Reporting:
• Pro forma financial statements; revenue/expense budget development and variance tracking; profit/cost efficiencies; resort financing & hypothecation; accounts receivable management; tax reporting; prospective resort development
• Marketing Analysis and Reporting:
• Campaign strategy and segmentation; program, CRM, website, lead generation, and call center performance; property tour conversion; tour budgeting; tour show-rate tracking; no show predictions; product affinity; customer list building & targeting
• Operations Analysis and Reporting:
• Resort occupancy, owner usage, exchange usage, rental inventory and revenue management, average daily rates, guest outreach, owner support, reservation & contact center, vacation rentals, resort operations department performance, guest surveys
• Sales Analysis and Reporting:
• Sales volume forecasting; inventory control; pricing & commission management; agent performance; tour prospect ranking; tour scheduling enhancements; Volume Per Guest (VPG) budgeting; sales management and administrative initiatives
• Uphold Hospitality Standards, Company Core Standards and Department Core Standards and observing Company policies and procedures.
• Be the “End of the Line” and resolve every situation inherited, not passing it along, whenever possible.
• Follow up on any situation that is not fully resolved at the time of the initial request always giving consideration to what the guest, owner and/or management deems appropriate.
• Respond promptly to all email and voicemail correspondence.
• Maintain a positive working relationship with guests, owners, co-workers and vendors to satisfy their financial analysis related requests, always being helpful and courteous.
• Adhere to Company appearance standards at all times.
• Attend and participate in training sessions and department staff meetings.

MARGINAL DUTIES: Functions that are not considered essential to the job.

• Follow Company guidelines for environmental sustainability practices (recycling, composting and conserving resources) and participate in the Company’s sustainability initiatives.
• Perform other duties as assigned.

Requirements:
QUALIFICATIONS: To perform this job successfully this position must be able to perform each essential duty satisfactorily. The requirements listed are representative of the knowledge, skill and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
COMPETENCIES / SKILLS / ATTRIBUTES: To perform the job successfully an individual should possess the following competencies, skills and attributes: Experience using statistical, sensitivity, quantitative and qualitative analyses * Experience with data mining and working with large data sets * Experience analyzing historical trends and developing assumptions to forecast future performance * Strong attention to detail with excellent communication skills * Exercise discretion and independent judgment with respect to matters of significance * Take initiative and perform tasks without being asked * Pay attention to detail and demonstrate accuracy and thoroughness * Provide exceptional internal customer service and anticipate needs * Give and receive feedback and ask for clarification when necessary * Treat people with respect and consideration and approach others in a tactful manner * Remain calm and empathetic in situations that can be challenging with guests or owners * Support the team’s effort to succeed by giving and welcoming feedback, building morale and contributing a positive team spirit * Stay informed on the company, properties, ski resort, and town developments * Strive to develop skills, sharing expertise with others * Use equipment and materials properly * Observe safety procedures and report potentially unsafe conditions.
EDUCATION/EXPERIENCE: Bachelor’s degree from a four-year college or university in Finance, Accounting, Economics, Statistics, Math, Computer Science, or other related field; or two + years related experience and/or training; or combination of education and experience. MBA or MS in Finance, Accounting, Statistics, Math, Real Estate or related fields a plus.

COMPUTER EXPERIENCE: Has advanced abilities in MS Excel (and other MS Office programs) and is proficient in Tableau and/or other complex analytical tools. Can develop spreadsheets, write complex formulas, and automate processes. Proficiency reading and writing code/queries using VBA and SQL is a plus. Ability to type quickly by touch, operate a personal computer and accurately record time worked, in the correct department, using the Company time keeping system. Can operate and make minor repairs to office machines (copier, fax, scanner, phone, and calculator).

• Advanced abilities in Tableau and MS Excel (other data visualization and BI tools ok but Tableau is preferred)
• Experience and knowledge of various statistical programming languages (Python, R, MATLAB)
• Proficiency in reading and writing code/queries in SQL and Visual Basic (VBA)

LANGUAGE ABILITY: Ability to speak, read, and write in English. Ability to read, analyze, and interpret financial information. Ability to write routine reports and correspondence. Ability to speak effectively before groups of customers or employees of organization.
MATHEMATICAL SKILLS: Ability to calculate figures and amounts such as discounts, interest, commissions, proportions, percentages, area, circumference and volume. Ability to apply concepts of basic algebra and geometry. Ability to work with mathematical concepts such as probability and statistical inference. Ability to apply concepts such as fractions, percentages, ratios and proportions to practical situations.
REASONING ABILITY: Ability to apply common sense understanding to carry out instructions furnished in written, oral or diagram form. Ability to deal with problems involving several concrete variables in standardized situations. Ability to define problems, collect data, establish facts and draw valid conclusions.

PHYSICAL DEMANDS: The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job.

• Perform repetitive motions of the arms, elbows, wrists, hands and fingers over 2/3 of the time.
• Use arms, hands and fingers to handle, grasp, and reach over 2/3 of the time.
• Sit and work at a computer terminal over 2/3 of the time.
• Speak and listen within the office and over the telephone between 1/3 and 2/3 of the time.
• Stand, walk, stoop, kneel, crouch or crawl for under 1/3 of the time.
• Push using upper extremities to press with force in order to thrust forward, downward or outward under 1/3 of the time.
• Pull using upper extremities to exert force in order to draw, haul or tug objects in sustained motion for less than 1/3 of the time.
• Lift between 10 -25 pounds less than 1/3 of the time.
• Requires close, distance, color and peripheral vision, close visual acuity, and depth perception.

WORK ENVIRONMENT: The environmental conditions the employee will have exposure to:

• Office or administrative environment
• Pets and pet dander while working in a pet friendly office.
• Moderate Noise

ESSENTIAL DUTIES AND RESPONSIBILITIES: Including but not limited to:

• Understand and facilitate the integration of various business processes, people, software, data, and relevant technology to identify, configure, and communicate meaningful information that supports and drives decision making across all divisions of the company.
• Leverage Tableau, MS Excel, and other BI tools for analysis, reporting, data visualization, self-service support, across disparate systems. Analysts must stay abreast of changes and improvements within the software to maximize value.
• Provide pertinent information to BGV managers and executives by assembling and summarizing data, developing thorough analyses, preparing reports, identifying business solutions, making presentations of findings, and recommending courses of action.
• Build and maintain analytical models, dashboards, reports, and templates to drive awareness and understanding of key performance indicators while ensuring quality, accuracy, and a focused analytic review.
• Utilize data analysis skills to perform full lifecycle analytics including gathering requirements, design and development of analytic data sets, data mining, data quality assessment, data profiling, analytical infrastructure maintenance, and predictive analytics support.
• Convert business expectations into data analysis while recognizing the audience and effectively communicating complexities at an executive level.
• Financial Analysis and Reporting:
• Pro forma financial statements; revenue/expense budget development and variance tracking; profit/cost efficiencies; resort financing & hypothecation; accounts receivable management; tax reporting; prospective resort development
• Marketing Analysis and Reporting:
• Campaign strategy and segmentation; program, CRM, website, lead generation, and call center performance; property tour conversion; tour budgeting; tour show-rate tracking; no show predictions; product affinity; customer list building & targeting
• Operations Analysis and Reporting:
• Resort occupancy, owner usage, exchange usage, rental inventory and revenue management, average daily rates, guest outreach, owner support, reservation & contact center, vacation rentals, resort operations department performance, guest surveys
• Sales Analysis and Reporting:
• Sales volume forecasting; inventory control; pricing & commission management; agent performance; tour prospect ranking; tour scheduling enhancements; Volume Per Guest (VPG) budgeting; sales management and administrative initiatives
• Uphold Hospitality Standards, Company Core Standards and Department Core Standards and observing Company policies and procedures.
• Be the “End of the Line” and resolve every situation inherited, not passing it along, whenever possible.
• Follow up on any situation that is not fully resolved at the time of the initial request always giving consideration to what the guest, owner and/or management deems appropriate.
• Respond promptly to all email and voicemail correspondence.
• Maintain a positive working relationship with guests, owners, co-workers and vendors to satisfy their financial analysis related requests, always being helpful and courteous.
• Adhere to Company appearance standards at all times.
• Attend and participate in training sessions and department staff meetings

MARGINAL DUTIES: Functions that are not considered essential to the job.

• Follow Company guidelines for environmental sustainability practices (recycling, composting and conserving resources) and participate in the Company’s sustainability initiatives.
• Perform other duties as assigned

PHYSICAL DEMANDS: The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job.

• Perform repetitive motions of the arms, elbows, wrists, hands and fingers over 2/3 of the time.
• Use arms, hands and fingers to handle, grasp, and reach over 2/3 of the time.
• Sit and work at a computer terminal over 2/3 of the time.
• Speak and listen within the office and over the telephone between 1/3 and 2/3 of the time.
• Stand, walk, stoop, kneel, crouch or crawl for under 1/3 of the time.
• Push using upper extremities to press with force in order to thrust forward, downward or outward under 1/3 of the time.
• Pull using upper extremities to exert force in order to draw, haul or tug objects in sustained motion for less than 1/3 of the time.
• Lift between 10 -25 pounds less than 1/3 of the time.
• Requires close, distance, color and peripheral vision, close visual acuity, and depth perception