Distribution Analyst

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

Job summary

Atica Global Inc. in Pune, India, is seeking a pricing/analytics professional with 2–4 years of experience in hotel revenue management, pricing or analytics. The role is full-time, work from office in Pune, with US business hours (4 PM to 2 AM IST).

You will build and update rate cards, calculate markups and net rates, ensure parity with contracted rates, and analyze channel performance. Strong Excel skills and knowledge of ADR/RevPAR are essential.

Qualifications

• 2 to 4 years in hotel revenue management, pricing or analytics, at a hotel company, an OTA or a travel company.
• Accurate and fast arithmetic; able to calculate net and sell rates with a markup or a commission.
• 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 hotels 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

Arithmetic proficiency

Excel skills

ADR/RevPAR knowledge

Attention to detail

Tools

SQL

Power BI

Metabase

Job description

Job Summary

Location: Pune. Full-Time Job: Work from office. Work Hours: US Business Hours (4 PM to 2 AM IST). Experience: 2 to 4 years in hotel revenue management, pricing or travel analytics.

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

Disclaimer: This job posting and location has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.