ETL Engineer

Kayak Software Corporation
Cambridge, United States of America
3 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Intermediate
Compensation
$ 120K

Job location

Cambridge, United States of America

Tech stack

Clean Code Principles
Airflow
Information Engineering
ETL
Data Warehousing
Cursor (Graphical User Interface Elements)
Python
Marketing
Standard Sql
SQL Databases
Workflow Management Systems
GIT
Vertica
Software Version Control
Data Pipelines

Job description

  • Languages: Python, SQL
  • Workflow orchestration: Airflow
  • Query engine: Trino
  • Data warehouse: Vertica
  • Source control: Git
  • AI coding tools: Cursor

Requirements

Do you have experience in Technical architecture?, We're looking for a Data Engineer with a solid foundation in building robust data pipelines and a collaborative mindset to join our Marketing Data Engineering team. If you thrive in a fast-paced environment, enjoy working cross-functionally, and are eager to embrace change (especially innovations like AI coding assistants), this could be your next adventure!, * 3+ years of professional experience in data engineering

  • Proficiency in SQL and Python, and know how to write scalable, maintainable code
  • Experience working with AI coding tools and are excited about how they're shaping the future of development
  • Understanding modern data architecture from ingestion to transformation to delivery
  • Built and operated Airflow pipelines (or something similar)
  • Comfort estimating project scope, managing timelines, and delivering reliably
  • Excellent collaboration and communication skills, comfortable working with technical and non-technical peers
  • A solution-oriented mentality, driven by curiosity
  • Welcomed change and innovation, and you're quick to adapt your tools and practices
  • Thrived in an international, fast-paced, and feedback-driven environment

There are a variety of factors that go into determining a salary range, including but not limited to external market benchmark data, geographic location, and years of experience sought/required. The base range for this Massachusetts located role is $115,000 - 120,000.00, not inclusive of annual bonus and recurring RSU grants.

Benefits & conditions

3.43.4 out of 5 stars 500 Broad Canal Way, Cambridge, MA Hybrid work $115,000 - $120,000 a year - Full-time, Pulled from the full job description

  • Parental leave
  • Health insurance
  • Retirement plan
  • Paid time off
  • Paid sick time
  • Flexible spending account
  • Bereavement leave, This role is required to work from our Cambridge, MA office 3 days per week.

In this role you will:

  • Design, build, and maintain high-performance data pipelines and orchestration workflows
  • Write clean, modular Python code to transform, parse, clean, and enrich large datasets
  • Support stakeholders by developing dashboards and visualizations
  • Partner closely with marketing analysts, engineers, and data scientists to define and deliver data needs
  • Actively participate in agile ceremonies, code reviews, and planning discussions
  • Experiment with and use AI coding tools to boost productivity and code quality, We offer a competitive base salary and benefits including: health benefits; flexible spending account; retirement benefits; life insurance; paid time off (including PTO, paid sick leave, medical leave, bereavement leave, floating holidays and paid holidays); and parental leave benefits.

About the company

KAYAK, part of Booking Holdings (NASDAQ: BKNG), is a leading travel search engine. With billions of queries across our platforms, we help people find their perfect flight, stay, rental car and vacation package. We're also transforming business travel with a new corporate travel solution, KAYAK for Business. As an employee of KAYAK, you will be part of a travel company that operates a portfolio of global metasearch brands including momondo, Cheapflights and HotelsCombined, among others. From start-up to industry leader, innovation is in our DNA and every employee has an opportunity to make their mark. Our focus is on building the best travel search engine to make it easier for everyone to experience the world., At KAYAK, we want everyone to have the space to grow, share ideas and do great work. That's why we're focused on hiring the best talent from all walks of life and experiences, supporting them well and making sure no one feels like they have to fit a mold to belong here.

Apply for this position