Data Cleansing Specialist

Data Cleaning Job Description

We are looking for a detail-oriented Data Cleaning Associate to review, correct, organize,

and maintain accurate data across spreadsheets, databases, and internal systems. The

ideal candidate should possess strong analytical skills, excellent attention to detail, and
the ability to identify inconsistencies and improve data quality while coordinating data-

related requests from U.S.-based entities and teams.

Key Responsibilities

• Review and clean raw data from multiple sources

• Identify and correct errors, duplicates, and missing information

• Standardize data formats and naming conventions

• Validate and verify data accuracy before updating systems

• Maintain organized records in Excel, Google Sheets, and databases

• Generate reports on data quality and completion status

• Coordinate and process data requests received from U.S.-based entities/clients

• Ensure timely ordering, arrangement, and delivery of data as per U.S. entity

requirements

• Use Excel formulas and automation techniques to improve efficiency and ensure

speedy data cleaning

• Calculate employee salary, pay, and compensation details based on annual salary

and other salary components

• Verify payroll-related calculations for accuracy and consistency

• Ensure confidentiality and security of company data

• Perform regular audits to maintain data integrity

• Manage and organize PDF documents using Adobe Acrobat

Required Skills & Qualifications

• Proficiency in Microsoft Excel and Google Sheets

• Strong knowledge of Excel formulas, functions, filtering, sorting, lookup formulas,

and automation techniques

• Ability to use formulas efficiently to automate repetitive tasks and improve data

cleaning speed

• Good knowledge of salary calculations, payroll structures, annual salary

breakdowns, incentives, deductions, and other compensation components
• Ability to accurately calculate monthly, bi-weekly, or hourly pay based on annual

salary structures

• Experience using Adobe Acrobat for PDF editing, document formatting, file

conversion, OCR, and document management tasks

• Strong attention to detail and accuracy

• Ability to organize and manage data requests efficiently

• Experience handling client or entity-based data requirements

• Basic knowledge of data management and reporting

• Ability to handle large datasets efficiently

• Good communication and organizational skills

• Experience with CRM, ERP, or database systems is an advantage

• Ability to meet deadlines and work independently

Preferred Qualifications

• Previous experience in data entry, payroll processing, or data cleaning

• Knowledge of Power BI, SQL, or AppSheet is a plus

• Familiarity with advanced Excel functions such as VLOOKUP, XLOOKUP, INDEX

MATCH, Pivot Tables, Conditional Formatting, and Data Validation

• Experience working with U.S.-based clients or business entities preferred

Job Type

• Full-time work from Office and may be later moved to Work from Home.

Experience

• 1–3 years preferred

Sample Tools Used

• Microsoft Excel

• Google Sheets

• Adobe Acrobat

• Power BI

• SQL Databases

• AppSheet

Requirements

Data Cleaning/Cleansing, Good communication Skills, Advanced Excel, Document Formatting, File conversion,Power BI/SQL,Candidate from HR Background is preferred