Senior Data Engineer (OLAP, ETL Pipelines, BI Integration)
Primary stack
Nice to have's
Job description
About the Position
We are seeking a Senior Data Engineer to design and maintain ETL pipelines, optimize data workflows, and create dashboards using Power BI. This role is remote and offers full-time and part-time opportunities.
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 Power BI 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.
Requirements
- 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 Power BI 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.
We Offer
- Remote work opportunities
- Competitive salary
- Professional growth and development
About the Company
[Company description if present]
© Smartbrain. This job description was sourced from the employer's public career page. TheJob is not the employer — we index the posting and route candidates to the source. All content rights and hiring decisions belong to the employer.
More at Smartbrain
All 121 rolesSenior Full-Stack Engineer — React / Node.js / AI Agents
Smartbrain
GPU Server/Hardware Engineer (NVIDIA, field-based)
Smartbrain
Kotlin AQA Engineer | Remote Mobile Testing Specialist
Smartbrain
Senior Full-Stack Engineer - Angular, Django & DevOps
Smartbrain