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

Financial Command Center Development using Excel/Google Sheets

I’m looking for a U.S.-based freelancer to help me build a personal and business financial command center using either Google Sheets, Excel, or Apple Numbers — whichever platform is most effective and efficient. This is not just about tracking — I need a dynamic system ...

View Job

PCR Educator Freelance Data Entry/Migration

We're in need of a person to help us migrate softwares: Mindbody and PCR Educator. We have a Smartsheet prepared with rows of tasks. Our goal is to complete these as soon as possible, and we'd like to maintain close communication as the progress moves along for these ta...

View Job

Convert Excel Warehouse Ledger into a Database with Simple Front-End

Description: We are looking for a skilled developer to convert our warehouse ledger from an Excel spreadsheet into a structured database with a simple, user-friendly front-end interface. The goal is to improve tracking, searching, and updating of pallet inventory effici...

View Job