Business Intelligence Analyst (Hotel Revenue Data)

CW Government Travel

India

On-site

INR 900,000 - 1,300,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Amex GBT is seeking a BI Analyst to join the GBP team in India. You will craft ad hoc reports, monthly dashboards, and transactional reports while building robust BI solutions and data models across multiple units.

You'll apply SQL, Power BI, Excel/Access, and ML concepts to deliver insights that influence supplier performance and business decisions.

Qualifications

  • Bachelor's degree in a field related to the role and 5+ years of relevant experience.
  • Proficient in SQL, data manipulation and cleansing, plus ETL concepts.
  • Strong Excel/Access skills including formulas, pivot tables, VLOOKUP and VBA.
  • BI development experience using Power BI and enterprise data modeling.
  • Familiarity with ML/AI concepts and data storytelling for stakeholders.

Responsibilities

  • Build ad hoc reports, transaction volume reports, and monthly dashboards with key metrics.
  • Design, develop, and maintain BI solutions for enterprise stakeholders.
  • Create and maintain complex database models and data infrastructure.
  • Communicate analytical insights clearly to non-technical audiences.

Skills

SQL Server
Data Analysis
Power BI
Excel
Access
VBA
Data Cleaning
Machine Learning concepts

Education

Bachelor's degree in a related field
Master's degree in CS/IS/Business Admin (preferred)

Tools

MS SQL Server
Power BI Desktop/Service
Excel/Access VBA

Job description

Amex GBT is a place where colleagues find inspiration in travel as a force for good and - through their work - can make an impact on our industry. We're here to help our colleagues achieve success and offer an inclusive and collaborative culture where your voice is valued.

Overview of the Department:

This role sits within the Global Business Partnerships (GBP) team which manages relationships with core suppliers across airlines, hotels, rail, and car rental. As our hotel business grows and data is a key strategic pillar, this role will play an active part in both defining and delivering future data needs for GBP.

What You'll Do

We are looking for the right candidate who has a good understanding of business analytics, data reporting, and business intelligence tools. They will build ad hoc reports, transaction volume reports, and monthly dashboards with important metrics.

Additionally, the BI Analyst will be responsible for the design, development, and maintenance of business intelligence solutions for enterprise stakeholders across multiple business units.

A BI Analyst will design, develop, implement, and maintain highly complex database models, and will also have a keen understanding of general business processes and how to communicate analytical insights to a lay audience.

Responsible for managing the data infrastructure, as well as producing reports and insights into the performance of our suppliers

What We're Looking For
  • Experience as Database Developer/SQL Server Developer / Data Analyst / Business Intelligence Developer/Analyst.
  • Proficient in SQL query writing, data manipulation, and data cleansing (e.g. queries, triggers, views, stored procedures).
  • Practical knowledge of how to extract, transform, load, and coordinate data from different sources into a reliable and easy-to-use enterprise data set.
  • Extensive practical knowledge in Microsoft Excel, and Access including formulas and functions such as: pivot tables, reference indexing, VLOOKUP, IF statements, macros, and VBA.
  • Experience in BI development using Microsoft Power BI.
  • Knowledge of Machine Learning and General AI concepts.
  • High level of attention to details (data accuracy).
  • Ability to work well under pressure, prioritize multi-task and maintain flexibility in a fast-paced environment.
  • Excellent written and verbal communication skills.
  • Ability to work against tight deadlines with colleagues across the world.
  • Drive results and work with little supervision.
  • Knowledge of travel industry.
Educational requirements:

Bachelor's degree in a field related to functional work and 5+ years of relevant work experience or an equivalent combination of comparable work experience and education.

Typically holds a bachelor's or master's degree in computer science, economics, information systems, or business administration.

Location

India

The #TeamGBT Experience

Work and life: Find your happy medium at Amex GBT.

Flexible benefits are tailored to each country and start the day you do. These include health and welfare insurance plans, retirement programs, parental leave, adoption assistance, and wellbeing resources to support you and your immediate family .

Travel perks: get a choice of deals each week from major travel providers on everything from flights to hotels to cruises and car rentals.

Develop the skills you want when the time is right for you, with access to over 20,000 courses on our learning platform, leadership courses, and new job openings available to internal candidates first.

We strive to champion Inclusion in every aspect of our business at Amex GBT. You can connect with colleagues through our global INclusion Groups, centered around common identities or initiatives, to discuss challenges, obstacles, achievements, and drive company awareness and action.

And much more!

A ll applicants will receive equal consideration for employment without regard to age, sex, gender (and characteristics related to sex and gender), pregnancy (and related medical conditions), race, color, citizenship, religion, disability, or any other class or characteristic protected by law.

Furthermore, we are committed to providing reasonable accommodation to qualified individuals with disabilities. Please let your recruiter know if you need an accommodation at any point during the hiring process. For details regarding how we protect your data, please consult the Amex GBT Recruitment Privacy Statement .

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

MI Data Management Analyst
MI Data Management Analyst

American Express Global Business Travel • Gurugram District

On-site
INR 600,000 - 900,000
Business Systems Analyst
Business Systems Analyst

Global Business Travel Group • Gurugram District

On-site
INR 1,200,000 - 1,800,000
Flexible benefits
Travel perks
Learning platform access
MI Data Management Analyst
MI Data Management Analyst

American Express Global Business Travel • Gurgaon

On-site
INR 600,000 - 900,000
Flexible benefits
Learning platform access
Inclusion culture
Strategic Pricing Analyst
Strategic Pricing Analyst

American Express Global Business Travel • Gurugram District

On-site
INR 900,000 - 1,500,000
Service Delivery Leader - Data Quality
Service Delivery Leader - Data Quality

CW Government Travel • Gurugram District

On-site
INR 1,800,000 - 2,400,000
Health insurance
Retirement plan
Parental leave
+3
Senior Travel Counselor
Senior Travel Counselor

CW Government Travel • Mumbai

On-site
INR 420,000 - 750,000
Travel Counselor
Travel Counselor

CW Government Travel • Bengaluru

Remote
INR 350,000 - 600,000
Flexible benefits tailored to country
Travel perks: deals with major travel
Learning platform with 20,000+ courses
+1
Marketplace Platform Operations Analyst (Product Support Analyst)
Marketplace Platform Operations Analyst (Product Support Analyst)

American Express Global Business Travel • Gurugram District

On-site
INR 700,000 - 900,000
Visa counsellor
Visa counsellor

CW Government Travel • Bengaluru

Remote
INR 350,000 - 550,000
Senior Travel Consultant
Senior Travel Consultant

American Express Global Business Travel • Mumbai

On-site
INR 300,000 - 600,000
Flexible benefits
Travel perks
Learning platform access
+1