Data Integration & Mapping Specialist

Circana; Cape Town; On-site; ZAR 520,000 - 780,000; Full time

Job summary

Circana in Cape Town is looking for a Data Integration Mapping Analyst to map and validate datasets from multiple countries, aligning source data with Circana data models and business rules. You will own mapping specifications, support onboarding and changes, and ensure high-quality, documented data mappings for downstream reporting.

The role requires strong Excel and data modelling understanding, with a collaborative, KPI-driven mindset and excellent communication in English.

Qualifications

• Experience with MS Office, particularly Excel.
• Understanding of data modelling concepts and data relationships.
• Strong analytical and problem-solving skills.
• Fluency in written and spoken English.

Responsibilities

• Creating and maintaining data mapping specifications in line with agreed business rules and rulebooks
• Validating incoming data files to ensure compliance with defined business and technical requirements
• Identifying, analysing, and resolving data mapping and integration issues
• Ensuring objective, accurate, consistent, and high-quality data mappings
• Monitoring data quality and identifying anomalies, gaps, and trends within assigned data sources
• Updating mapping documentation, business rules, and process guidelines to ensure continued relevance and accuracy
• Supporting testing, validation, and implementation activities for new client onboardings and data integration changes
• Providing regular progress updates to internal and external stakeholders
• Providing support and guidance to internal stakeholders on data mappings, integration processes, and data quality concerns
• Co-operating with your team and other departments to ensure on-time delivery of integration projects and operational activities
• Contributing to the improvement of team and individual KPIs

Skills

Excel

Analytical skills

Documentation

Tools

Data integration tools

Data modelling concepts

Job description

Circana in Cape Town is looking for a Data Integration Mapping Analyst to map and validate datasets from multiple countries, aligning source data with Circana data models and business rules. You will own mapping specifications, support onboarding and changes, and ensure high-quality, documented data mappings for downstream reporting.

The role requires strong Excel and data modelling understanding, with a collaborative, KPI-driven mindset and excellent communication in English.