Data Analyst

3SC; Gurugram District; On-site; INR 900,000 - 1,300,000; Full time

Job summary

3SC is seeking a Power BI Developer to design, develop, and maintain multi-tenant dashboards within our SaaS platform. The role focuses on transforming Transportation Management System (TMS) data and Supply Chain planning metrics into executive scorecards and operational dashboards.

You will work on end-to-end dashboard delivery, ETL data integration from TMS/ERP engines, dimensional modeling, and KPI engineering for plan accuracy and transportation metrics, ensuring data security across tenants.

Qualifications

• 2–4 years of hands-on experience as a Power BI Developer or Supply Chain Data Analyst.
• Direct experience with Transportation Management Systems (TMS) or freight data.
• Understanding of supply chain planning analytics and relevant indices (DPAI, RPAI, PPAI, RMPAI).

Responsibilities

• End-to-End Dashboard Delivery: design, build, and optimize interactive Power BI reports for SaaS clients and internal stakeholders.
• ETL data from TMS and ERP/Supply Chain engines using Power Query (M) and SQL.
• Build robust Star and Snowflake schemas optimized for large-scale logistics data.
• Write complex DAX measures to track plan accuracy and logistics KPIs.
• Design dynamic Row-Level Security for multi-tenant data isolation.

Skills

Power BI

Data modeling

SQL

DAX

ETL

Dashboard design

Power BI Service

Tools

Power Query (M)

SQL

Job description

As a Power BI Developer, you will design, develop, and maintain multi-tenant dashboards within our SaaS platform. You will work extensively with Transportation Management System (TMS) data as well as core Supply Chain Planning Metrics. The ideal candidate excels at converting complex logistics datasets and planning accuracy indicessuch as Demand, Production, Replenishment, and Raw Material Plan Accuracy-into clear, interactive executive scorecards and operational dashboards.

Key Responsibilities

Report Development & Data Modeling

• End-to-End Dashboard Delivery: Design, build, and optimize interactive Power BI reports tailored to specific SaaS clients and internal stakeholders.
• TMS & SCM Data Pipeline Integration: Extract, transform, and load (ETL) data from Transportation Management Systems (TMS) and ERP/Supply Chain engines using Power Query (M) and SQL.
• Dimensional Modeling: Build robust Star and Snowflake schemas optimized for large-scale logistics and supply chain transactional data.

Supply Chain & Logistics KPI Engineering

• Plan Accuracy & Adherence Metrics: Write complex DAX measures to track and benchmark supply chain planning performance:
  • DPAI: Demand Plan Accuracy Index
  • RPAI: Replenishment Plan Accuracy Index
  • PPAI: Production Plan Accuracy Index
  • RMPAI: Raw Material Plan Accuracy Index
• TMS & Logistics KPIs: Calculate core transportation metrics including On-Time Delivery (OTD), Carrier Performance, Freight Cost per Unit/Ton-Mile, Route Efficiency, and Load Utilization.

Platform Governance & Performance

• Multi-Tenant Security: Design and implement dynamic Row-Level Security (RLS) to ensure absolute data isolation across different SaaS client tenants.
• Performance Optimization: Tune complex DAX logic, aggregations, and data refresh cycles to maintain fast load times and optimal query efficiency.
• Cross-Functional Collaboration: Partner with Data Engineers to refine data warehouse structures and work with Client Success Managers to gather business reporting requirements.
• Technical Documentation: Maintain comprehensive data dictionaries, metric definition sheets, and schema flowcharts.

Qualifications & Skills

Experience & Domain Knowledge

• Experience: 2-4 years of hands-on experience as a Power BI Developer or Supply Chain Data Analyst.
• Logistics & TMS Expertise: Direct experience working with Transportation Management Systems (TMS), freight data, or fleet analytics.
• Supply Chain Planning Analytics: Proven understanding of supply chain execution and planning accuracy indices (DPAI, RPAI, PPAI, RMPAI).

Technical Skills

• Power BI Stack: Expert in Power BI Desktop, Power BI Service, DAX, and Power Query (M).
• Database & SQL: Strong proficiency in writing complex SQL queries for data extraction, validation, and transformation.
• Data Architecture: In-depth knowledge of relational databases, data warehousing concepts, and dimensional modeling.

Nice to Have

• Experience in a B2B SaaS environment handling multi-tenant reporting.
• Familiarity with major TMS or ERP platforms (e.g., Oracle TMS, SAP TM/IBP, Blue Yonder, Manhattan Associates, MercuryGate).
• Experience with REST API integrations, JSON parsing, or incremental refreshes in Power BI.