Senior Data Engineer | SQL, ClickHouse, Python | Remote Position

Our cutting-edge travel platform helps users plan and book complex multi-destination trips with ease. The system processes thousands of travel options, accommodations, and transportation choices to create seamless itineraries. As our Data Engineer, you'll work at the intersection of travel technology and data science, creating the data foundation that powers personalized trip recommendations, booking analytics, and business intelligence for our rapidly growing service. Key Responsibilities - Design, develop, and maintain efficient ETL processes and data pipelines using SQL (specifically ClickHouse 22.8+) and Python frameworks to process travel inventory and booking data. - Create and optimize columnar data models for our travel reservation and planning systems, ensuring data accuracy, speed, and accessibility. - Implement comprehensive data quality checks and validation procedures throughout the data lifecycle to maintain integrity of travel offerings. - Collaborate with data scientists and analysts to transform raw travel and booking data into structured datasets for analytical purposes and prediction models. - Build interactive dashboards and reports using PowerBI with DAX formulas to visualize key business metrics, travel patterns, and customer preferences. - Identify opportunities for data process improvements and implement solutions to enhance query performance and data retrieval speeds. - Maintain detailed documentation for data flows, models, and pipeline processes to ensure knowledge transfer across the team. - Monitor and troubleshoot data pipeline issues to ensure reliable data delivery for real-time travel availability. - Participate in code reviews to maintain high-quality data engineering practices and consistent standards. - Support the continuous integration of new data sources relevant to travel planning, including third-party APIs from hotels, airlines, and activity providers. Required Skills - Minimum 1.5 years of professional experience in data engineering or data analysis roles. - Strong proficiency in SQL, with specific experience using ClickHouse for analytical queries, time-series data, and high-performance data processing. - Practical experience with Python programming (Python 3.8+), particularly with the Pandas library (version 1.3+) for data manipulation, transformation, and analysis. - Demonstrated ability to work with BI tools, especially PowerBI for dashboard creation, data visualization, and report development. - Understanding of ETL methodologies, data warehouse concepts, and dimensional modeling techniques. - Experience with version control systems (e.g., Git) for collaborative development and change management. - Basic English language proficiency, sufficient for reading technical specifications and communicating with team members. - Ability to work independently and manage multiple data projects in a remote environment with different time zones. - Problem-solving mindset with meticulous attention to detail and data accuracy in travel inventory systems. Nice to Have - Experience in the travel or hospitality industry with understanding of GDS (Global Distribution Systems). - Knowledge of cloud data platforms (AWS Redshift, Google BigQuery, or Azure Synapse). - Familiarity with Airflow, Dagster, or similar workflow orchestration tools for scheduling data pipelines. - Experience with real-time data processing for live travel inventory and pricing updates. - Understanding of data privacy regulations (GDPR, CCPA) and their implementation in travel data pipelines. - Experience with NoSQL databases or other columnar databases besides ClickHouse, such as Apache Cassandra or Amazon DynamoDB. - Knowledge of machine learning concepts and how they apply to travel recommendation systems and pricing optimization. - Experience with data modeling tools and methodologies like dbt (data build tool). - Familiarity with Agile development practices in distributed teams. - Contributions to open-source data projects or travel technology initiatives. Why Join Us Join our dynamic remote team and help shape the future of travel planning technology. We offer a flexible work environment where your contributions directly impact our product development and customer experience. You'll have opportunities to work with cutting-edge data technologies, solve complex travel planning challenges, and grow your skills in a collaborative, innovation-focused culture. Our flat organizational structure ensures your voice is heard and your expertise is valued as we revolutionize how people plan and book multi-destination travel experiences around the world.