Data Engineer II

Job Overview

Egencia, the business travel division of Expedia Group, is at the center of revolutionizing business travel with our cutting edge technology products in the industry. We are one of the fastest growing brands and in our 12 year history we have grown from a small start-up to become one of the largest corporate travel management companies in the world.

As a Data Engineer on the BI/Analytics team, you are an authority, familiar with all the data warehousing technical components, infrastructure, and their integration. You’ll analyze large amounts of data, discover and tackle real world problems. You are responsible for high level design – with extensive experience with Star Schemas, Data Cubes and Dimensional Models.

We expect our Data Engineers to build durable data pipelines with the ability to scale elegantly with data volume growth. The code you write will enable our users to get data in a timely manner. You’ll work on a variety of tools and systems, most of which are Cloud-based applications or data-platform components (e.g., data pipelines, processing, Visualization, reporting, etc.). In this role, you will be working in Agile development method for faster, quick-wins with the quality of design, development and operating BI components you develop.

What you’ll do::

Design, architect, implement, and support key datasets that provide structured and timely access to actionable business information with the needs of the end customer always in view

Retrieve and analyze data using SQ and other data management systems

Create ETLs/ELTs to take data from various operational systems and craft a unified dimensional or star schema data model for analytics and reporting

Develop a deep understanding of vast data sources (existing on the cloud) and know exactly how, when, and which data to use to solve particular business problems

Who you are:

Experience developing and operating large scale analytical databases/platforms/data warehouses and performing ETL across multiple operating systems (Microsoft and Linux)

Experience in working with Cloud BI Production implementation

Experience with Agile, DevOps, CICD frameworks

Experience working with multi-terabyte data sets using relational databases (RDBMS) and SQL

Experience using Agile/Scrum methodologies to iterate quickly on product changes, developing user stories and working through backlogs.

You’ll fit this role if you have:

5+ years of experience with detailed knowledge of data warehouse technical architectures, ETL/ ELT, reporting/analytic tools, and data security

3+ years of experience in designing data warehouse solutions and integrating technical components

2+ yrs of experience with any scripting language (Ruby, python, etc.)

2+ yrs of experience leading data warehousing and analytics projects, including using AWS technologies – Redshift, S3, EC2, Data-pipeline and other big data technologies

1+ yr of experience with production BI implementation in the Cloud

Exposure in at least one reporting tool like Qlikview, Tableau, Power BI etc.

Capable of investigating, familiarizing and mastering new data sets quickly

Experience with building data platform on cloud (AWS)

Good familiarity with Linux/Unix scripting

Experience with Snowflake Computing, Kafka, or Kinesis are a huge plus

View More