This position is responsible for maintaining the master budget spreadsheet for new and transition hotel openings, preparing the monthly funding request, reconciling the G/L on a monthly basis, and working with vendors as well as offsite warehouse management to ensure timely and accurate product storage and deliveries in a high-volume multi-state environment. Providing outstanding customer service and supporting the Department’s goals are of utmost importance. The Budget Analyst for Pre-Opening Hotels reports to the Assistant Director Hotel Acquisitions & Operating Analytics.
Essential Functions and Responsibilities
- Maintains accurate input of data into multi-tabbed Excel budget spreadsheet and keeps the integrity of the formulas and data
- Ensures projects stay within budget at all times by maintaining an accurate and up-to-date spreadsheet
- Identifies appropriate times to request invoices from vendors and preparation of monthly fundings.
- Ensures vendors submit correct invoices or obtain corrected ones when necessary
- Accurately prepares all funding backup and submits for review and approval by the monthly deadline
- Views and reconciles the G/L provided by Accounting on a monthly basis to ensure expenditures are in the appropriate budgets
- Maintains the order tracking, warehouse delivery, and hotel pick list spreadsheets
- Regular attendance in conformance with standards
- May be required to work varying schedules to reflect the business needs of the hotel
- Must be able to input and maintain a large amount of data with a high level of accuracy
- Must be able to develop working relationships with vendors to facilitate the pre-opening needs and demands
- Must be able to support Asst Dir Hotel Acquisitions & Operating Analytics with various side-projects/deadlines as they arise
- Required to attend all training sessions and meetings
- Other duties as assigned
Qualifications
Required:
- Mid-level knowledge in Excel - must be able to maintain spreadsheets with formulas, circular references, formula auditing, pivot tables and reporting, conditional formatting, advanced charting, and linking worksheets
- Must have a strong understanding of basic accounting regarding budget reconciliation and tracking and balancing G/Ls
Preferred:
- Mid-level knowledge in Excel - must be able to maintain spreadsheets with formulas, circular references, formula auditing, pivot tables and reporting, conditional formatting, advanced charting, as well as linking worksheets
- Must have a strong understanding of basic accounting in regard to budget reconciliation and tracking, and balancing G/Ls
Job Type: Full-time
Benefits:
- 401(k)
- 401(k) matching
- Dental insurance
- Flexible schedule
- Health insurance
- Life insurance
- Paid time off
- Parental leave
- Tuition reimbursement
- Vision insurance
Schedule:
- 8 hour shift
- Monday to Friday
Application Question(s):
- Are you able to commute or relocate to the Franklin, TN area?
- What is your desired hourly rate?
- How many years of accounting experience do you have?
Experience:
- Microsoft Excel: 5 years (Required)
Work Location: In person