Immediate Openings For Data Visualization Expert/Data Analyst - Mumbai

Trigyn Technologies Limited; Mumbai; Vor Ort; INR 1.200.000 - 2.000.000; Vollzeit

Zusammenfassung

Trigyn Technologies Limited is seeking a Data Visualisation Expert/Data Analyst to design and maintain interactive dashboards for the NDCS platform, translating coastal shipping data into clear visuals for regulators, port operators, and the public.

The role requires strong Power BI, SQL, GIS mapping, and data warehousing know-how, plus the ability to build KPI frameworks and secure data access through Row Level Security.

Qualifikationen

• Graduate or postgraduate in CS, Statistics, Data Science, IT or related field.
• 4-8 years in data analysis, dashboard development, and BI reporting.
• Desirable: e-Governance analytics, maritime or logistics govt data projects.
• Certifications: Power BI Data Analyst Associate (PL-300) or Data Analyst Associate.

Aufgaben

• Design, develop, and publish interactive dashboards and reports for NDCS.
• Define and standardise KPIs like Vessel Turnaround Time, Dwell Time, Throughput.
• Connect Power BI to PostgreSQL data warehouse and external sources.
• Develop DAX measures, data models, and calculations in Power BI.
• Create geographic visualisations and port activity maps.
• Implement Row Level Security for multiple user groups.
• Collaborate with data engineering on ETL schedules and data refreshes.
• Prepare data quality reports and flag dataset inconsistencies.

Kenntnisse

Power BI

SQL

GIS visualization

KPI design

ETL / Data warehousing

Row Level Security

Python or R

Communication

Data modelling

Data validation

Ausbildung

Graduate / Post-Graduate in CS/Statistics/Data Science/IT

Tools

Power BI

PostgreSQL

GIS tools

Python or R

Jobbeschreibung

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