Foodbev seta requires a service provider to cleanse, validate and reconcile data across its management information system (sims), CRM, microsoft dynamics 365 business central, commitment register and archived microsoft dynamics ax legacy dataset. The work spans seven phases over three months, from data profiling and de-duplication to popia compliance, three-way financial reconciliation, legacy migration remediation and preventative control design. The objective is an unqualified audit outcome with NO material findings and a single source of truth for reporting. The most consequential consideration for bidders is the functionality threshold: a minimum score of 70 out of 100 must be achieved, driven largely by the qualifications, certifications and five years' experience of three named key personnel.
Key Requirements
Closing: 24 November 2026 at 16:30; email a soft copy to [email protected]. Late bids are not accepted.
Functionality threshold: minimum 70 of 100 points; bids below this are disqualified before price and preference points are considered.
Key personnel: the Data Engineer, Data Analyst and Project Manager must each hold a relevant Bachelor's degree, a valid specified certification and at least five years' experience; CVs, certified qualifications and certificates must be submitted or no points are awarded. Foreign qualifications require a SAQA evaluation certificate.
Bidder experience: written reference letters on client letterhead, dated and signed, are required; three references earn the full 20 points, one earns 10, none earns zero.
Compliance documents: full CSD registration report, tax clearance certificate and PIN, B-BBEE certificate or signed affidavit, and signed SBD 1, SBD 4 and SBD 6.1. Omission of any one disqualifies the bid.
Preference points: 20 points under the 80/20 system for ownership by black people, women, black youth and people with disabilities, each up to 5 points.
Contract conditions: a POPIA section 21 operator agreement must be signed before processing personal information; ring-fenced records must not be altered; the Exception Re-Run and Close-Out Report must be accepted before final payment is released.
Information & Communication Technology Industry Profile
Critical Requirements
POPIA Compliance
Regulatory Bodies
IITPSA
Tenders in this industry often require registration with these bodies.
Typical Documents
9 items
Company Registration (CIPC)
Tax Clearance Certificate
B-BBEE Certificate
CSD Registration
Company Profile
ISO 27001 Certificate (if applicable)
Technical Certifications
Solution Architecture Documents
Reference Letters
Recommended Certifications
Having these can improve your winning chances: IITPSA Membership, ISO 27001 (Information Security Management), ISO 20000 (IT Service Management), CISSP
Document read. The full tender notice and its supporting documents are read end-to-end. Key sections, requirements, dates, and contact details are identified and pulled into a working summary you can act on.
Compliance review. The working summary is checked against South African procurement standards — PFMA, PPPFA, B-BBEE, CIDB, local content, and preferential procurement — so nothing critical is missed before you start your bid response.
RFQRFQ for Data Cleansing - 17.11.2026.pdfReview complete
Description
Source: RFQ for Data Cleansing - 17.11.2026.pdf
Important Dates
17 Nov
2026
PUBLICATION
Tender Published
Tender was published
24 Nov
2026
DEADLINE
Closing Date
Tender closing date
Procurement Rules & Compliance ContextThis tender may be governed by South African public procurement rules covering fairness, transparency, preferential procurement, anti-corruption, administrative justice and access to information.
7 rules
These references help suppliers understand the public-procurement framework around this opportunity. They are generated from the tender category, issuing organisation type and procurement context.
Core procurement rules
These rules commonly apply to South African public-sector procurement.
7
Broad-Based Black Economic Empowerment Act (B-BBEE Act)
Act 53 of 2003
high
Provides the empowerment-compliance context often used in public-sector supplier evaluation.
Relevant because this is a South African public-sector procurement opportunity.
Constitution of the Republic of South Africa, 1996 – Section 217
Act 108 of 1996 (s217)
high
This is general procurement context, not legal advice. Always verify requirements in the official tender documents and issuing authority notices.
Comprehensive data cleansing and validation of the FoodBev SETA management information system (MIS) is being procured by the Food and Beverages Manufacturing SETA on a national basis. The available pages carry only the special conditions of tender and standard returnable forms; scope, deliverables, evaluation weights and financial thresholds are not set out here.
A service provider must supply comprehensive data cleansing and validation services for the FoodBev SETA Management Information System and related learner, financial, CRM and commitment data. The procurement covers data audit, cleansing, validation, reconciliation, POPIA compliance, legacy migration remediation and preventative controls. The expected project duration is three months from the date of appointment.
Not sure if your business is ready for this tender? Check CSD, CIDB, and B-BBEE requirements, run a readiness assessment, and move from opportunity to submission.
BIDDERS LIST - CALIBRATION, SERVICE AND AD HOC MAINTENANCE OF CHEMICAL SERVICES LABORATORY EQUIPMENT FOR A PERIOD OF FIVE (5) YEARS AT LETHABO POWER STATION
Based on 25 comparable awarded tenders. Companies with similar profiles typically bid near the median.
* Estimates are based on historical data and do not guarantee actual award values.
Bid-ready summary. The submission guidelines, evaluation criteria, technical, financial, and compliance sections are refined into professional, easy-to-scan prose. This is the final version you can rely on when preparing your bid or briefing your team.
We refine every tender document through these stages so you can brief your team and prepare your bid with confidence. Anything marked as "in progress" will be upgraded automatically — no action required from you.
Document read
Compliance review
Bid-ready summary
FoodBev SETA is a Schedule 3A public entity established under the Skills Development Act, operating from 7 Wessels Road, Rivonia, Johannesburg. It promotes skills development in the food and beverages manufacturing sector and is one of 21 SETAs aligned to the National Skills Development Plan.
The project requires a service provider to cleanse, validate and reconcile data across the Management Information System (SIMS), Customer Relationship Management system, Microsoft Dynamics 365 Business Central, Commitment Register (Excel) and archived Microsoft Dynamics AX legacy dataset. The aim is to achieve an unqualified audit outcome with no material findings and establish a single source of truth for decision-making, statutory reporting and POPIA compliance.
Scope is divided into seven phases:
Phase 1: Data audit and profiling, including re-performance of internal audit exception tests and confirmation of legacy data recoverability.
Phase 2: Data cleansing and standardisation, covering de-duplication, validation against CIPC and SARS, standardisation to OFO codes, enrichment, correction, learner lifecycle completeness, date sequence integrity, completion and certification alignment, referential integrity, and project/contract master data.
Phase 3: POPIA compliance and data deletion, including consent management, opt-out flagging, and secure quarantine or deletion subject to retention obligations.
Phase 4: Three-way reconciliation between SIMS, Business Central and Commitment Register, including resolution of discrepancies, payment-to-learner linkage, identification of manual payments and utilisation analysis.
Phase 5: Legacy system migration remediation, reconstructing original budget amounts, task order values and transaction dates from the archived AX dataset.
Phase 6: Preventative controls, data dictionary and handover, including control specifications, audit trail requirements, data dictionary, monthly exception reporting and data governance committee terms of reference.
Phase 7: Exclusions and ring-fenced records, covering forensic investigations, contract termination decisions, system configuration exclusions and preservation of ring-fenced records.
Important Dates
Source: RFQ for Data Cleansing - 17.11.2026.pdf (RFQ)
Closing date: 24 November 2026 at 16:30
Queries deadline: before closing date, in writing to [email protected]
No compulsory briefing or site visit stated.
Contact Information
Source: RFQ for Data Cleansing - 17.11.2026.pdf (RFQ)
SBD 1 (Invitation to Bid): signed offer cover page
SBD 4 (Declaration of Interest): discloses any director or shareholder employed by the state or connected to the department
SBD 6.1 (Preference Points Claim): claims B-BBEE points under the 80/20 system
Tax clearance certificate and PIN
B-BBEE certificate or signed affidavit
CVs, certified qualifications and valid certifications for the Data Engineer, Data Analyst and Project Manager
Reference letters on client letterhead, dated and signed
Functional and technical solution (project plan)
SAQA evaluation certificate for foreign qualifications
Disqualification risks:
Failure to submit any of the above documents
Late submission
Failure to meet minimum functionality score of 70/100
Evaluation Criteria
Source: RFQ for Data Cleansing - 17.11.2026.pdf (RFQ)
Evaluation stages:
Compliance evaluation: bidders must meet all minimum requirements and submit all required documents in the required format. Non-compliant bids are disqualified.
Functionality evaluation: maximum 100 points; minimum qualifying score 70/100. Bidders below 70 are disqualified.
Price and specific goals: evaluated on the 80/20 preference point system for bids up to R50 million.
Functionality criteria (100 points):
Data Engineer (20 points): Bachelor's degree in Computer Science, IT, Information Systems or related field; valid certification (Microsoft Azure Data Engineer Associate DP-203, AWS Data Analytics Specialty, Databricks Data Engineer Associate, or CompTIA Data+); minimum 5 years' experience in data extraction, ingestion, transformation, cleansing, ETL/ELT, database design, data migration, data quality management and data privacy. Scoring: 5+ years = 20; 4-5 years = 15; 3-5 years = 10; 2-5 years = 5; less than 2 years = 0; no experience/qualifications/certification = 0.
Data Analyst (20 points): Bachelor's degree in Information Systems, Data Science, Statistics, Computer Science or related field; valid certification (Microsoft Power BI Data Analyst Associate, Tableau Desktop Specialist, Google Data Analytics Certificate, CompTIA Data+, or CDMP); minimum 5 years' experience in data analysis, reporting, data quality, visualisation, anomaly identification and stakeholder reporting. Scoring: 5+ years = 20; 4-5 years = 15; 3-5 years = 10; 2-5 years = 5; less than 2 years = 0; no experience/qualifications/certification = 0.
Project Manager (20 points): Bachelor's degree in Business Management, Project Management, Information Systems or related field; valid certification (PMP, PRINCE2 Practitioner, CAPM, AgilePM, Scrum Master or equivalent); minimum 5 years' experience managing data migration, system implementation, data management or technology projects. Scoring: 5+ years = 20; 4-5 years = 15; 3-5 years = 10; 2-5 years = 5; less than 2 years = 0; no experience/qualifications/certification = 0.
Experience of bidder in similar work (20 points): written references on client letterhead, dated and signed, demonstrating data migration, extraction, cleansing and quality improvement. Scoring: 3 references = 20; 2 references = 15; 1 reference = 10; none = 0.
Functional and technical solution / project plan (20 points): detailed approach covering tools/technologies, methodology for resolving inconsistencies and duplicates, ensuring referential integrity, addressing orphaned records, performing cleansing without compromising live MIS, and ensuring data security and auditability. Scoring: Excellent = 20; Good = 15; Acceptable = 10; Unacceptable = 0.
Preference points (20 points):
Black people ownership: 100% = 5; 75-99% = 4; 51-74% = 3; 0-50% = 0.
People with disability ownership: 100% = 5; 75-99% = 4; 51-74% = 3; 30-50% = 2; 0-29% = 0.
Tie-breaking: highest specific goals points, then highest functionality points, then drawing of lots.
Technical Specifications
Source: RFQ for Data Cleansing - 17.11.2026.pdf (RFQ)
Scope: cleanse, validate and reconcile data across FoodBev SETA's Management Information System (SIMS), Customer Relationship Management system, Microsoft Dynamics 365 Business Central, Commitment Register (Excel) and archived Microsoft Dynamics AX legacy dataset. Objective: achieve an unqualified audit outcome with no material findings and establish a single source of truth for strategic decision-making, statutory reporting and POPIA compliance.
Phase 1: Data Audit and Profiling
Assess current data quality and re-perform internal audit exception tests to confirm, restate or refute exception volumes and values.
Identify anomalies, gaps and duplicates in employer, training provider, learner/apprentice and assessor/moderator datasets.
Deliver a data audit report and a confirmed exception baseline; submit a priced variation if baseline differs materially from the internal audit report.
Phase 2: Data Cleansing and Standardisation
De-duplicate employer records (by company registration/levy number) and learner records (by ID number).
Validate employer data against CIPC and SARS databases.
Standardise addresses, company names and occupational titles to OFO codes.
Enrich missing fields where possible; correct misspellings, incorrect ID numbers and outdated contact details.
Recover and populate missing registration, commencement, completion, endorsement and certificate dates; flag unrecoverable dates.
Correct invalid date sequences (e.g., endorsement before registration, dates outside funding period).
Reconcile learner status against certification evidence; reclassify unsubstantiated completions and quantify effect on DHET-reported learner numbers.
Restore referential integrity across learner, project, employer, provider and financial datasets; correct fractional learner quantities; report unresolvable linkages with financial value.
Assign standardised project status (Open, Active, Suspended, Completed, Terminated, Expired); populate missing project end dates; reconcile contract amendments against Business Central and Commitment Register.
Phase 3: POPIA Compliance and Data Deletion
Identify records with expired or missing consent; flag opt-out requests.
Quarantine or delete records per POPIA manual and retention schedules; do not delete records subject to audit findings, reconciliation exceptions, recovery exposure, ring-fencing or statutory retention; restrict and report instead.
Phase 4: Reconciliation of SIMS, Business Central and Commitment Register
Perform three-way reconciliation for the period under review.
Resolve discrepancies in purchase line amounts, project-employer codes, contracts without transactions, and contracts without approved budgets.
Establish cause, correct records, and quantify residual variances with management sign-off.
Link payments to learners where documentation exists.
Identify manual payments, task orders without purchase lines, and payments exceeding authorised values.
Calculate utilisation for all active contracts and blanket orders; identify zero, under-utilised, over-committed or expired contracts.
Deliver reconciled commitment position and variance schedule supporting GRAP 19 disclosure and Auditor-General re-performance.
Phase 5: Legacy System Migration Remediation
Obtain archived legacy dataset and migration mapping; reconstruct original budget amounts, task order values and transaction dates; re-migrate into Business Central under change control.
Document unrecoverable gaps, quantify audit exposure and obtain management sign-off.
Deliver migration metadata comparing original and migrated values.
Phase 6: Preventative Controls, Data Dictionary and Handover
DHA Identity Verification Report and Verified Baseline
Duplicate Funding and Unsubstantiated Completion Registers
Reconciled Project and Contract Register
Three-Way Reconciliation Report
Migration Remediation Report
Unsubstantiated Transactions Evidence Pack
Preventative Control Specification and System Data Dictionary
Exception Re-Run and Close-Out Report (acceptance is condition precedent to final payment)
Project duration: 3 months from appointment. Phase-gated reviews after Phase 1 and Phase 5; FoodBev SETA may re-scope, re-price or discontinue without liability beyond work accepted.
Methodology
Source: RFQ for Data Cleansing - 17.11.2026.pdf
Bidders must submit a detailed functional and technical solution (project plan) describing the proposed approach for data profiling and cleansing, including:
Tools and technologies for data profiling, cleansing and transformation (e.g., ETL/ELT tools, SQL-based processing, data profiling platforms, automated data quality solutions).
Approach for identifying and resolving data inconsistencies, duplicates and anomalies.
How referential integrity and data consistency will be ensured across datasets.
How orphaned or incomplete records will be identified and addressed.
Approach for performing data cleansing without compromising the integrity of the live MIS environment.
Measures to ensure data security, compliance and auditability throughout the process.
Scoring: Excellent (unambiguous, thorough understanding, full details) = 20 points; Good (meets most requirements, sufficiently detailed) = 15 points; Acceptable (meets some requirements, acceptable understanding, some satisfactory detail) = 10 points; Unacceptable (does not meet requirements, insufficient or no information) = 0 points.
Experience & Qualifications
Source: RFQ for Data Cleansing - 17.11.2026.pdf
Key personnel requirements:
Data Engineer: Bachelor's degree in Computer Science, IT, Information Systems or related field; valid certification (Microsoft Azure Data Engineer Associate DP-203, AWS Data Analytics Specialty, Databricks Data Engineer Associate, or CompTIA Data+); minimum 5 years' experience in data extraction, ingestion, transformation, cleansing, ETL/ELT, database design, data migration, data quality management and data privacy.
Data Analyst: Bachelor's degree in Information Systems, Data Science, Statistics, Computer Science or related field; valid certification (Microsoft Power BI Data Analyst Associate, Tableau Desktop Specialist, Google Data Analytics Certificate, CompTIA Data+, or CDMP); minimum 5 years' experience in data analysis, reporting, data quality, visualisation, anomaly identification and stakeholder reporting.
Project Manager: Bachelor's degree in Business Management, Project Management, Information Systems or related field; valid certification (PMP, PRINCE2 Practitioner, CAPM, AgilePM, Scrum Master or equivalent); minimum 5 years' experience managing data migration, system implementation, data management or technology projects.
Experience scoring for each role:
5 years or more: 20 points
4 to 5 years: 15 points
3 to 5 years: 10 points
More than 2 but less than 5 years: 5 points
Less than 2 years: 0 points
No experience, qualifications or certification: 0 points
Bidder experience:
Must demonstrate in-depth experience in data management practices including data migration, data extraction, data cleansing and remediation, and data quality improvement initiatives.
Supported by written references or testimonials from public or private sector clients, on client letterhead, dated and signed by authorised personnel. Unsigned letters will not be accepted.
Foreign qualifications must be accompanied by a SAQA evaluation certificate; foreign qualifications not endorsed by SAQA will not be considered.
Points are only awarded if the bidder submits both the CV demonstrating relevant experience, the relevant qualification(s) and the required certification. If any of these are missing, no points are allocated.
Pricing Schedule
Source: RFQ for Data Cleansing - 17.11.2026.pdf
Bidders must complete a fixed-cost schedule with the following line items (quantity 1 each):
Data Audit and Assessment
Data Cleansing: employer, provider, project and contract master data (Phase 3)
Automation Tools
Project Management and Reporting
Learner data integrity cleansing (Phase 2)
SIMS to Business Central to Commitment Register reconciliation (Phase 4)
Legacy migration remediation (Phase 5)
Preventative controls, System Data Dictionary and handover (Phase 6)
Sub-total, VAT at 15%, and grand total must be shown.
Financial Requirements
Source: RFQ for Data Cleansing - 17.11.2026.pdf (RFQ)
Pricing: fixed-cost schedule with line items for Data Audit and Assessment; Data Cleansing (employer, provider, project and contract master data); Automation Tools; Project Management and Reporting; Learner data integrity cleansing; SIMS to Business Central to Commitment Register reconciliation; Legacy migration remediation; Preventative controls, System Data Dictionary and handover. Sub-total, VAT at 15%, and grand total must be shown.
Bid validity: 90 days from submission date (tax and B-BBEE certificates must remain valid at award).
Payment terms: invoices payable 30 days after receipt of invoice and statement; no service before official purchase order.
No bid security, performance bond or retention stated.
Compliance Requirements
Source: RFQ for Data Cleansing - 17.11.2026.pdf (RFQ)
CSD registration: full report required.
Tax: valid tax clearance certificate and PIN.
B-BBEE: certificate or signed affidavit required; preference points claimed on SBD 6.1 under 80/20 system.
SBD forms: SBD 1, SBD 4 and SBD 6.1 must be completed and signed by an authorised person.
Professional qualifications: Data Engineer, Data Analyst and Project Manager must each hold a relevant Bachelor's degree and a valid certification as specified; foreign qualifications require SAQA evaluation certificate.
Experience: minimum 5 years' relevant experience for each key personnel role; bidder must provide written reference letters on client letterhead, dated and signed.
POPIA: operator agreement under section 21 of POPIA must be concluded before processing personal information; personnel vetting required.
Local content: no local content requirements stated.
Contractual Terms
Source: RFQ for Data Cleansing - 17.11.2026.pdf
Contract duration: 3 months from appointment.
Phase-gated engagement: formal reviews after Phase 1 and Phase 5; FoodBev SETA may re-scope, re-price or discontinue the engagement in whole or in part without liability beyond the value of work accepted to that date.
Service provider obligations:
Treat all FoodBev SETA data and information as strictly confidential; no disclosure to unauthorised persons.
Do not copy or duplicate software or documentation for private use.
Return all documentation, reports and programmes on completion.
Conclude an operator agreement under section 21 of POPIA before processing personal information; vet all personnel with access to personal information.
Perform all analysis and data manipulation on replicated datasets; apply changes to live systems only under approved change control.
Preserve ring-fenced records in their existing state; alteration constitutes a material breach.
Assign all intellectual property in deliverables (including scripts, queries and change logs) to FoodBev SETA; securely destroy all copies of FoodBev SETA data on completion and certify destruction in writing.
Acquire no right to provide ongoing identity verification or data maintenance services.
Bear parking and travel costs between own office and FoodBev SETA.
Enter into a Service Level Agreement before final acceptance; contract/SLA to be finalised within 5 working days for signature before commencement; bidder responsible for vetting the contract.
Award rules:
If two or more tenderers score equal total points, award to the highest specific goals points.
If equal total points and equal specific goals points, award to the highest functionality points.
If equal in all respects, award by drawing of lots.
Confidentiality: bids are not revealed to other bidders; all FoodBev SETA information obtained through the RFQ is confidential; project lead must abide by FoodBev SETA Code of Conduct and applicable laws.
FoodBev SETA reserves the right to: not appoint; award to a bidder not scoring highest on reasonable grounds; award to one or more service providers; reject all bids; decline non-conforming bids; request further information after closing; cancel the RFQ; require shortlisted bidders to make presentations at their own cost. Points are rounded to 2 decimals. FoodBev SETA does not request bribes; any such request must be reported to FoodBev SETA and the police.
Sets the constitutional standard for fair, equitable, transparent, competitive and cost-effective public procurement.
Relevant because this is a South African public-sector procurement opportunity.
This tender has strong source evidence, including source metadata and supporting tender information synced from the government tender portal.
Tenders SA is not the issuing authority. All tenders are automatically synced from the official government tender portal. Always confirm final submission details, closing dates, briefing sessions, eligibility requirements, and documents on the official government portal before applying.