Distribution Revenue Analyst - Hotels

Atica Global; Pune District; On-site; INR 600,000 - 1,200,000; Full time

Job summary

Atica Global in India is seeking a hotel revenue analytics professional to own rate calculations across channels, ensuring prices meet contract terms and hotel pricing guidelines.

You will work with the Director of Distribution and Revenue Managers to build rate cards, analyze ADR/RevPAR, occupancy, and stay restrictions, and provide ready-to-use numbers for partners.

Qualifications

• 2 to 4 years in hotel revenue management, pricing or analytics.
• Strong arithmetic for net and sell rates with markups/commissions.
• Good knowledge of ADR, RevPAR, occupancy, BAR and stay restrictions.
• Strong Excel: pivot tables, lookups, weighted averages.
• You check your numbers before you share them.

Responsibilities

• Build and update the net rate card for each hotel on each channel.
• Calculate markups, commissions and net rates. Ensure no channel sells below the hotel price.
• Compare loaded rates with contracted rates. Report the errors.
• Check rate parity across channels.
• Analyse which hotels and channels sell, and which do not.
• Prepare the numbers for each rate decision before it goes to a partner.

Skills

Excel

Hotel revenue management

Pricing analytics

Data accuracy

Tools

SQL

Power BI

Metabase

Job description

Work Hours: US Business Hours (4 PM to 2 AM IST)

Experience: 2 to 4 years in hotel revenue management, pricing or travel analytics

About Atica:

Atica is a leading, tech-first remote sales & revenue management company for Hotels and Hotel operators in the US, enabled by a unified tech-led solution. We are a startup, funded by the top investors in the country, like Titan Capital, DIBS. As innovators at the forefront of the industry, we strive to deliver the highest quality service to all our clients while setting new standards for efficiency and effectiveness. We aspire to build high-quality, innovative & robust software that makes an impact!

Find more about us!

https://www.linkedin.com/company/atica-global

The opportunity

Our hotels sell through global wholesalers, bedbanks, OTAs and corporate channels. Each channel has its own rate structure and contract terms. Correct numbers decide if a channel makes money for the hotel.

In this role, you own these numbers. Your analysis tells the team which rate to offer, which channel to grow and which problem to fix first. You work directly with the Director of Distribution and with our Revenue Managers

What you will do

• Build and update the net rate card for each hotel on each channel.
• Calculate markups, commissions and net rates. Make sure that no channel sells below the hotel's own price.
• Compare loaded rates with contracted rates. Report the errors.
• Check rate parity across channels.
• Analyse which hotels and channels sell, and which do not.
• Prepare the numbers for each rate decision before it goes to a partner.

Must have

• 2 to 4 years in hotel revenue management, pricing or analytics, at a hotel company, an OTA or a travel company.
• Correct and fast arithmetic. You can calculate net and sell rates with a markup or a commission.
• Good knowledge of ADR, RevPAR, occupancy, BAR and stay restrictions.
• Strong Excel: pivot tables, lookups, weighted averages.
• You check your numbers before you share them.

Good to have

• Experience with US hotels.
• Knowledge of wholesale or bedbank rates.
• SQL or a BI tool (for example Metabase, Power BI).
• Experience with STR reports or rate-shopping tools.