BI & TM1 Costing Solutions Analyst

Vector Logistics Limited; South Africa; On-site; ZAR 600,000 - 900,000; Full time

Job summary

Vector Logistics Limited is seeking a Business Intelligence and Solutions Analyst to manage and enhance the TM1-based costing and profitability models. The role focuses on end-to-end data flow, model integrity and stakeholder support in a dynamic supply chain environment.

The analyst will coordinate data updates, maintain ABM logic, and develop automated ETL workflows using Alteryx to ensure timely, accurate insights for commercial and operational decision-making.

Qualifications

• Experience administering TM1/IBM Planning Analytics models.
• Experience developing Power BI semantic models.
• Knowledge of SAP ERP/BW and SQL databases.

Responsibilities

• Coordinate monthly data updates into TM1 models and reconcile to sources.
• Maintain and develop Activity-Based Costing models for costing and profitability.
• Manage data ETL from SAP, SQL databases, and other sources for TM1 and reporting.
• Validate data, investigate variances and ensure model accuracy for decisions.
• Document data flows, processes and model changes to support continuity.

Skills

SQL

Power BI

Alteryx

Advanced Excel

DAX

Python

VBA

Education

Degree in Information Systems, Computer Science, Data Analytics, Finance, or Data Science

Tools

TM1 / IBM Planning Analytics

SAP ERP / SAP BW

SQL Server

Power BI

Alteryx

Job description

Vector Logistics Limited is seeking a Business Intelligence and Solutions Analyst to manage and enhance the TM1-based costing and profitability models. The role focuses on end-to-end data flow, model integrity and stakeholder support in a dynamic supply chain environment.

The analyst will coordinate data updates, maintain ABM logic, and develop automated ETL workflows using Alteryx to ensure timely, accurate insights for commercial and operational decision-making.