Business Intelligence Analyst - Hotel Revenue Data (Remote)

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. Ready to explore a career path? Start your journey. The Global Business Partnerships (GBP) team manages relationships with core suppliers across airlines, hotels, rail, and car rental. Within GBP, the Global Revenue Management (GRM) data team is responsible for managing the data infrastructure, as well as producing reports and insights into the performance of our suppliers. 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 at Amex GBT. What You'll Do: • Bring a solid understanding of business analytics, data reporting, and business intelligence tools to build ad hoc reports, transaction volume reports... monthly KPI dashboards. • Responsible for the design, development, and maintenance of business intelligence solutions for enterprise stakeholders across multiple business units. • Design, develop, implement, and maintain highly sophisticated database models. • Advise on general business processes. • Communicate analytical insights to a lay audience. 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 organize data from various 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. • Get results and work with little supervision. • Knowledge of travel industry. • Educational requirements: Bachelor's degree in subject area 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 Canada 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 more. • 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 global tuition assistance, 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 Diversity, Equity, and Inclusion in every aspect of our business at 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. • Wellbeing resources to support mental and emotional health for you and your immediate family. • And much more! All 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 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 Apply Job!