Data Analyst

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.