Distribution Revenue Analyst - Hotels

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

Job summary

Atica Global Inc in Pune, India seeks a Revenue Analyst to own rate and channel profitability for US-bound hotel clients from a tech-first remote sales setup. You will calculate net rates, markups, and parity across wholesalers and OTAs, collaborating with the Director of Distribution and Revenue Managers.

Required 2–4 years in hotel revenue management, pricing or analytics, plus strong Excel and familiarity with BI tools. US hotel experience is a plus.

Qualifications

• 2–4 years experience in hotel revenue management, pricing or analytics.
• Strong arithmetic and data accuracy.
• Proficient Excel (pivot tables, lookups, weighted averages).

Responsibilities

• Build and update net rates and channel profitability for each hotel/channel.
• Compute markups, commissions and net rates; ensure channels don’t underprice.
• Compare loaded vs contracted rates and report errors.
• Check price parity across channels and identify gaps.
• Analyze which hotels/channels sell and which do not; prepare numbers for partner reviews.

Skills

Hotel revenue management

Pricing analytics

Excel advanced

Financial analysis

Attention to detail

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.