6 months ago
Base Salary
$130k - $160k/yr
Responsibilities
- Architect, develop, monitor, and maintain robust large-scale data pipelines using Python, SQL, and Rundeck/Airflow.
- Design performant data models and optimize complex SQL queries for distributed, columnar, OLAP, and relational database environments.
- Build automated data-quality checks and alerts to ensure accurate financial and operational reporting.
- Automate repetitive tasks and develop self-service tools that improve data access across teams.
- Use AI-assisted coding tools to accelerate development and improve code quality.
- Translate cross-functional business questions into practical, maintainable technical solutions.
Requirements
- 5+ years of experience in data engineering or analytics engineering in a related data-centric environment.
- Experience owning end-to-end data pipelines, including ingestion, transformation, testing, and monitoring.
- Strong SQL skills and familiarity with Redshift, Trino, Vertica, MySQL, or Postgres.
- Proficiency in Python and a software-engineering approach to building testable, maintainable code.
- Experience with workflow orchestration and containerization, including Airflow and Docker.
- Strong analytical and troubleshooting skills for investigating data issues.
- Strong written and spoken English for effective cross-team communication.
- Nice-to-have experience with Kafka or Flink, Looker or Superset, GitHub Actions, and Django or Flask.
Benefits
- Hybrid work from the Concord, Massachusetts office 3 days per week.
- Work from almost anywhere for up to 20 days per year.
- Company-paid therapy sessions through SpringHealth and a company-paid Headspace subscription.
- Company-wide week off, no-meeting Fridays, paid parental leave, generous paid vacation, and birthday time off.
- Paid volunteer time, development dollars, leadership development, and access to thousands of on-demand e-learning courses.
- Travel discounts, employee resource groups, competitive retirement and health plans, and free lunch 2 days per week.
- Quarterly events and other team activities.
Tech Stack
Amazon RedshiftApache AirflowApache FlinkApache KafkaApache SupersetDjangoDockerFlaskGitHub ActionsMySQLPostgreSQLPythonSQL
Categories
Data Engineering
About KAYAK
KAYAK builds a travel metasearch platform that lets consumers compare flights, hotels, rental cars, and vacation packages across hundreds of sites, plus tools for trip planning. It earns through referrals and advertising and offers KAYAK for Business for corporate travel. Founded in 2004 and headquartered in Stamford, Connecticut, KAYAK is part of Booking Holdings and operates a portfolio of brands including momondo, Cheapflights, and HotelsCombined.