This position is responsible for acquiring, analyzing, and maintaining information and data from sources used for appraisals, market feasibility studies, impact analyses, and economic impact studies for hotels and leisure properties. The individual in this position evaluates and ensures the accuracy of internal spreadsheets and models.  In addition, this position provides general IT support to the office and evaluates and recommends IT improvements to the organization.

Responsibilities/Essential Duties:

• Maintain complex spreadsheets with industry-specific information, including a list of all waterparks, hotel and amusement expense comparables, occupancy and ADR listings, hotel sales listings, and others
• Assure accurate information and validate formulas in spreadsheets
• Set up Excel models for feasibility and appraisal-related projects
• Research and collect data from online and print sources to update files and spreadsheets
• Determine best research and reporting methods to use for various hospitality-related projects
• Conduct market area research by phone and online
• Proofread reports for grammatical, mathematical, and formatting errors
• Understand, support, and improve Excel models for various studies
• Evaluate and update IT resources
• Provide first-level internal IT support, as needed
• Work with IT support provider to escalate issues and coordinate technology implementation

Education and Experience:

• Bachelor’s degree in a related discipline (e.g., Math, Computer Science, Accounting, Business, or Statistics) or equivalent years of experience
• Advanced proficiency in Excel
• Excellent written communication skills
• Strong analytical and research skills
• Internet research proficiency
• Ability to work independently
• Interest in the hospitality and accounting industries a plus

Competencies:

• Math and accounting skills
• Financial analysis
• Report writing skills
• Analytical and problem-solving skills
• Organizational and multi-tasking skills
• Advanced Microsoft Office skills, including ability to use Excel formulas
• Business acumen
• Communication
• Independent decision-making
• Diagnostic skills
• Quality focused

Physical Demands:

• Prolonged periods sitting at a desk and working on a computer
• Ability to lift up to 15 pounds, at times