Senior Data Warehouse Engineer
pawaTech
1 month ago
Role details
Contract type
Permanent contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
English Experience level
SeniorJob location
Tech stack
Artificial Intelligence
Databases
Data Fusion
Data Integration
Data Integrity
ETL
Data Warehousing
Relational Databases
Database Storage Structures
MongoDB
MySQL
SQL Databases
Systems Integration
Job description
- Designing and creating database objects for the ClickHouse-based Data Warehouse;
- Integrating data from TiDB, MySQL and MongoDB into ClickHouse efficiently;
- Collaborating with analysts and BI developers for seamless data fusion;
- Advising business analysts and DWH users on ClickHouse to enhance decision-making;
- Innovating ETL processes for efficient data loading into ClickHouse;
- Refining Data Warehouse design while maintaining data integrity;
- Participating in DWH projects, including analysis, modelling, development, testing, and deployment;
- Staying updated on tech trends and integrating emerging tools for continuous improvement., * We make an impact and contribute to shaping the iGaming culture;
- We offer growth inside dedicated teams of seniors and career prospects;
- We embrace a modern technological stack and innovative approaches;
- We apply AI-driven tools to enhance productivity, streamline workflows, and keep our teams ahead in innovation;
- We value balance - a flexible environment and team events are waiting for you;
- We play it fair with compensation that recognises and backs your achievements and team budgets.
Requirements
pawaTech is looking for a Senior DWH Engineer with a strong analytical mindset and a commitment to collaboration. As a DWH Engineer, you will play an essential 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., * Understanding of Data Warehouse architecture design principles;
- Differentiating Data Warehouse from Transactional Design Methodologies;
- Preferably experience with ClickHouse databases;
- Solid grasp of SQL syntax (any dialect);
- 5+ years of experience with relational databases;
- Experience in ETL (ELT) or data-loading tasks;
- Enthusiastic about learning new technologies;
- Excellent verbal and written English communication.
- 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).
About the company
pawaTech is a leading iGaming solutions provider, delivering sportsbook, casino, lottery, and player management software as a service. We power betPawa - Africa's largest betting brand, operating across multiple markets.
Our platform is designed for scale, handling millions of active users across web and mobile, processing thousands of transactions every second. With nearly a decade of industry expertise, we don't just build software - we craft tailored solutions that drive innovation. Our expertise, commitment to quality, and client-focused approach make us a trusted partner in Africa and beyond.