DWH Engineer

About the job:

pawaTech is looking for a DWH Engineer with an inherent passion for teamwork and a collaborative spirit. As a DWH Engineer, you will play a vital role in our Data Domain team, crafting ClickHouse database structures in sync with our Data Warehouse model. Your expertise will drive seamless data integration, close collaboration with analysts and BI developers, and innovative approaches to enhance loading efficiency and design refinement.

About us:

At pawaTech, we specialise in crafting tailored iGaming platforms that cater to clients’ visions and objectives. With a deep understanding of the industry's intricacies, makes us the leaders in offering a range of services designed to propel iGaming ventures to the forefront of innovation and profitability. Our products are built with scalability in mind, supporting millions of active customers via app and web channels.

We've been at the forefront of the IT industry for almost a decade, where our passion for technology, commitment to quality, and client-centric approach have made us a trusted partner in the iGaming sector in Africa.

The main responsibilities will be:

• Design and create database objects for the ClickHouse-based Data Warehouse;
• Integrate data from MySQL and MongoDB into ClickHouse efficiently;
• Collaborate with analysts and BI developers for seamless data fusion;
• Advise business analysts and DWH users on ClickHouse to enhance decision-making;
• Innovate ETL processes for efficient data loading into ClickHouse;
• Refine Data Warehouse design while maintaining data integrity;
• Participate in DWH projects including analysis, modelling, development, testing, and deployment;
• Stay updated on tech trends and integrate emerging tools for continuous improvement.

Key skills and experience for this role:

• Understanding of Data Warehouse architecture design principles;
• Differentiating Data Warehouse from Transactional Design Methodologies;
• Preferable experience with ClickHouse databases;
• Solid grasp of SQL syntax (any dialect);
• 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).

Why you will like at pawaTech:

• Work with a dedicated team of professionals;
• Make your impact and contribute to shaping the iGaming culture;
• Empower your expertise with a modern technological stack;
• The salary that recognises and backs your achievements;
• Have the opportunity for your professional growth and career development;
• Embrace the employee recognition for 5 years of dedication with appreciative milestone bonuses;
• Variations in benefits may apply based on your location.

At pawaTech, we are dedicated to building a welcoming and diverse workplace and invite applicants from all backgrounds, regardless of race, gender, age, or other protected characteristics. Our hiring process ensures fairness, objectivity, and respect for every applicant.

In compliance with EU GDPR standards and PDPA in Estonia, your personal data will be treated confidentially, used purely for recruitment, and accessible only to authorised hiring team members. To request data deletion, updates, or transfers, please reach out via [email protected] we will fulfil your request in accordance with applicable data protection laws.