Excel Expert for Data Sorting

We are seeking a detail-oriented Excel Data Specialist to organize and refine scattered and unstructured data into clear, actionable datasets. The successful candidate will be responsible for consolidating multiple spreadsheets, correcting formatting issues, standardizing data formats, and creating master datasets that support accurate reporting and decision-making. This role demands a high level of precision and the ability to manage complex data sets to deliver dependable and efficient data solutions.

Key Responsibilities

- Extract, combine, and merge raw data from various Excel files, CSVs, and other external sources into unified, coherent datasets.
- Identify and eliminate duplicate entries, correct typographical errors, standardize text formats, address missing data, and resolve structural inconsistencies across multiple sheets.
- Transform flat, unformatted lists into well-organized tables with consistent schemas, formulas, and data types.
- Utilize advanced Excel functions such as XLOOKUP, INDEX/MATCH, nested IF statements, TEXTJOIN, and regex/text manipulation formulas to automate data cleaning and transformation processes.
- Develop repeatable workflows using Excel Power Query or VBA/Macros to streamline data imports and routine cleanup tasks.
- Implement data validation rules, dropdown menus, and error-checking mechanisms to prevent future data corruption and maintain data integrity.

Required Qualifications

- Minimum of 2 years of hands-on experience in data cleaning, data preparation, or database maintenance using Microsoft Excel.
- Advanced proficiency in Excel, including Power Query (Get & Transform), advanced lookup functions, array formulas, text manipulation techniques, and Pivot Tables.
- Strong problem-solving skills with the ability to work effectively on unstructured, incomplete, or chaotic datasets and develop logical systems to organize and standardize data.

Additional Information

This is an on-site role located in DHA Phase 7, Karachi. The working schedule is Monday to Saturday, from 10:00 AM to 7:00 PM. Candidates should be prepared to complete a practical test as part of the interview process. The monthly salary is up to Rs. 35,000. Applicants are expected to have at least 3 years of Excel expertise and must be willing to work in person at the specified location.

If you are an Excel expert passionate about data organization and cleanup, and meet the experience requirements, we encourage you to apply for this opportunity.