Business Intelligence Developer- Apache Superset

Role: Software Engineer Superset Report Building

Contract - 9 Months (Possibility of extension)

Location: Remote

Domain: Agricultural Marketplaces (Preferred), Business Intelligence

Key Responsibilities:

Superset Dashboard Development Build and optimize Apache Superset dashboards with complex visualizations (pivot tables, heatmaps, time-series, etc.).

SQL Query Optimization – Write and optimize SQL queries for large-scale transaction data, using indexing and partitioning.

ETL & Data Ingestion – Develop and manage data pipelines, ensuring structured/unstructured data processing.

API Integration – Connect Superset with external APIs (REST/GraphQL) for real-time and batch data access.

Data Visualization – Transform complex datasets into user-friendly, decision-driven reports.

Security & Access Control – Configure Superset RBAC, manage user permissions, and enforce data governance.

Troubleshooting & Support – Provide L2/L3 support for dashboards, automate error logging, and ensure performance monitoring.

Required Technical Skills:

BI & Visualization: Apache Superset, Tableau (optional)

Databases: PostgreSQL, MySQL, Oracle

SQL Optimization: Advanced SQL, Indexing, Partitioning

API Integration: REST, GraphQL

Scripting: Python, Bash

ETL & Data Pipelines: Apache Airflow, DBT (preferred)

Big Data (Preferred): Presto, Trino, Spark

Soft Skills:

Analytical Thinking & Problem Solving

Collaboration with Cross-Functional Teams

Strong Documentation Skills

Ability to Translate Data into Actionable Insights