Johannesburg: Data Analyst posted by iOCO Digital Pty Lty

The Data Analyst will evaluate the current state of master data in the existing ERP system, identify data quality issues, and prepare the data for migration to the new ERP cloud platform. This includes cleansing, transforming, and documenting the data to meet migration and operational requirements.

What you’ll do:

• Data Assessment and Profiling
• • Analyse the current master data across all relevant domains (e.g., Customers, Suppliers, Products, Chart of Accounts).
  • Profile the data to identify issues such as duplicates, incomplete records, outdated entries, and inconsistencies.
  • Generate reports summarizing the quality and completeness of the master data.
• Data Cleansing
  • Work with business stakeholders to define rules for data standardization (e.g., naming conventions, format consistency).
  • Remove duplicate records and merge conflicting data based on defined rules.
  • Validate and update missing or inaccurate data through stakeholder consultation or external enrichment sources.
• Data Mapping
  • Collaborate with the migration team to map existing master data fields to the new ERP cloud structure.
  • Ensure alignment with the new system’s data requirements, including mandatory fields, data types, and formats.
  • Document mapping rules and transformations for all master data domains.
• Data Transformation
  • Use tools like Excel, SQL, or ETL platforms to transform data based on mapping and cleansing requirements.
  • Prepare datasets in a format compatible with the new ERP cloud platform’s data migration templates.
• Stakeholder Collaboration
  • Engage with business process owners, data stewards, and IT teams to understand master data usage and requirements.
  • Communicate findings and obtain approvals for data cleansing and mapping decisions.
  • Provide regular updates to project managers and migration leads.
• Data Validation and Testing
  • Validate the transformed data to ensure it meets business and migration requirements.
  • Perform reconciliation between the source system and migrated data to ensure completeness and accuracy.
  • Participate in mock migrations and testing cycles to identify and resolve data-related issues.
• Documentation
  • Document all processes, including profiling, cleansing, mapping, and validation steps.
  • Create data dictionaries and metadata records for future reference.
  • Provide a final report summarizing the readiness of the master data for migration.

Your Expertise:

• Proficiency in data analysis tools (e.g., Excel, SQL, Power BI).
• Experience with ERP systems (preferably both legacy systems and ERP cloud platforms like SAP, Oracle, or Microsoft Dynamics).
• Knowledge of data quality management and cleansing techniques.
• Strong understanding of master data domains (e.g., Customers, Suppliers, Products).
• EAM knowledge and experience a must have for the fixed asset cleansing and projects migration.
• Excellent communication and documentation skills.
• Ability to collaborate with technical and business teams.
• Experience in on prem ERP migration to Fusion