- Design and develop interactive dashboards & reports using Power BI / Tableau / Looker.
- Create data visualizations and storytelling dashboards to provide meaningful insights.
- Implement drill-downs, filters, and KPI tracking for trade operations, finance, HR, and marketing analytics.
- Ensure report performance optimization by using best practices in DAX, SQL queries, and indexing.
- Build star schema and snowflake schema models for efficient BI reporting.
- Develop ETL pipelines to extract data from trade, finance, and HR systems into the BI layer.
- Integrate data from multiple sources (PostgreSQL, Oracle, APIs, Data Lakes, etc.).
- Ensure data consistency, accuracy, and governance in all BI reports.
- Work with business users, data engineers, and product managers to understand data & reporting needs.
- Translate business questions into analytical solutions with clear insights.
- Present data-driven insights to executives and department heads for strategic decision-making.
- Conduct training sessions for end-users to maximize BI tool adoption.
- Optimize dashboard speed, queries, and data refresh rates.
- Ensure data security & governance policies are maintained in BI reports.
- Implement role-based access control (RBAC) for report viewing & data access.
- Maintain documentation for dashboards, data models, and report logic.
