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.

Price: $500.0

Data Engineering Microsoft Excel Data Analysis Data Mining

 

GAS (Give A Sh*t) Call Specialist

Languages: English & Spanish required, Creole preferred Hours: M–F, 9 AM – 6 PM EST Pay: Competitive + room to grow At Tollinchi Law, we don’t just handle personal injury cases—we build real relationships with our clients. We created our GAS Calls because we give a sht*...

View Job
Create a short video trailer for my book

I have a limited budget. I would like a 30-60 second video made about my novel. My plan is to use this for TikTok and Facebook. I would like a good quality and some examples of your past work. I realize the budget is not big, but easy money for an experienced person. Yo...

View Job
Research and Compile a List of YouTube Influencers

We are looking for a detail-oriented freelancer to research and compile a list of 150 YouTube influencers across various niches. The ideal candidate should have strong research skills, be familiar with social media platforms, and possess the ability to identify influenc...

View Job