Data Engineer II

Expedia

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 within Expedia, Inc. 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 II 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 solve real world problems. You are responsible for high level design with extensive experience with Star Schemas, Data Cubes and Dimensional Models.

Our Data Engineers 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 an Agile development method for faster, quick-wins with the quality of design, development and operating BI components you develop.

Responsibilities

• 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 SQL, Excel, 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

Competencies

• 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.

Experience And Qualification

• 5+ years experience with detailed knowledge of data warehouse technical architectures, ETL/ ELT, reporting/analytic tools, and data security
• 4+ years of experience in designing data warehouse solutions and integrating technical components
• More than 2 yrs experience with any scripting language (Ruby, python, etc.)
• 2+ yrs experience leading data warehousing and analytics projects, including using AWS technologies – Redshift, S3, EC2, Data-pipeline and other big data technologies
• At least 1 yr of experience with production BI implementation in the Cloud
• Exposure to a reporting tool such as QlikView, Tableau, Power BI, etc., and being capable of investigating, familiarizing and mastering new data sets quickly
• Experience with building data platforms on cloud (AWS) along with having good familiarity with Linux/Unix scripting
• Hadoop, MPP DB platform, other NoSQL (Mongo, Cassandra) technologies experience is a huge plus

Why Join Us?

Expedia Group recognizes our success is dependent on the success of our people. We are the world’s travel platform, made up of the most knowledgeable, passionate, and creative people in our business. Our brands recognize the power of travel to break down barriers and make people’s lives better – that responsibility inspires us to be the place where exceptional people want to do their best work, and to provide them the tools to do so.

Whether you’re applying to work in engineering or customer support, marketing or lodging supply, at Expedia Group we act as one team, working towards a common goal; to bring the world within reach. We relentlessly strive for better, but not at the cost of the customer. We act with humility and optimism, respecting ideas big and small. We value diversity and voices of all volumes. We are a global organization but keep our feet on the ground, so we can act fast and stay simple. Our teams also have the chance to give back on a local level and make a difference through our corporate social responsibility program, Expedia Cares.

If you have a hunger to make a difference with one of the most loved consumer brands in the world and to work in the dynamic travel industry, this is the job for you.

Our family of travel brands includes: Brand Expedia®, Hotels.com®, Expedia® Partner Solutions, Egencia®, trivago®, HomeAway®, Orbitz®, Travelocity®, Wotif®, lastminute.com.au®, ebookers®, CheapTickets®, Hotwire®, Classic Vacations®, Expedia® Media Solutions, CarRentals.com™, Expedia Local Expert®, Expedia® CruiseShipCenters®, SilverRail Technologies, Inc., ALICE and Traveldoo®.

Expedia is committed to creating an inclusive work environment with a diverse workforce. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status. This employer participates in E-Verify. The employer will provide the Social Security Administration (SSA) and, if necessary, the Department of Homeland Security (DHS) with information from each new employee’s I-9 to confirm work authorization.