Data Visualisation Expert / Data Analyst

Job Summary

Role Overview The Data Visualisation Expert/Data Analyst will be responsible for designing, developing, and maintaining interactive dashboards, KPI frameworks, and analytical reports for the NDCS platform. This role bridges data engineering and policy insights by translating complex coastal shipping datasets into clear, actionable visualisations for regulators, port operators, and public users.

Responsibilities

• Design, develop, and publish interactive dashboards and analytical reports using Power BI or other open-source tools (Desktop, Service, and Gateway) for NDCS stakeholders, including DGS, MoPSW, ports, and the general public.
• Define, calculate, and standardise Key Performance Indicators (KPIs), including Vessel Turnaround Time, Dwell Time, Cargo Throughput, Route Utilisation, and Compliance Metrics in alignment with the KPI Definition Document.
• Connect Power BI to the NDCS data warehouse (PostgreSQL) and to external data sources via scheduled refreshes and real-time feeds.
• Develop DAX measures, calculated columns, and data models in Power BI for accurate, high-performance reporting.
• Create geographic visualisations and port activity maps using GIS data layers (GeoJSON / lat-long coordinates).
• Align and enhance existing reporting outputs (Excel / PDF / internal reports) into structured Power BI dashboards.
• Implement Row Level Security (RLS) in Power BI dashboards to enforce role-based data access for Ministry, DGS, Port, and Public user groups.
• Collaborate with the data engineering team to understand ETL pipeline schedules, data refresh cycles, and dataset limitations.
• Support analytics requirements for historical trend analysis (minimum 3-5 years), cargo flow forecasting, and infrastructure gap assessments.
• Prepare data quality reports and flag inconsistencies in integrated datasets from e-Samudra, LRIT, MSW, IWAI PANI, and PCS.
• Document all dashboard designs, data flows, and KPI definitions in the NDCS Analytics and Reporting Manual.
• Support the incorporation of predictive analytics and AI/ML-based forecasting capabilities during the OM phase.

Required Skills Qualifications

• Strong proficiency in Power BI (Desktop, Service, Power BI Gateway), including data modelling, DAX, and report publishing.
• Solid SQL skills for querying data warehouses, data validation, and supporting dashboard development.
• Experience with GIS-based visualisations, including geographic mapping of routes, ports, and vessel movements.
• Ability to translate business and regulatory requirements into actionable KPI frameworks and dashboard designs.
• Familiarity with data warehousing concepts and BI environment configuration (ETL pipelines, data refresh, and data governance).
• Understanding of role-based access and Row Level Security (RLS) in BI platforms.
• Knowledge of Python or R for exploratory data analysis and statistical modelling is an advantage.

Qualifications

• Educational Qualification: Graduate / Post-Graduate in Computer Science, Statistics, Data Science, IT, or related field
• Experience: Around 4-8 years in data analysis, dashboard development, and BI reporting roles
• Desirable Certifications: Microsoft Certified: Power BI Data Analyst Associate (PL-300), Microsoft Certified: Data Analyst Associate, or equivalent BI/data analytics certifications

Location

Mumbai, India

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.