Immediate Openings For Data Visualization Expert/Data Analyst - Mumbai

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.
Key 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 35 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 O&M 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.
• Strong communication skills to present analytical insights to both technical and non-technical stakeholders.
• Attention to detail with a data-driven mindset for identifying trends, anomalies, and operational insights.
Eligibility Criteria
Parameter Requirement
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

Preferred Experience with e-Governance analytics platforms, maritime or logistics sector reporting, or large-scale government data visualisation projects
Desirable Certifications Microsoft Certified: Power BI Data Analyst Associate (PL-300), Microsoft Certified: Data Analyst Associate, or equivalent BI/data analytics certifications
Job Location: Mumbai
Office Address: Indian Ports Association (IPA), Satellite Office Mumbai, West Wing, 3rd Floor, Bhandar Bhavan, Muzawar Pakhady Road (N. V. Nakhwa Road), Elphinstone Estate, Mumbai- 400051