Smartbrain logo

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

Smartbrain·Salary not specified

Primary stack

SQLPythonClickHousePandasPower BI

Nice to have's

ETLAgile

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 roles

Popular searches