Data Engineer Needed for Rapid Data Cleanup and Transformation (Excel-Based)

$500.00
Fixed price

We’re looking for an experienced data engineer or data wrangler to help us quickly clean, standardize, and expand an Excel-based dataset in preparation for migration into a new ERP system. The project involves normalizing color codes, expanding product-color combinations using a reference tab, merging descriptions, and handling some special formatting rules. You'll be working with two tabs from the same workbook — one containing the core data and another containing reference values. Deliverables: One cleaned and completed Excel or CSV file with: One row per unique item, part number, and color combination Correct application of reference-based color expansions Merged and standardized descriptions Preserved structure and integrity of non-transformed columns Special logic applied for certain exceptions (e.g., unique color codes and part variants) Requirements: Strong experience with Excel data processing, Python (Pandas), or other ETL tools Ability to understand and execute transformation logic based on written specs Fast turnaround — we are looking to complete this within 1–2 days Bonus: Familiarity with manufacturing or ERP-related data workflows Experience with Excel formula automation or scripting Please include examples of similar data transformation work in your proposal. We will provide the Excel file and a detailed written brief upon acceptance.

Keyword: Data Cleaning

Price: $500.0

Data Engineering Data Analysis Data Mining Microsoft Excel

I want to apply

Need 1500+ HTML Files Parsed for Content and XML Generated

I need someone to take a set of HTML pages that were built using Front Page and extract: 1. Title 2. Content 3. Date The pages all have the same basic HTML format. There are 1500+ files. I need someone to take all the files, clean them up (remove HTML tags), and provide...

View Job

Pitch Deck March 31

Hi, my name is Dave Peak, and I’m the Founder of EasyBee AI (link removed). At EasyBee, we’re pioneering the future of AI-driven business automation. Think of our AI agents as your business’s own team of intelligent digital assistants

View Job

Data Visualization Expert for Client-Specific Reports in Google Looker (Preferred) or Tableau

We are a consultancy specializing in benchmarking surveys. Each year, we conduct surveys via Excel, gathering 20-30 responses per survey. To date, we have conducted six surveys and are currently running our seventh. Our data pipeline involves extracting survey responses...

View Job