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).