Freelance Data Collection Jobs

Remote Property Management Specialist

Seeking an experienced Remote Property Management Specialist to oversee residential and small commercial portfolios. Responsibilities include tenant screening and onboarding, rent collection, lease administration, vendor coordination, routine inspections, maintenance oversight, and financial reporting. Must possess strong communication, problem-solving, and organizational skills, with familiarity in property management software and local landlord-tenant regulations. Proven track record in maximizing occupancy, minimizing delinquencies, and ensuring property upkeep required. Competitive, ongoing engagement.

opportunity

AI Monitoring Platform for UK Company Alerts

Project Title: AI Monitoring Platform for UK Company Financial Distress & Insolvency Alerts (SIC-Based) Project Overview: I’m looking for an experienced developer (or small team) to build an AI-powered monitoring platform or intelligent agent that tracks UK companies within pre-defined SIC codes and automatically alerts me when there are signs of financial distress or insolvency. The system should continuously monitor company data, detect risk signals, and provide both real-time alerts and structured reporting. Core Objective: To proactively identify companies within selected industries that are: Experiencing financial decline (e.g. credit score drop) Entering insolvency processes (e.g. notice of intent to appoint administrators) Showing early warning signs of distress Key Functional Requirements: 1. Company Data Collection The platform must: Pull and maintain a live database of UK companies filtered by selected SIC codes Sources should include: Companies House API Commercial data providers such as Creditsafe, Experian, Dun & Bradstreet (or similar via API) 2. Data Monitoring (Automated & Ongoing) The system should periodically (daily or weekly) re-check and update the following: Credit score (via commercial providers) Filing timeliness (overdue accounts, confirmation statements, etc.) Insolvency indicators: Notice of Intent to Appoint Administrators Administration Liquidation CVAs Director changes: Appointments Resignations 3. Financial Data Enrichment (Important) Where available, the platform should also pull and display from latest filed accounts: Turnover / Revenue Balance sheet data (e.g. total assets, liabilities, net assets) This can be sourced from: Companies House filings (accounts data) Or via commercial data providers if more structured/standardised 4. Alert Triggers The platform must generate alerts when: A company’s credit score drops by 5% or more Include the exact percentage drop in the alert Any insolvency-related event is detected, including: Notice of Intent for Administration Administration Liquidation 5. Alert Delivery Alerts should be sent via: Email (minimum requirement) Ideally also: Slack / Microsoft Teams Web dashboard notifications 6. Reporting (Key Requirement) The system must automatically generate and send: Daily report Weekly report Monthly report Each report should be delivered as a spreadsheet (Excel or Google Sheets) and include: Columns to include (minimum): Company Name Company Number SIC Code Date of event/activity Type of event (e.g. credit score drop, insolvency notice, director change) Previous credit score New credit score % change in credit score Filing status (on time / overdue) Insolvency status Director changes (summary) Turnover (latest available) Key balance sheet figures (assets, liabilities, net position) Reports should clearly show date-stamped activity and allow filtering/sorting. 7. Dashboard / Interface (Preferred) A simple dashboard to: View and filter companies by SIC code Track alerts and risk levels View historical changes and trends Export data 8. AI / Intelligence Layer (Optional but Preferred) Identify early warning signals before insolvency Highlight patterns (e.g. repeated late filings + score decline) Rank companies by risk level or likelihood of distress Technical Requirements: Experience integrating APIs (Companies House + credit agencies) Ability to build automated data polling (scheduled jobs) Cloud-based database and infrastructure Alerting and reporting automation Scalable architecture Data Sources (Must Be Used): Companies House API (free, primary source) Commercial credit data providers such as: Creditsafe Experian Business Dun & Bradstreet Please advise on: Best provider(s) to use API access requirements Ongoing data/licensing costs Deliverables: Fully functioning monitoring and alert system Automated reporting (daily, weekly, monthly) Spreadsheet output format Documentation and user guidance Ability to adjust SIC codes and thresholds Optional ongoing support Nice to Have: CRM integration (e.g. Zoho) Webhooks for automation Customisable reporting Data visualisation Budget & Timeline: Open to proposals – please include: Estimated cost Timeline Recommended tech stack Relevant experience / similar projects

opportunity

Simplifying our Master pricelist

We require an expert to streamline our Master pricelist spreadsheet. The workbook contains extensive data, numerous VLOOKUP operations, and synchronization with our Sage database via the "Sage Data" sheet. Despite a reduced upload copy, the file remains sluggish—taking over a minute to open and delay when saving/closing. Deliverables: optimize formulas, restructure for performance, implement efficient lookup/indexing strategies or Power Query/SQL alternatives, and provide a lean, responsive workbook with documented changes and recommendations.

SEO Specialist Needed

SEO SPECIALIST NEEDED - Shopify, UK Wellness Brand We've just completed a full independent SEO audit (Screaming Frog, GSC, GA4, Majestic, Ahrefs, Semrush). We know what's wrong. We need someone to have input but execute - not audit, not strategise from scratch. THE SITUATION: • DA 6 / Trust Flow 1 - starting from scratch • Zero commercial keyword rankings, all traffic is branded • Previous agency built 90+ spam backlinks that did nothing • 38 pages missing H1s, 33 collection H1s wasting keyword opportunity • Technical foundation is solid - authority and on-page is the problem WHAT WE NEED: 1. TECHNICAL FIXES (one-off) • Add H1s to 38 pages in Shopify Liquid templates • Remove "Collection:" prefix from 33 collection H1s (replacements provided) • Fix 7 broken 404 pages - remove 134 internal links from theme templates • Fix duplicate titles (7 pairs), duplicate metas (9 pairs), add 14 missing metas • Shorten 60 truncated titles (optimised versions provided) • Fix orphan pages, image alt text, heading structure • Re-crawl with Screaming Frog after each batch to verify 2. LINK BUILDING (ongoing) • Quality only - DA 25+, relevant wellness/health/nutrition sites etc • UK-focused outreach to nutritionists, health bloggers, wellness publications • No classified ads, web 2.0, profile links or link farms - we verify every link • 3-5 quality links/month minimum 3. KEYWORD STRATEGY (ongoing) • Map pages to target keywords, identify quick wins • Monthly GSC monitoring - non-branded growth is the metric that matters • UK commercial intent, supplements/wellness niche REQUIREMENTS: ✓ Own Screaming Frog licence ✓ Works directly in Shopify theme code (Liquid, theme.liquid, sections) ✓ Quality link outreach experience ✓ Reports from GSC data, not ranking tool screenshots TO APPLY: 1. Do you have your own Screaming Frog licence? 2. How many Shopify sites have you fixed technical SEO on? Share an example. 3. Describe your link building process - prospects, outreach, DA/TF targets. 4. Show a before/after using GSC data (not DA movement). DON'T APPLY IF: you use spam link methods, can't show Shopify work, have never edited Liquid, or only show DA as a result metric. Fixed fee for technical fixes, then ongoing monthly. Serious applicants only.

Weekly/monthly data input into quickbooks

I work in construction and i want my new quickbooks account to run like a machine. I have started to work it all out but i think i should pay someone to enter the data as it takes me too long and also some anomolies that crop up i dont know how to deal with them. Weekly is best or fortnightly

Xero project move

Require an experienced Xero specialist to manage a seamless migration between Xero organizations. Project involves transferring three companies, ensuring accurate migration of charts of accounts, historical transactions, bank reconciliations, payroll data, invoices, and attachments. Successful candidate must demonstrate prior Xero-to-Xero migration experience, meticulous attention to detail, strong reconciliation skills, and ability to validate data integrity post-migration. Deliverables include documented migration plan, completed transfers, reconciliation reports, and resolution of discrepancies.

Shopify developer needed to build custom audio player

I’m building a Shopify website and need a custom audio player section where visitors can play MP3 voice demos. Requirements: • Play / pause button • Clean SaaS-style design • Optional waveform or progress bar • Ability to add multiple audio demos • Must be editable from the Shopify theme editor Example: Appointment Booking AI collects details and books a time [▶]━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ My website: https://flowspeakai.com/ Budget: £40-£100, depending on experience.

Setup a Basic Shopify Dropshipping Store (Home Office Niche)

Seeking an experienced Shopify specialist to build a polished dropshipping store in the Home Office & Ergonomic Accessories niche. Deliverables: install a clean free theme; craft a homepage with hero, featured collections, simple text logo and cohesive color palette; import 10–15 products with optimized images and descriptions; create About, Contact, Shipping and Refund pages; configure intuitive navigation; install 2–3 essential free apps; ensure mobile responsiveness and provide clear ownership transfer guidance. Fixed-price bid; project split into two milestones.

Sales and Marketing Representative

Seeking a driven Sales and Marketing freelancer to promote and sell a curated collection of premium photography prints on commission. Ideal candidates have proven sales success, preferably in art or photography, and excel at leveraging social media to attract and engage buyers. Responsibilities include identifying target audiences, crafting compelling campaigns, implementing sales strategies, and engaging customers to convert interest into purchases. Passion for photography, strong communication, and a results-oriented mindset are essential.

opportunity

Data Entry + Web Research: Add Hotels & Restaurants

We’re building a global hotels & restaurants review platform and need a reliable assistant to add venues and complete their profiles so users can review them. This is ongoing work. We’ll start with a paid test batch, and if quality is strong we scale weekly. What you will do For each hotel/restaurant you will: Add the venue to our platform Fill in profile details accurately: Name Full address + city + country Category (hotel/restaurant + type) Website Phone (if available) Opening hours (restaurants) Short description (2–3 sentences, clean English) 5–10 high-quality photos (from official sources only, with links saved) Social links (Instagram/Facebook if available) Ensure formatting is consistent and error-free Rules (important) Accuracy > speed (no wrong addresses, no fake info) Use official sources first (official website, Google Maps, official social pages) Don’t upload random copyrighted images from blogs—use official/press/Google Business where allowed and always save the source link Every entry must be clean, consistent, and review-ready Starting Scope (Test) 50 venues as a paid test (mix of hotels + restaurants) If quality is good: 200–500 venues/week ongoing What I need from you You are detail-obsessed Strong English writing (short descriptions) Fast, accurate web research Comfortable with spreadsheets + admin dashboards Deliverables Completed venue profiles in the platform A Google Sheet log with: Venue name Link to the profile on our site Source links used (website, maps, photos source) To apply, answer these Have you done similar work (directory listings / web research / data entry)? How many venues can you do per day while staying accurate? Confirm you can follow strict formatting and provide a source link for photos/info. Your price for the first 50 venues (fixed) and your price per 100 after. Bonus (optional) If you can also find direct contact emails for owners/managers, mention it.

opportunity

Extract blood test data from PDF documents that have been OCR'd

The objective is to build a structured blood test database that allows pathology results to be viewed, edited, filtered, and exported to Excel via a web-based HTML interface. The system stores results in a clean, standardised format so trends can be analysed accurately over time. Using AI-assisted OCR, I have built a local Python extraction pipeline that converts PDF pathology reports into machine-readable text and inserts structured data into a SQLite database. The majority of blood tests extract correctly, including canonical test name, result value, unit, and reference range. However, I have reached a specific technical issue with three markers: • CRP (C-reactive protein) • ESR • GLU (Glucose) The OCR output clearly contains the correct lines, and debug logs confirm they are processed. Yet no rows are inserted for these markers. The failure appears to occur between canonical matching, numeric extraction, or validation logic. Current System Architecture The system runs locally and consists of: • extraction_core_2.py (main engine) • Supporting modules for OCR preprocessing, lab dictionary building, regex matching, and validation • SQLite backend • Schema-driven canonical lab dictionary • Controlled fuzzy fallback logic • HTML viewer for results display and Excel export Pipeline flow: Convert PDF to image (pdf2image) Preprocess Run Tesseract OCR Clean and normalise text Match against canonical lab dictionary Extract: canonical test name numeric result unit reference range Validate Insert into SQLite The engine is deterministic and rule-based. The Specific Problem Example OCR line: CRP H 5.2 mg/L 0-5 OCR text is correct. NUMBER_PATTERN matches. The canonical dictionary contains the test. Yet: Inserted 0 rows from 0126251OrderReport_23B00006604_CRP.pdf Likely failure points include: • Canonical containment match failing due to normalisation • Flag tokens (“H”, “L”) interfering with numeric capture • Numeric extraction anchored incorrectly • Validation rejecting due to strict range formatting • Unit pattern mismatch (e.g. mmol/L) • Dictionary indexing issue • Match overridden by another lab name • Guard conditions too strict If validation fails, the row is rejected silently. All other panels extract correctly. The issue appears isolated. What Is Required This is not a rebuild. We do not want: • Re-architecture • Experimental AI guessing logic • Large-scale changes • Expanded fuzzy matching We need: 1. Precise Diagnosis Identify exactly where CRP, ESR, and GLU are failing insertion and which rule is causing rejection. 2. Minimal Safe Fix Implement a targeted correction that: • Adjusts canonical matching if required • Anchors numeric extraction correctly • Allows flag tokens without blocking capture • Relaxes only necessary validation checks • Preserves deterministic behaviour 3. Zero Regression • No impact to currently working panels • No performance degradation • No uncontrolled fuzzy expansion 4. Modular Implementation If appropriate: • Implement as small isolated module or • Cleanly adjust matching block The existing architecture should remain intact. Constraints The system is designed to be: • Deterministic • Schema-driven • Reproducible • Forensic-grade We cannot introduce probabilistic or unpredictable behaviour. Longer-Term Goal After stabilising extraction: • Migrate to web deployment • Enable structured uploads • Add trend analysis • Later incorporate AI-assisted interpretation Immediate priority: Stabilise deterministic extraction for CRP, ESR, and GLU without breaking the existing engine. Materials Provided Uploaded: • Full extraction_core_2.py (text format) • Screenshot of HTML viewer • Sample PDF files • Export showing required output Additional materials available on request: • Sample OCR blocks • Canonical dictionary entries • Regex patterns • Validation logic • Database schema • Debug logs This is a focused debugging and refinement request. I have spent many hours attempting to isolate the issue and now require an experienced developer to identify the blocking condition and implement a practical fix. I have been advised this should take 1–2 hours for a senior developer. Looking for a swift turnaround.

Ai Service for automation in bureauceacy

I will pay 10 Dollar for each automation for Secretary work. 1) getting emails from homepage and collecting emails to Google sheets and Sending 3 Emails in sequence. 2) booking schedules

AI / Machine Learning Engineer (LLM & Applied AI) – Remote (EU)

Responsibilities AI / Machine Learning Build and deploy AI-powered applications using existing Large Language Models (LLMs). Design systems that ingest data, extract structured insights, and generate accurate outputs. Develop RAG pipelines, chunking strategies, and LLM orchestration workflows. Build tools for model training, evaluation, inference serving, monitoring, and alerting. Experiment with modern ML frameworks and open-source AI tools. Software Engineering Develop scalable microservices that integrate AI models with production systems. Build APIs and backend services to process and manage AI-generated data. Work with modern programming languages such as Python, JavaScript, Go, or Rust. Data Engineering Design pipelines to extract, transform, and load data from multiple sources. Clean, normalize, and validate datasets for model usage. Optimize data pipelines for reliability and performance. Database & Infrastructure Design database schemas and optimize queries. Manage performance and scalability of data storage systems. Ensure AI infrastructure is production-ready and scalable. Collaboration Work closely with product managers, engineers, and subject matter experts. Communicate technical challenges and solutions clearly. Help define best practices for AI system architecture and development. Requirements Based in the European Union 8+ years of software engineering experience Strong experience with Python or JavaScript Hands-on experience with LLM APIs (OpenAI, Anthropic, or similar) AI / LLM Experience Experience building RAG systems Knowledge of chunking strategies for LLM optimization Experience with LangChain, LangGraph, or similar orchestration tools Familiarity with AI monitoring, observability, and evaluation frameworks Experience building agent-based workflows or AI automation Engineering Experience Experience building microservices and scalable systems Strong knowledge of data pipelines and ETL processes Experience designing and optimizing databases and data models Additional Skills Strong understanding of ML concepts and NLP techniques Ability to work with ambiguous problems and rapidly evolving AI tools Experience with modern software development practices (Git, testing, CI/CD, code reviews) Engagement Details Location: Remote (EU-based freelancers only) Contract: Freelance Availability: Part-time or Full-time Duration: Long-term collaboration possible Nice to Have Experience building AI agents or multi-agent workflows Experience with evaluation frameworks for LLMs Experience deploying AI infrastructure in production environments

AI / Machine Learning Engineer (LLM & Applied AI) – Remote (EU)

Responsibilities AI / Machine Learning Build and deploy AI-powered applications using existing Large Language Models (LLMs). Design systems that ingest data, extract structured insights, and generate accurate outputs. Develop RAG pipelines, chunking strategies, and LLM orchestration workflows. Build tools for model training, evaluation, inference serving, monitoring, and alerting. Experiment with modern ML frameworks and open-source AI tools. Software Engineering Develop scalable microservices that integrate AI models with production systems. Build APIs and backend services to process and manage AI-generated data. Work with modern programming languages such as Python, JavaScript, Go, or Rust. Data Engineering Design pipelines to extract, transform, and load data from multiple sources. Clean, normalize, and validate datasets for model usage. Optimize data pipelines for reliability and performance. Database & Infrastructure Design database schemas and optimize queries. Manage performance and scalability of data storage systems. Ensure AI infrastructure is production-ready and scalable. Collaboration Work closely with product managers, engineers, and subject matter experts. Communicate technical challenges and solutions clearly. Help define best practices for AI system architecture and development. Requirements Based in the European Union 8+ years of software engineering experience Strong experience with Python or JavaScript Hands-on experience with LLM APIs (OpenAI, Anthropic, or similar) AI / LLM Experience Experience building RAG systems Knowledge of chunking strategies for LLM optimization Experience with LangChain, LangGraph, or similar orchestration tools Familiarity with AI monitoring, observability, and evaluation frameworks Experience building agent-based workflows or AI automation Engineering Experience Experience building microservices and scalable systems Strong knowledge of data pipelines and ETL processes Experience designing and optimizing databases and data models Additional Skills Strong understanding of ML concepts and NLP techniques Ability to work with ambiguous problems and rapidly evolving AI tools Experience with modern software development practices (Git, testing, CI/CD, code reviews) Engagement Details Location: Remote (EU-based freelancers only) Contract: Freelance Availability: Part-time or Full-time Duration: Long-term collaboration possible Nice to Have Experience building AI agents or multi-agent workflows Experience with evaluation frameworks for LLMs Experience deploying AI infrastructure in production environments

urgent

AI Marketing Implementation Specialist Thailand & UK Business

WHO WE ARE Peyton & Charmed Group is a multi-brand business operating between Thailand and the UK across 5 business units: - UK Student Accommodation (peytonandcharmedaccomm.co.uk) - UK Property Investment — integrated with Accommodation - Koh Chang Travel & Tours (kohchangthailandtours.com) - Private Land Transfers — currently Koh Chang to Bangkok route, growing nationwide - Bangkok City Stays (peytonandcharmedbkk.com) IMPORTANT — THIS IS NOT A SOCIAL MEDIA SETUP PROJECT We already have Facebook, Instagram and TikTok running across all business units. We do not need accounts created or basic profile work. We need an AI marketing implementation specialist to come in, build AI tools and workflows on top of what we already have, and hand everything over so our in-house team can run it themselves. WHAT YOU WILL IMPLEMENT - Audit our existing channels and identify gaps and opportunities - AI-powered content workflow — our team films, AI does the editing and posting - LLM-powered chatbots on Instagram, Facebook, LINE OA and WhatsApp — must understand natural language in English and Thai, not basic keyword bots - Scheduling and auto-posting across all platforms - Analytics dashboard so we can track what is working - Brand kit and video templates per business unit - Content calendar system our team fills in weekly - Filming guide per business unit for our team TRANSFERS NOTE Transfers currently runs as one route — Koh Chang to Bangkok — promoted through our Koh Chang channels. Phase 1 is to cross-promote this within Koh Chang content. A standalone Transfers setup is a future phase and not in scope for this project. TOOLS We are not fixed on specific tools. Recommend whatever AI tools you believe will work best for us and include the costs in your proposal. We own CapCut Pro and want it included where possible. TIMELINE — URGENT We need this completed within 2 weeks from start. Freelancers who can deliver faster will be given priority. WHEN APPLYING PLEASE INCLUDE - Examples of AI marketing systems you have implemented — not just social media management - Examples of LLM chatbots you have configured - Your recommended toolset with costs - Your fixed project rate - Your fastest realistic completion time We are two audiences — Thai families going to the UK, and international tourists coming to Thailand. Bilingual English and Thai strongly preferred. Need a quotation and road map - the follow a must DATA ANALYSIS & CUSTOMER PERSONA REPORTS This is a core requirement of the project, not an optional extra. We need the freelancer to conduct full data analysis across all our existing social media channels and customer data for each of our 5 business units. From this data analysis you must produce detailed customer persona reports that identify exactly who our customers are, what drives them to buy, what stops them buying, and how we can upsell and cross-sell our services across all business units. Data analysis deliverables required: - Full data analysis of existing social channels, audience insights and engagement patterns per BU - Customer persona report per BU based on data analysis findings - Buying trigger report — what motivates each customer type to purchase - Upsell and cross-sell opportunity map across all 5 BUs - Customer journey map per BU showing where we are losing potential customers - Ongoing data analysis system so our team can track and update this over time All data analysis and persona reports must be delivered by Day 3-5 of the project as they drive everything else — content, chatbots, strategy and messaging. Content without data analysis is just guesswork. When applying please include examples of data analysis reports and customer persona work you have completed for other businesses.

Data Sheet Research & Admin Support

Expanding online business (marketing agency/coaching company) looking to recruit a rockstar Virtual Assistant to manage and execute on research, data entry, and administrative tasks within the company. There is plenty of room for advancement and long-term employment if you’re competent, hard-working, detail-oriented, and efficient. Your Main Responsibilities: We currently have a large spreadsheet containing business names and website links. Your role will include: Opening each business website and locating their Google Business profile (or searching for it on Google). Reviewing their social media pages and/or testimonials to determine whether the business is active. Identifying and recording the name of the business owner (if available). Finding and verifying the correct contact phone number. Updating and organizing all collected information accurately into the spreadsheet. Ensuring there are no duplicates and that data is clean and properly formatted. We’re Looking For Someone Who: Is extremely detail-oriented and organized Has strong online research skills Is comfortable navigating Google, social media platforms, and business directories Can follow instructions carefully Works efficiently without sacrificing accuracy Has experience with spreadsheets (Google Sheets or Excel) Has excellent written English Bonus Points If You: Have experience in lead generation or data enrichment Have worked with marketing agencies or online businesses before Can suggest improvements to processes This is a results-driven role. If you’re reliable, proactive, and take ownership of your work, there is strong potential for ongoing work and growth within the company. If you apply, please start your application with the word “Detail” so we know you’ve read this thoroughly. Looking forward to working with you

Need help analyse a data set and create results in dashboard

We are seeking an adept data analyst to meticulously evaluate a dataset in Excel and craft a dynamic dashboard that vividly presents key performance indicators (KPIs) using Power BI. The dashboard should be designed to seamlessly incorporate additional data while ensuring optimal functionality. The project is expected to take approximately three hours for a qualified expert. A collaborative session via Zoom or a similar platform will be essential to discuss project specifics and expectations. Proficiency in Excel and dashboard creation is imperative for this endeavor.

Input property details

I need two properties added to the management website https://www.landlordvision.co.uk/ If you are famililar with UK property, that would be perfect! But no essential. The priority is someone who knows computers, websites and data entry and can do so for cheap.

Simple Data Entry Assistant (European Only)

I am looking for a reliable and detail-oriented individual based in Serbia to assist with very simple data entry tasks. The work mainly involves copy-paste actions, basic typing, and organizing information. No advanced technical skills are required. This role is ideal for someone who is consistent, motivated, and comfortable working with repetitive tasks. Responsibilities: - Copy & paste data between documents or systems - Basic typing and text input - Simple data organization - Following clear instructions Requirements: - Must be located in Serbia - Age range: 30–40 preferred - Basic English communication skills - Good attention to detail - Reliable internet connection - Available for regular work - Responsible and self-motivated No Special Skills Needed - This is not a technical role. Training and instructions will be provided. What matters most is reliability, accuracy, and availability. Work Type: - Remote - Flexible hours - Long-term cooperation possible If you are dependable, patient, and looking for simple online work, feel free to apply.

opportunityurgent

Product Data Mapping Specialist Needed for 250,000 SKU EPOS File

Job Description: We are looking for a detail-oriented freelancer to support a structured data-mapping project for a large EPOS export containing approximately 250,000 products. Each product includes core fields such as SKU, description, brand, size, and other attributes. Your role is not to create new category structures, but to map each product accurately and consistently into a predefined hierarchy and tagging framework. This work is highly important as the mapped data will be used for reporting, analytics, and future automation, so accuracy, logic, and consistency are essential. Scope of Work Each product must be assigned to a fixed 3-level category hierarchy: Department (Level 1) Sub-Department (Level 2) Analysis Code (Level 3) Example: Department: ART Sub-Department: PAINT Analysis Code: WATERCOLOUR This means all watercolour paints would be mapped to: ART → PAINT → WATERCOLOUR We will provide: The approved list of Departments The approved Sub-Departments for each Department The approved Analysis Codes for each Sub-Department You must not create new categories, rename existing ones, or deviate from the supplied structure without approval. Existing Top-Level Departments Examples include: ART CRAFT STATIONERY JIGSAWS LEGO Additional departments will be included in the master file. Tagging Requirements In addition to category mapping, products must also be assigned tags in separate columns. Required tag groups include: Brand (for example: Winsor & Newton, Faber-Castell, LEGO) Size / Volume (for example: 12ml, A4, 500g, Pack of 10) Other clearly identifiable and consistently reusable attributes where appropriate Tags must be: Clean Standardised Reusable Free from unnecessary variations Mapping Rules Use the product name, description, brand, and available attributes to determine placement Similar products must always be mapped consistently If a product is unclear or ambiguous, flag it instead of guessing Do not make assumptions without a logical basis Output Required The final Excel output should include at minimum: Original SKU / Product ID Department Sub-Department Analysis Code Brand Tag Size Tag Notes / Flags (if applicable) Important Requirements No blank category fields unless clearly flagged No free-text category creation Strict adherence to the supplied structures Strong attention to detail and consistency throughout Validation Process Before full rollout, we would like the selected freelancer to complete a small sample batch for validation. We will review this first to ensure alignment before the full file is processed. Ideal Freelancer We are looking for someone with: Strong Excel skills Excellent attention to detail Experience with large product catalogues, categorisation, or data cleansing A logical and methodical approach to classification work If anything in the structure or logic is unclear, we would expect questions to be raised early. It is more important that this is done correctly than quickly. Please include relevant experience when applying, especially any examples of product mapping, taxonomy work, catalogue clean-up, or structured data classification.