21 марта 2025
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.
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!