Senior Data Warehouse & Mediation Engineer

About the role

Afghan Wireless, Afghanistan's first wireless communications company, is hiring a Senior Data Warehouse and Mediation Engineer. The role owns assigned upstream data warehouse and mediation processing and interfaces, delivering complete, accurate and timely source-to-delivery data flows with traceable reconciliation evidence. It is a strictly local resource hire.

Key responsibilities

• Develop, operate and troubleshoot DWH/mediation services, models and databases, keeping performance, capacity, availability and secure access in check.
• Build source-feed integrations, CDR/event processing, ETL/ELT, parsers and file/API/database interfaces using Python, SQL, Java and Go.
• Manage collection, transformation, loading, scheduling, job dependencies, cron jobs, checkpoints and auditable delivery status.
• Build middleware/adapters with schemas, message mapping, validation, authentication, timeouts, retries, idempotency and error handling.
• Reconcile source-to-delivery counts and charging/billing totals, detect missing, late, duplicate or malformed records, and control redelivery and reprocessing.
• Preserve live processing, original evidence and rejected records under retention controls, and maintain model integrity, lineage, backups and tested recovery.
• Diagnose database, storage, throughput and batch-window bottlenecks, and fix incidents within assigned services.
• Maintain Git-controlled code, automated tests, deployment and rollback procedures, and trained backup cover.
• Agree source-to-target mappings, schemas, control totals, schedules, latency and acceptance checks with PENTAHO and Cedar, and deliver data/interfaces to them while reconciling handoff totals.
• Support Billing, CAMELOCK, GMLC and BI interfaces, and distinguish legacy/migrated feeds and environments.
• Work with teams such as RAFM, PS Core, Billing, OSS/BSS, IT Development, and others, and coordinate changes, restore tests and recovery with IT-SAT, infrastructure, security and platform owners.

Required profile

• Bachelor's degree in Telecom Engineering, IT, Computer Science or a related field.
• Substantial hands-on production experience in telecom mediation and large data warehouses, shown through coding, interface delivery, reconciliation and incident resolution.
• Fluent in one of the local languages (Dari or Pashto) and in English, written and spoken.
• Experience in telecom revenue assurance, fraud analytics, charging/billing and subscriber/provisioning data.

Required skills

• Strong Python and advanced SQL; Java and Go development or integration maintenance as deployed.
• CDR/event processing, ETL/ELT, parsing, orchestration, scheduling and data-quality engineering.
• Database administration, query optimization, partitioning, capacity management, retention and lineage.
• Middleware/adapter development, secure API/file/database integration, schema evolution, retries, duplicate protection and failure recovery.
• Linux, Git, scripting, automated tests, deployment automation, monitoring and production troubleshooting.
• PostgreSQL, MySQL/MariaDB or other deployed warehouse platforms; ClickHouse interfaces preferred.

Candidates apply through the application form provided by the recruiter; shortlisted candidates undergo background screening, including verification of employment history and references.