Senior Data Engineer (OLAP, ETL Pipelines, BI Integration)

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.