Job Description – Master data Administrator

Role PurposeThe Master Data Administrator is responsible for managing, maintaining, and improving Avnzor’s supplier product catalogue of approximately 50,000 SKUs.The role will act as the central owner of catalogue data, ensuring that all product information is accurate, complete, structured, validated, and ready for use across the website, mobile application, ERP, WMS, marketplaces, buying files, and internal reporting systems.The successful candidate must be highly proficient in Microsoft Excel and Google Sheets, with the ability to clean, consolidate, analyse, validate, and manage large volumes of supplier and product data.Key Responsibilities1. Supplier Catalogue ManagementOwn and maintain a supplier catalogue containing approximately 50,000 SKUs.Create, update, validate, and archive product records.Ensure each SKU has complete and accurate product information.Maintain one reliable master catalogue as the single source of truth.Regularly audit catalogue data to identify missing, duplicated, incorrect, or outdated records.Manage catalogue updates received from suppliers, Buying, Commercial, Operations, and other departments.Maintain a full history and archive of catalogue changes.2. Product Master DataCreate and maintain the following product information:SKU and internal product codesBarcode, UPC, EAN, and GTINSupplier product codesBrand and manufacturerProduct titleProduct descriptionCategory and subcategoryProduct typeVariant informationSize, flavour, colour, strength, and formatPack size and case configurationUnit of measurementCountry of originIngredientsDirections for useProduct benefitsWarnings and storage instructionsProduct dimensions and weightShelf life and expiry requirementsImages and digital assetsCost priceRecommended retail priceSelling priceVAT informationRegulatory and registration informationProduct status, including active, inactive, discontinued, or out of stock3. Excel and Google Sheets Data ManagementAdvanced Microsoft Excel and Google Sheets capability is a critical and mandatory requirement for this position.The role will be responsible for:Managing datasets containing 50,000 or more product records.Cleaning and standardising supplier catalogue files.Consolidating data from multiple suppliers and systems.Creating and maintaining master catalogue templates.Comparing supplier catalogues against existing company records.Identifying new, existing, duplicated, discontinued, and missing SKUs.Preparing bulk-upload files for internal and external systems.Performing mass data updates accurately.Creating validation checks to reduce catalogue errors.Building catalogue health dashboards and reports.Maintaining version control and accurate data archives.The candidate must be comfortable using:XLOOKUPVLOOKUPINDEX and MATCHSUMIFS and COUNTIFSIF, IFS, and IFERRORPivot TablesPivot ChartsConditional FormattingData ValidationDuplicate identificationText-to-columnsRemove duplicatesDynamic arraysFilters and advanced filtersCSV filesData cleansing functionsLarge spreadsheet reconciliationPower Query is strongly preferredGoogle Sheets query and import functions are preferred4. Data Validation and Quality ControlValidate all new product information before products are created or published.Ensure mandatory product fields are complete.Verify barcodes and supplier product codes.Identify and resolve duplicate SKU records.Standardise naming conventions, brands, categories, units, and attributes.Ensure pack sizes, units of measurement, weights, and dimensions are accurate.Perform regular catalogue accuracy audits.Investigate and resolve catalogue discrepancies across systems.Prevent incorrect product information from reaching customers or internal teams.Maintain defined catalogue data-quality standards.5. New SKU Creation and Product OnboardingCollect product data from suppliers and the Buying team.Review supplier files for completeness and accuracy.Create new products and SKUs in the relevant systems.Ensure new products are fully set up before stock arrives.Coordinate missing information, images, pricing, and documentation.Track products from initial supplier submission through to publication.Ensure new products are correctly categorised and searchable.Confirm that all required fields are completed before products go live.6. Mass Uploads and System UpdatesPrepare, validate, and execute mass-upload files.Ensure upload templates follow the required system format.Validate successful uploads and identify failed records.Correct errors and resubmit rejected product records.Maintain records of all mass uploads and catalogue changes.Coordinate with Technology, ERP, WMS, Ecommerce, and Marketplace teams when system issues occur.Ensure data is accurately transferred between the master catalogue and operational systems.7. Ecommerce and Marketplace Catalogue SupportEnsure product data is ready for publication on the Avnzor website and application.Prepare product data for Amazon, Noon, Trendyol, and other marketplaces.Maintain channel-specific product attributes and templates.Support bulk product listings and product updates.Resolve rejected or suppressed marketplace listings caused by catalogue data.Ensure product titles, images, descriptions, pricing, and attributes are accurate across channels.Coordinate with Ecommerce and Marketplace teams to resolve listing discrepancies.8. Category and Product ClassificationMaintain the product category hierarchy.Assign products to the correct departments, categories, and subcategories.Maintain product taxonomy and product attributes.Ensure consistent classification across all systems.Review and correct products listed under incorrect categories.Support catalogue navigation, filtering, search, and merchandising.Work with Buying and Merchandising to improve product discoverability.9. Pricing and Commercial DataMaintain supplier cost prices and recommended retail prices.Update selling prices following approved commercial instructions.Validate promotional price files before upload.Identify missing, incorrect, or inconsistent pricing.Support price comparisons and supplier catalogue analysis.Ensure pricing files are accurately reflected in relevant systems.Maintain a complete record of approved price changes.10. Reporting and Catalogue DashboardsPrepare regular reports covering:Total active SKUsTotal inactive SKUsNew SKUs createdProducts awaiting informationProducts awaiting imagesMissing attributesMissing barcodesDuplicate productsFailed uploadsCatalogue completenessProduct publishing statusSupplier catalogue coveragePricing discrepanciesCategory accuracyDiscontinued productsCatalogue data-quality issuesThe role will also maintain catalogue dashboards and scorecards for management review.11. Stakeholder CoordinationWork closely with:BuyingCategory ManagementSuppliersEcommerceMarketplaceMerchandisingMarketingFinanceSupply ChainWarehouseTechnologys.Key Performance IndicatorsCatalogue accuracy of at least 99.5%.Catalogue completeness of at least 98%.Zero duplicated active SKU records.New SKU creation completed within 24–48 hours of receiving complete information.100% validation of mass-upload files before submission.Zero critical upload errors caused by incorrect spreadsheet formatting.Product data completed before stock arrival.Product image completeness of at least 98%.Pricing accuracy of at least 99.5%.Failed catalogue uploads below 1%.Product category accuracy of at least 99%.Catalogue requests completed within agreed service levels.Accurate maintenance of the 50,000-SKU supplier catalogue.Catalogue dashboards and reports delivered on time.Essential Qualifications and ExperienceBachelor’s degree in Business Administration, Information Systems, Data Management, Supply Chain, Ecommerce, or a related discipline.Minimum 2–4 years of experience in master data, catalogue management, product information management, ecommerce operations, buying support, or commercial administration.Proven experience managing large product catalogues.Experience working with datasets containing at least 20,000–50,000 records.Advanced Microsoft Excel skills.Advanced Google Sheets skills.Experience cleaning, matching, consolidating, and validating large datasets.Experience preparing mass-upload files.Experience working with an ERP, PIM, WMS, Shopify, or ecommerce platform.Experience in retail, ecommerce, pharmacy, healthcare, wellness, FMCG, or consumer products is preferred.Required SkillsAdvanced Microsoft Excel.Advanced Google Sheets.Strong data analysis and reconciliation skills.Exceptional attention to detail.Ability to identify inconsistencies within large datasets.Strong numerical and analytical capability.Excellent organisational skills.Strong problem-solving ability.Ability to manage repetitive data tasks without compromising accuracy.Ability to prioritise high volumes of catalogue requests.English proficiency is required.Arabic proficiency is preferred.Practical AssessmentShortlisted candidates will be required to complete a practical Excel or Google Sheets assessment.The assessment may include:Cleaning a supplier catalogue.Matching supplier products against an existing master catalogue.Identifying duplicate SKUs and barcodes.Using XLOOKUP or INDEX/MATCH.Standardising product titles and categories.Identifying missing mandatory fields.Preparing a bulk-upload template.Creating a Pivot Table report.Building a catalogue-completeness summary.Managing and validating a large dataset.Success in the RoleSuccess means maintaining a clean, reliable, and commercially usable catalogue of approximately 50,000 supplier SKUs.The Master Data Administrator will ensure that every product record is accurate, complete, correctly classified, and ready for use across all Avnzor systems and sales channels. The role will reduce listing errors, accelerate product onboarding, improve customer experience, and provide the business with one trusted source of product information.