Data Visualisation Expert / Data Analyst

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

Zusammenfassung

Trigyn Technologies Limited in Mumbai is seeking a Data Visualisation Expert/Data Analyst to design, develop, and maintain dashboards and KPI frameworks for the NDCS platform, translating coastal shipping data into clear visual insights for regulators, ports, and the public.

The role requires strong Power BI expertise, SQL, GIS visualization, and the ability to align reporting outputs with policy needs, data governance, and quarterly/annual analytics requirements.

Qualifikationen

• Graduate/ postgraduate in CS, Statistics, Data Science, IT or related field.
• 4-8 years in data analysis, dashboard development, and BI reporting.
• Experience with e-Governance analytics, maritime or logistics data is preferred.
• Desirable certifications: Power BI Data Analyst Associate or Data Analyst Associate.

Aufgaben

• Design, develop, publish interactive dashboards and reports for NDCS stakeholders.
• Define, calculate, standardise KPIs like Vessel Turnaround Time and Cargo Throughput.
• Connect Power BI to PostgreSQL data warehouse and external sources via schedules.
• Develop DAX measures and data models for high-performance reporting.
• Implement RLS to enforce role-based data access.

Kenntnisse

Power BI

SQL

GIS visualisation

KPI design

Data modelling (DAX)

Python or R (adv.)

Data governance

Stakeholder communication

Ausbildung

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

Tools

PostgreSQL

GIS tools (GeoJSON)

Excel

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 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 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

• 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