Distribution Analyst

Location: Yerwada, 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
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.aticaglobal.com 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..