Back to jobs

Business Intelligence and Solutions Analyst

Pay
Pay not listed
Work setting
Not stated
Employment
Not stated

What you’ll work on

Full posting
  • Run monthly TM1 data updates and reconcile them back to source systems

  • Maintain the Activity-Based Costing model, its cost drivers and allocation logic

  • Build and maintain Alteryx ETL workflows and SQL Server data warehouses

  • Investigate variances, data-quality issues and system failures, and fix root causes

  • Support TM1 users and explain costing outputs to non-technical stakeholders

From the employer’s posting
Coordinate and execute the monthly and routine updating of data into the TM1 models and reconciling back to source systems.
Maintain and develop the organisation's models including its Activity-Based Costing model
Develop and maintain automated ETL workflows using Alteryx to streamline data preparation
Investigate variances and anomalies to identify and resolve potential data, model, allocation or business-process issues.
Investigate and resolve user queries and discrepancies and provide clear explanations of technical, costing and data-related issues to non-technical stakeholders.

What you’ll bring

All qualifications

Core experience

  • Experience with TM1 modelling and administration
  • SQL and understanding of relational databases
  • Experience with Alteryx ETL workflows
  • Experience extracting data from SAP ERP and SAP BW
Qualification wording
Administer and maintain the organisation's TM1 environment
Use SQL and an understanding of relational databases and data structures
Develop and maintain automated ETL workflows using Alteryx
Extract, transform and integrate data from SAP ERP, SAP BW, SQL databases and other disparate sources
Apply at Vector Logistics

Posting record

Report an error
Status in our records
Live
First seen by us
Sep 8, 202674 days ago
Recorded sightings
41
Last seen by us
Nov 21, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Time since we first saw it

Day 74

Up longer than most. Similar jobs usually come down between day 5 and day 43.

From 16,018 similar postings that came down. Coming down is not always a hire.

Vector Logistics is hiring

1 open job

Open jobs by the week we first saw them, last 12 weeks.

Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • SQL
  • Alteryx
  • SAP
  • SQL Server
Where the posting names them
Data ETL and Integration Extract, transform and integrate data from SAP ERP, SAP BW, SQL databases and other disparate sources to provide reliable inputs for TM1, semantic models, costing, profitability and reporting solutions.
Use SQL and an understanding of relational databases and data structures to query, manipulate, validate and investigate data.
Develop and maintain production data warehouses in SQL server.
Develop and maintain automated ETL workflows using Alteryx to streamline data preparation, improve data quality and ensure the timely and consistent availability of information.

Your next step

Complete your application on vectorlog.csod.com. The employer’s form will show what is required.

Already applied? Track this application

Job description

View original posting ↗

Job Purpose The purpose of the role is to manage, maintain and further develop the organisation's BI environment and associated costing and profitability models, ensuring that they provide accurate and reliable information for financial, commercial and operational decision making. The role is primarily responsible for maintaining the Activity-Based Costing model, including the underlying logic and assumptions that underpin the model. The model is used extensively for profitability reporting, new business costings, forecasting and budgeting. The incumbent will manage the end-to-end flow of data through the model and ensure the integrity of the system. The role acts as a key point of support for users of the system. Key Responsibilities TM1 Maintenance and Administration Coordinate and execute the monthly and routine updating of data into the TM1 models and reconciling back to source systems. Maintain and develop the organisation's models including its Activity-Based Costing model to ensure that costs are appropriately allocated to activities, business units, customers, products and services. Maintain the cost drivers, assumptions and allocation methodologies underpinning the model to ensure that costing outputs continue to reflect the operational reality of the business. Ensure that all models provide accurate and meaningful information for commercial and management decision-making. Investigate variances and anomalies to identify and resolve potential data, model, allocation or business-process issues. Identify and incorporate business and masterdata changes into the model. Administer and maintain the organisation's TM1 environment, including cubes, dimensions, hierarchies, subsets, rules, feeders, processes, security and user access, to ensure the system remains stable, secure and fit for purpose. Monitor TM1 processes and model performance, investigate system issues, and implement appropriate solutions to maintain reliable and timely outputs. Maintain appropriate documentation of TM1 models, processes, structures, logic, assumptions and changes to support effective system management and continuity. Time and Motion Process Management Manage the collection, validation and maintenance of Time Motion data, ensuring accurate employee time allocations are reflected in TM1 and appropriately incorporated into costing models and cost drivers. Data Integrity and Validation Perform data validation and reconciliation across source systems, ETL processes and TM1 models to ensure the accuracy and integrity of critical costing and profitability information. Identify data-quality issues, investigate root causes and implement appropriate corrective actions to prevent recurring errors. Maintain appropriate controls, validation procedures and audit trails over key data and model inputs. Data ETL and Integration Extract, transform and integrate data from SAP ERP, SAP BW, SQL databases and other disparate sources to provide reliable inputs for TM1, semantic models, costing, profitability and reporting solutions. Use SQL and an understanding of relational databases and data structures to query, manipulate, validate and investigate data. Develop and maintain production data warehouses in SQL server. Develop and maintain automated ETL workflows using Alteryx to streamline data preparation, improve data quality and ensure the timely and consistent availability of information. Apply appropriate business rules to cleanse, transform, join and aggregate data from multiple sources to produce fit-for-purpose datasets. Monitor automated data processes, investigate failures and data anomalies, and implement corrective actions to maintain reliable data flows. Document key data flows, transformations, dependencies and controls to support the ongoing management and integrity of the data environment. Stakeholder Support and Engagement Act as a subject-matter expert for TM1-based costing and profitability models and provide guidance and technical support to users on the interpretation and use of system outputs. Investigate and resolve user queries and discrepancies and provide clear explanations of technical, costing and data-related issues to non-technical stakeholders. Manage development projects end-to-end from gathering requirements to final delivery keeping scope, timelines and stakeholder expectations on track. Escalate decisions involving fundamental costing methodologies, material financial assumptions, system architecture or business policy to appropriate stakeholders. Share knowledge and provide training to users where required. Automation, Development and Continuous Improvement Support the ongoing development and enhancement of the models and functionality to meet changing business and reporting requirements. Develop specification documents for new models and functionality, and manage testing, migration and deployment of changes into production Engage with Finance, Commercial, Operations, IT and other stakeholders to understand business requirements and translate them into practical solutions. Identify manual, repetitive or inefficient processes and develop automated solutions to improve efficiency and reduce manual intervention. Continuously evaluate opportunities to improve the TM1 model performance, data processes, reporting functionality and costing methodologies. Challenge requirements where appropriate and recommend solutions that improve efficiency, accuracy, automation and sustainability. Identify and evaluate the impact of business process changes on existing reporting systems and models. Identify opportunities to integrate systems and improve the flow of information from source systems through to costing, profitability and management reporting. Coordinate with external service providers or consultants where relevant. Key Relationships Internal Senior Management teams across Vector Commercial, Engineering and Finance teams IT and Risk Operational managers across the Business Cross functional project teams Technical teams External Service Providers Consultants

Demand for Analyst roles

New Analyst postings at the employers we follow are up 26% over the last 6 weeks compared with the 6 before.

Weekly new Analyst postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 993, the most 1,510, and the latest week had 1,367.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Analyst, by the work the posting describes.

Analysts answer business questions with data. They pull numbers with SQL, build reports and dashboards, and explain what changed and why to the people making decisions.

Most postings ask for SQL, spreadsheets, a dashboard tool such as Tableau or Power BI, and clear writing.

Unlike a data scientist, an analyst mostly explains what happened rather than building models that predict what will.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

South Africa

Working pattern and location restrictions need checking in the full posting.

Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.