ETL Developer

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.

We are looking for an experienced Data ETL Developer / BI Engineer who loves solving complex problems across a full spectrum of data & technologies. You will lead the building effort of GBT's new BI platform and manage the legacy platform to seamlessly support our business function around data and analytics. You will create dashboards, databases, and other platforms that allow for the efficient collection and evaluation of BI data.

What You’ll Do on a Typical Day:

• Design, implement, and maintain systems that collect and analyze business intelligence data.
• Design and architect an analytical data store or cluster for the enterprise and implement data pipelines that extract, transform, and load data into an information product that helps the organization reach strategic goals.
• Create physical and logical data models to store and share data that can be easily consumed for different BI needs.
• Develop Tableau dashboards and features.
• Create scalable and high-performance data load and management process to make data available near real-time to support on-demand analytics and insights.
• Translate complex technical and functional requirements into detailed designs. 
• Investigate and analyze alternative solutions to data storing, processing, etc., to ensure the most streamlined approaches are implemented.
• Serve as a mentor to junior staff by conducting technical training sessions and reviewing project outputs
• Design & develop, and maintain a data model implementing ETL processes.
• Manage and maintain the database, warehouse, & cluster with other dependent infrastructure.
• Work closely with data, products, and another team to implement data analytic solutions.
• Support production application and Incident management.
• Help define data governance policies and support data versioning processes
• Maintain security and data privacy by working closely with the Data Protection Officer internally.
• Analyze a vast number of data stores and uncover insights

What We’re Looking For:

• Degree in computer sciences or engineering
• Overall, 3-5 years of experience in data & data warehouse, ETL, and data modeling.
• 2+ years of experience working and managing large data stores, complex data pipelines, and BI solutions.
• Strong experience in SQL and writing complex queries.
• Hands-on experience with Tableau development.
• Hands-on working experience on Redshift, data modeling, data warehouse, ETL tool, Python, and Shell scripting.
• Understanding of data warehousing and data modeling techniques
• Strong data engineering skills on the AWS Cloud Platform are essential.
• Knowledge of  Linux, SQL, and any scripting language 
• Good interpersonal skills and a positive attitude
• Experience in travel data would be a plus.

Location

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!

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.

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!