Data Analytics Engineer

This job is for a data engineer or analyst at KAYAK, a leading travel search engine. The role involves creating dashboards, reports, and data visualizations to analyze product performance, as well as assisting product managers with interpreting experiment results. The job also includes building and maintaining data pipelines, designing data models, and optimizing SQL queries. The ideal candidate should have professional experience in data engineering, analytics, or software engineering, with strong SQL skills and knowledge of ETL processes. Python experience and familiarity with Airflow are preferred.

• Create dashboards, reports, and data visualizations to share insights into product performance
• Assist Product Managers with interpreting experiment results
• Build and maintain data pipelines (ETLs) using Python, SQL, Airflow, and Docker
• Design performant data models and optimize SQL queries
• Investigate data issues to identify patterns and root causes
• Automate repetitive tasks and build self-service tools to support data democratization
• Work closely with cross-functional stakeholders to understand business needs, propose solutions, and communicate results

• 2+ years of professional experience in the field of data engineering, analytics, or software engineering
• Considerable experience with SQL using relational databases (e.g. MySQL, Vertica, Snowflake, Hive)
• Experience in building and maintaining ETLs preferred
• Ability to write clean and concise code, Python experience preferred
• Experience with Airflow is a plus

• 4 weeks paid vacation
• Day off on your birthday
• Generous retirement plans
• Awesome health, dental and vision insurance plans
• Flexible Spending Accounts
• Headspace Subscription
• No Meeting Fridays
• Drinks, coffee, snacks, games etc.
• Weekly catered lunches
• Flexible hours
• Regular team events/excursions
• Universal Paid Parental leave