About the Company
We are a product company in the iGaming industry with international offices and a long-standing history of success. Our brands are constantly evolving, offering players modern and exciting entertainment. Thanks to our expertise and unique approach, we have become industry leaders.
Responsibilities:
-
Manage data in DWH ClickHouse: loading, cleaning, and deduplicating data.
-
Optimize SQL queries to enhance performance and data processing speed.
-
Configure Materialized Views and aggregated tables to accelerate BI queries.
-
Optimize data structure and build aggregated views for fast analysis.
-
Develop pre-calculated metrics and prepare data for dashboards.
-
Create and maintain data marts for BI tools (e.g., Tableau).
Requirements:
-
Deep understanding of ClickHouse: partitioning, indexes, aggregated tables, replication, and SQL query optimization.
-
Strong SQL skills (ClickHouse SQL, CTE, window functions, materialized views).
-
Experience working with large-scale datasets in ClickHouse and optimizing complex queries.
-
Knowledge of DWH architecture and experience designing data warehouses.
-
Experience integrating ClickHouse with BI tools (Tableau, Power BI, etc.).
-
Understanding of ETL processes and experience with data processing tools.
We offer:
-
Collaboration with industry experts: Opportunity to work with professionals in the gaming industry.
-
Competitive salary in USD and a benefits package, including 21 days of annual leave and paid sick leave.
-
Fully remote work: The flexibility to work from anywhere.
-
International environment: Work in a multinational and diverse team.
-
Professional development: Training, workshops, and career growth opportunities.
-
A team of professionals: Join a skilled and supportive team.
We are looking forward to having you join our dynamic and innovative company!
