1. BI & Superset Platform Development (30%)
- Design, build and maintain Superset dashboards and reports based on approved business KPI definitions.
- Configure Superset datasets, metrics, filters, and user roles / row-level security.
- Optimize query and dashboard performance through caching, pre-aggregated tables and SQL tuning.
2. Data Pipelines & Data Modelling (20%)
- Assist in developing, operating, and maintaining end-to-end data pipelines (ETL/ELT),
- Write, test, and maintain transformation, validation, and enrichment logic using Python and SQL.
- Ingest data from various internal databases, event streams, and third-party APIs.
3. Data Quality, Monitoring & Troubleshooting (30%)
- Monitor pipeline health, logs, and alerts
- Validate and reconcile dashboard figures against source systems and official business reports, then investigate and resolve any discrepancies.
- Carefully troubleshoot and resolve script errors, performance lags, and data discrepancies.
4. Stakeholder Collaboration & Documentation (20%)
- Collaborate cross-functionally to clarify stakeholder requirements and KPI logic, and support smooth, reliable releases to production.
- Provide basic guidance to business users on using Superset.
- Maintain technical documentation, the data dictionary and metric definitions.