Senior Data Engineer — Scale Data Pipelines & BI

KAYAK; Concord (MA); On-site; USD 130,000 - 160,000; Full time

Benefits offered by this job

Work from home up to 20 days/year

No meeting Fridays

Paid parental leave

Generous vacation + birthday leave

Paid volunteer time

Travel discounts

Employee Resource Groups

Retirement and health plans

Job summary

KAYAK, part of Booking Holdings, is seeking a Senior Data Engineer for the Business Intelligence team in Concord, MA. You will build and operate the data backbone, enabling reliable financial and operational reporting and analytics across the organization.

The role focuses on scalable data pipelines, performance optimization, and data reliability, with collaboration across teams. Office presence in Concord, MA is required three days per week.

Qualifications

• 5+ years of proven experience in data engineering or analytics engineering.
• Experience owning end-to-end data pipelines (ingest → transform → test → monitor).
• Strong SQL skills and familiarity with distributed/columnar/OLAP systems (Redshift, Trino, Vertica) and relational databases (e.g., MySQL, Postgres).
• Proficiency in Python and a software-engineering approach to building testable, maintainable code.
• Experience with workflow orchestration and containerization (Airflow, Docker).
• Strong analytical and troubleshooting skills for investigating data issues.
• Strong written and spoken English to communicate effectively across teams.

Responsibilities

• Architect for scale: Develop and monitor robust data pipelines using Python, SQL, and Rundeck/Airflow that handle large-scale data volumes with high reliability.
• Optimize performance: Design performant data models and optimize complex SQL queries for high-scale environments.
• Ensure data reliability: build automated checks and alerts to catch errors early so financial and operational reports remain accurate.
• Increase data access: automate repetitive tasks and build self-service tools to make data easier to use across teams.
• Drive engineering excellence: experiment with and leverage AI-assisted coding tools to accelerate development cycles and enhance code quality.
• Work with partners across the company: translate business questions into practical, maintainable technical solutions.

Skills

SQL

Python

End-to-end pipelines

Airflow

Troubleshooting

English communication

Data modeling

Tools

Redshift

Trino

Vertica

MySQL

Postgres

Docker

Job description

KAYAK, part of Booking Holdings, is seeking a Senior Data Engineer for the Business Intelligence team in Concord, MA. You will build and operate the data backbone, enabling reliable financial and operational reporting and analytics across the organization.

The role focuses on scalable data pipelines, performance optimization, and data reliability, with collaboration across teams. Office presence in Concord, MA is required three days per week.