Business Intelligence Analyst (Hotel Revenue Data)

American Express Global Business Travel; Mumbai; On-site; INR 800,000 - 1,500,000; Full time

Job summary

American Express Global Business Travel is seeking a BI Analyst to build ad hoc reports, dashboards, and enterprise BI solutions. You will design and maintain complex data models and communicate insights to stakeholders across business units.

The role requires strong SQL, Power BI, Excel/Access, and ML awareness, with excellent communication and ability to work under pressure. Location: Mumbai, India; on-site collaboration with global teams.

Qualifications

• Experience in database development, SQL Server, data analysis, or BI development.
• Proficient in SQL querying, data manipulation, and cleansing.
• Proficient in Excel/Access including pivot tables, VLOOKUP, macros, and VBA.
• Experience in BI development using Power BI.
• Knowledge of ML and general AI concepts.
• Strong attention to detail and data accuracy.
• Ability to work under pressure and meet deadlines.
• Knowledge of travel industry is a plus.

Responsibilities

• Build ad hoc reports, transaction volume reports, and monthly dashboards.
• Design, develop, and maintain BI solutions for enterprise stakeholders.
• Develop and maintain complex database models and communicate insights clearly.
• Manage data infrastructure and produce reports on supplier performance.

Skills

SQL

Data analysis

Power BI

Excel

VBA

Communication skills

Team collaboration

Attention to detail

Travel industry knowledge

Education

Bachelor's degree + 5+ years

Bachelors/Masters in CS/Economics/IS/Business Admin

Tools

Microsoft Access

Microsoft Excel

Power BI

Job description

Overview of the Department:

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.

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!

Disclaimer: This job posting & 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.