Comprehensive Data Cleansing and Spreadsheet Optimization for Global Marketing Analytics - 75 Hours Estimated

We require a meticulous and detail-oriented individual to cleanse, standardize, and optimize our extensive marketing data spreadsheets. The project involves identifying and correcting inconsistencies in customer demographic information across various platforms (CRM, email marketing, social media). We need you to standardize date formats, remove duplicate entries, validate contact information, and ensure data accuracy. Additionally, the successful candidate will be responsible for restructuring existing spreadsheets to enhance readability, improve efficiency in data retrieval and analysis, and create formulas/macros for automated calculations. Experience with VLOOKUPs, pivot tables, conditional formatting, and data validation is essential. Excellent organizational skills, attention to detail, and the ability to work independently are crucial for success. The final deliverable will be a series of cleaned and optimized spreadsheets ready to be used for marketing analytics reporting. A final presentation outlining the cleansing process and enhancements made is also required.