Business Intelligence Analyst (Hotel Revenue Data)

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. Click Here for Additional Disclosures in Accordance with the LA County Fair Chance Ordinance. 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 . What if I don’t meet every requirement? If you’re passionate about our mission and believe you’d be a phenomenal addition to our team, don’t worry about “checking every box;" please apply anyway. You may be exactly the person we’re looking for!