Senior Data Platform Engineer – ClickHouse, ETL and Analytics

About the role

Afghan Wireless, Afghanistan's first wireless communications company, is hiring a Senior Data Platform Engineer to own Cedar's ClickHouse reliability, performance and recovery, and to deliver ETL and analytics engineering. The role works closely with the Mediation and DWH teams, and two engineers share the development and reporting duties.

Key responsibilities

• Own ClickHouse reliability, performance and recovery: MergeTree schemas, partition/order keys, materialized views, retention, ingestion, SQL tuning, capacity and tested recovery, plus PostgreSQL support where deployed.
• Manage replication, backup, failover and disaster-recovery procedures, run restore drills and lead incident investigations.
• Build and maintain ETL: Python and Go adapters, validation, parsing, ClickHouse loading, reconciliation and reporting, using CI/CD, Ansible and Docker/Temporal where deployed.
• Develop analytics: Git-controlled ClickHouse SQL transformations, reusable reporting models and Grafana / Apache Superset dashboards, with documented lineage and validated totals.
• Support MySQL/MariaDB, MongoDB and other databases, and maintain drivers, clients and dependencies with version control.
• Work with the Mediation and DWH teams only on agreed datasets, schemas, delivery schedules and control totals, and coordinate controlled redelivery and reprocessing.

Required profile

• Bachelor's degree in Telecom Engineering, IT, Computer Science or a related field.
• Minimum 7 years of experience in data engineering and database operations, including 3 years on high-availability production data platforms.
• Demonstrated ClickHouse, Python, ETL and Go delivery, and proven hands-on administration of enterprise PostgreSQL.
• Fluent in Dari or Pashto and English (written and spoken).
• Proven delivery of restores, failover tests, data reconciliation and incident resolution, with clear documentation.

Required skills

• Production ClickHouse: ingestion, partitioning, performance tuning, recovery and development of MergeTree schemas.
• MySQL/MariaDB, advanced SQL and migrations.
• Python, Go, SQL, Linux, scripting and database security.
• Preferred: telecom CDR, revenue assurance and fraud-domain experience, and infrastructure automation.