Distribution Analyst

Atica Global Inc; Pune District; Remote; INR 700,000 - 1,000,000; Full time

Job summary

Atica Global Inc seeks a data-driven hotel revenue professional to own rate analytics and channel pricing. You will work with the Director of Distribution and Revenue Managers to optimize net rates and channel profitability.

You will analyze ADR, RevPAR, occupancy and stay restrictions, build rate cards, and ensure parity across global wholesalers, OTAs, and corporate channels. US hours alignment will apply.

Qualifications

• 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.

Responsibilities

• 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.

Skills

Hotel revenue management

Arithmetic accuracy

Excel pivot tables

Excel lookups

Data validation

Tools

SQL

Power BI

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..