Data Specialist

Future Fit; Johannesburg; On-site; ZAR 250,000 - 420,000; Full time

Job summary

Future Fit is seeking a Data Specialist – Requirements Specification to support the GET migration project. You will review, cleanse, and prepare data across Finance, Supply Chain, Technical, and Document Management objects to ensure clean, complete and compliant data before cut-over.

You will work with key users to identify gaps, resolve data issues, and ensure readiness for data submission cycles, with a strong focus on data quality and transformation readiness for migration.

Qualifications

• Hands-on data quality support for GET migration.
• Review, cleanse and prepare data across Finance, SCM, Technical and Document Management.

Responsibilities

• Support Finance Source-System Data Quality & Clearing.
• Populate and maintain data migration files for GET Project.
• Identify data issues across project streams before mock migration or cut-over.
• Provide guidance on corrective actions to the business.
• Monitor closure of clean-up tasks.
• Assist reconciliation of business datasets for migration.

Skills

Advanced Excel skills

Power Query

Data Queries

Pivoting datasets

Merging datasets

Unpivoting datasets

Advanced formulas

Relational databases

Procurement data

Finance data

Operational ERP data

Clear communication

Independent work

Attention to detail

Cross-functional collaboration

Job description

Data Specialist – Requirements Specification

• 1. Role Overview

The Data Quality Support Resource will provide hands-on support to the Global

Enterprise Transformation (GET) migration team by reviewing, validating, cleansing, and preparing data across Finance, Supply Chain, Technical, and Document Management objects.

This role is critical to ensuring that all data provided to the GET transformation and migration teams is clean, complete, and compliant within defined rules and structures before cut-over.

The resource will work closely with key users and project teams to identify gaps, resolve data issues, and ensure readiness for data submission cycles.

Key Responsibilities

• Finance Source-System Data Quality & Clearing Support
• Populate and maintain data migration files for the GET Project.
• Proactively identify data issues across project streams, ensuring that migration data is aligned to GET requirements before mock migration or cut-over.
• Provide the business with support and clear guidance on corrective actions
• Monitor closure of required clean-up tasks.
• Support reconciliation of business datasets to ensure they are clean, accurate, and ready for migration.

Data Quality Review

Transformation Output Validation

After data loads, assist the business with verification activities by:

• Preparing comparison views between source, transformed, and loaded data.
• Highlighting discrepancies without taking accountability for business sign-off.
• Supporting issue logging and categorization for remediation.

Large dataset handling and data cleansing techniques

• Automated Data Quality Testing

Soft Skills

Experience Requirements

Engagement Model

• Data Preparation, Transformation Support & Template Alignment Support Key Users throughout the preparation and cleansing process by: Template & Structure Validation
  • Validate that data in internal submission templates aligns with GET mapping rules, transformation logic, and cleansing requirements.
  • Identify and resolve structural, formatting, or merging issues in submission templates.
  • Review populated templates for completeness, accuracy, and logical correctness before submission.
  • Cross-check that data conforms to standards (naming, units, mandatory fields, value lists, etc.).
  • Ensure data mapping between dependent datasets is consistent (eg. AP vendor exists on the Vendor Master)
  • Assist in the transformation of business data to submission format for migration.
  • Validate transformed data produced by GET/automation tools against cleansing rules.
  • Identify discrepancies and log issues for remediation.
• Technical Skills
  • Advanced Excel skills, including:
    • Power Query / Data Queries
    • Pivoting, merging, unpivoting datasets
    • Advanced formulas (LOOKUP functions, TEXT formulas, logic rules, LET, etc.)
• Strong understanding of Relational Databases.
• Knowledge of Procurement, Finance and Operational data in ERP systems.
• Excellent communication and ability to clearly articulate required corrections to business stakeholders.
• Ability to work independently and manage multiple data streams under pressure.
• High attention to detail and structured analytical approach.
• Ability to collaborate with cross-functional teams (Finance, SCM, Engineering, Document Management).