Revenue Analytics & Systems Specialist

First Hospitality; Chicago (IL); On-site; USD 70,000 - 95,000; Full time

Benefits offered by this job

Insurance enrollment from DAY 1

PTO from DAY 1

Holiday pay from DAY 1

401(k) after 30 days

Hotel and travel discounts

Professional development opportunities

Job summary

First Hospitality is seeking a detail-oriented Analytics & Systems Specialist to support hotel pricing optimization, market share growth, and topline forecasting across its Chicago portfolio. The ideal candidate brings advanced Excel skills, strong analytics, and hospitality experience in revenue management.

You’ll collaborate with Revenue Leaders and cross-functional teams to build and maintain reporting tools, monitor performance, and drive data-informed decisions that improve efficiency and

Qualifications

• 2+ years in reporting, revenue management, or business analysis in hospitality.
• Advanced Excel skills (pivot tables, XLOOKUP, Power Query, OLAP).
• Familiarity with hotel revenue systems is a plus.
• Excellent communication and collaboration skills.

Responsibilities

• Build and maintain Excel-based reports and dashboards for pricing, forecasting, and performance tracking.
• Support monthly and annual forecasting by preparing and validating data inputs.
• Conduct audits on distribution, rate loading, and other revenue-impacting processes.
• Train new team members on tools, systems, and department processes.
• Develop and refine reporting methodologies and explore automation opportunities.
• Evaluate and implement AI tools to improve reporting efficiency and data accuracy.

Skills

Analytical mindset

Attention to detail

Communication

Multitasking

Education

Bachelor’s degree in Hospitality/Business/Finance

Tools

Excel

Power Query

XLOOKUP

OLAP Data Cubes

Job description

What's in it for you…

• Insurance enrollment available from DAY 1!
• Paid time off available from DAY 1!
• Holiday pay available from DAY 1!
• 401(k) enrollment after 30 days!
• Hotel and travel discounts at worldwide destinations!
• Professional development and promotion opportunities!

About this job…

We’re looking for a detail-oriented Analytics & Systems Specialist to join our Revenue ManagementTeam. This role supports hotel pricing optimization, market sharegrowth, accurate topline forecasting, and process efficiency. The idealcandidate has advanced Excel skills, a strong analytical mindset, andhospitality experience—ideally in revenue management.

You’llcollaborate with Revenue Leaders and cross-functional teams to create efficiencies for the revenue team, by building andmaintaining reporting tools, monitoring performance, and driving data-informeddecisions across our hotel portfolio.

What you’ll be doing…

• Buildand maintain Excel-based reports and dashboards for pricing, forecasting, andperformance tracking
• Support monthly and annual forecasting by preparing and validating data inputs
• Conduct audits on distribution, rate loading, and other revenue-impacting processes
• Trainnew team members on tools, systems, and department processes
• Develop and refine reporting methodologies and explore automation opportunities
• Evaluateand implement AI tools to improve reporting efficiency and data accuracy

Requirements…

• 2+years in reporting, revenue management, or business analysis inhospitality
• Advanced Excel skills (e.g., pivot tables, XLOOKUP, Power Query, or OLAP data cubes)
• Familiaritywith hotel revenue systems (e.g., IDeaS, OYv2) is a plus
• Strong analytical skills and attention to detail
• Abilityto manage multiple priorities in a fast-paced environment
• Excellent communication and collaboration skills
• Bachelor’sdegree in Hospitality, Business, Finance, or related field (or equivalentexperience)

About First Hospitality...

Founded in 1985 and based in Chicago, First Hospitality is a forward-thinking hotel development, investment, and management company. First Hospitality’s strategic vision is to create value for all through excellence and an openness to doing things differently.

First Hospitality seeks to attract and retain a high-performing and diverse workforce in which employee’s differences are respected and valued to better meet the varying needs of the customers we serve. FH fosters an inclusive work environment that promotes collaboration, flexibility, and fairness. Equal Opportunity Employer.

Source: Hospitality Online