Senior Data Engineer - SQL, ClickHouse, Python, PowerBI (Remote)

Are you passionate about transforming raw travel data into actionable insights? We're seeking a skilled Data Engineer to join our team developing an innovative online trip planner and reservation platform for complex multi-destination journeys. You'll build robust data pipelines and analytics solutions that power decision-making across our travel booking ecosystem. Key Responsibilities - Design, develop, and maintain scalable ETL/ELT data pipelines to process travel booking and user interaction data. - Create efficient data models and implement data transformation processes using SQL (primarily ClickHouse) and Python. - Collaborate with data analysts and product teams to translate business requirements into technical specifications. - Optimize database queries and improve performance of existing data workflows for faster travel search results. - Implement data quality checks and monitoring to ensure accurate analytics across the reservation platform. - Build and maintain dashboards and reports using PowerBI to visualize key business metrics and travel trends. - Document data processes, architectures, and models for knowledge sharing and team alignment. - Integrate data from multiple travel booking systems to create a unified view of the customer journey. - Develop metrics and KPIs to track booking completion rates, user engagement, and itinerary optimization. - Create data pipelines that handle seasonal travel patterns and demand fluctuations efficiently. Required Skills and Experience - Minimum 1.5 years of professional experience in data engineering, analytics, or related field. - Strong proficiency in SQL, particularly with ClickHouse or similar columnar databases. - Hands-on experience with Python data manipulation libraries (Pandas, NumPy) for processing travel data. - Experience building and optimizing data pipelines and workflows in a production environment. - Demonstrated ability to work with BI tools, especially PowerBI for dashboard creation and insight delivery. - Understanding of data modeling concepts and best practices for analytical and reporting purposes. - Basic knowledge of data warehouse architecture and design patterns for efficient data storage. - Familiarity with version control systems (Git) and collaborative development practices. - Basic English proficiency sufficient for reading technical documentation and participating in team discussions. - Analytical mindset with strong problem-solving skills and attention to detail. - Experience working in an Agile development environment with iterative delivery cycles. Nice to Have - Experience with cloud data platforms (AWS, GCP, or Azure) for scalable data processing. - Knowledge of Apache Airflow, DBT, or similar workflow management tools for orchestration. - Familiarity with travel industry data or reservation systems and their unique characteristics. - Experience with real-time data processing using streaming technologies like Kafka or Kinesis. - Understanding of machine learning concepts and data preparation for ML models in travel prediction. - Experience with NoSQL databases and unstructured data processing for customer reviews and feedback. - Knowledge of data governance and compliance requirements, particularly for international travel data. - Familiarity with A/B testing frameworks and experiment analysis in a travel booking context. Why Join Our Team As a Data Engineer on our team, you'll work on challenging problems in the travel technology space, building systems that help travelers plan complex multi-destination trips with ease. You'll have the opportunity to work remotely with a global team of professionals, continuous learning opportunities to expand your technical skillset, and the chance to see your work directly impact user experiences. We foster a collaborative environment where your ideas and innovations are valued, and provide competitive compensation with flexible working arrangements. Your work will directly impact user experience and business growth in the dynamic travel industry, as you help build data systems that make complex trip planning simple and accessible for travelers worldwide.