DWH Engineer

DWH Engineer 

Tallinn, Estonia (Hybrid/remote)

We are looking for a Data Warehouse Engineer to join our Tallinn based igaming tech client.

As a DWH Engineer, you will focus on designing and optimising ClickHouse-based Data Warehouse. You’ll collaborate with business analysts, BI developers, and data engineers to ensure efficient data integration, storage, and analysis, enabling the organization to gain valuable insights.

Responsibilities:

  • Design, align, and create database objects according to the ClickHouse-based Data Warehouse data model;
  • Integrate data from various sources (MySQL, MongoDB) into ClickHouse for the Data Warehouse;
  • Collaborate closely with analysts and BI developers, enabling seamless data fusion and valuable insights;
  • Advise and guide business analysts and DWH users on ClickHouse intricacies to enhance decision-making;
  • Innovate data loading for swift ETL from diverse sources to ClickHouse, ensuring efficiency;
  • Shape the evolution of Data Warehouse design, rening structures while upholding integrity;
  • Actively participate in DWH projects, spanning analysis, modelling, development, testing, and deployment;
  • Stay updated on tech trends, spotting chances to infuse emerging tools for continual enhancement.

Requirements:

  • Understanding of Data Warehouse architecture design principles; 
  • Differentiating Data Warehouse from Transactional Design Methodologies;
  • Experience with ClickHouse databases; 
  • Solid grasp of SQL syntax (any dialect); 
  • Preferably, familiarity with MySQL and ClickHouse SQL syntax; 
  • 3+ years of experience with relational databases; 
  • Experience in ETL (ELT) or data-loading tasks; 
  • Proficient documentation skills; 
  • Enthusiastic about learning new technologies;
  • Excellent verbal and written English communication.

Beneficial skills:

  • Participation in DWH projects as an ETL developer, contributing across development stages with data exceeding 1TB;
  • Engaging with DWH stakeholders, gathering requirements;
  • Familiarity with the BI tools landscape and hands-on exposure to any BI tools (Redash).

Related Jobs

Java developer

Java Backend Developer Tallinn, Estonia (on-site) We are looking for an ambitious Backend Developer to join...

Payment Specialist – Asia

We are looking for a Payments Specialist to join one of the fastest-growing crypto casino brands, where...