What are the responsibilities and job description for the Data Analyst / Excel Specialist position at NATIONAL CAPITALS SETTLEMENTS CONTRACTORS LLC?
We are looking for a sharp, detail-oriented Data Analyst / Excel Specialist to join our team. This role is ideal for someone who is very strong with spreadsheets, data cleanup, organization, reporting, and finding patterns in large amounts of business data.
The right person must be highly accurate, fast with Excel or Google Sheets, and comfortable working with CSV files, formulas, filters, data matching, and reporting.
Responsibilities:
Clean, organize, and format large spreadsheets
Work with Excel and Google Sheets daily
Remove duplicates and fix messy data
Match business names, phone numbers, and owner information across different files
Create clean CSV files for uploads
Use formulas, filters, pivot tables, VLOOKUP/XLOOKUP, and other spreadsheet tools
Review data for errors and inconsistencies
Help prepare reports for management and sales teams
Keep information organized and easy to understand
Requirements:
Strong Excel and Google Sheets skills
Experience working with large spreadsheets and CSV files
Very detail-oriented and organized
Fast and accurate with data entry and data cleanup
Comfortable using formulas such as VLOOKUP, XLOOKUP, IF statements, filters, and pivot tables
Able to work independently and meet deadlines
Good problem-solving skills
Must be reliable and consistent
Preferred but not required:
Experience with CRM systems
Experience cleaning sales or lead data
Basic knowledge of automation tools or AI tools
Experience with reporting dashboards
Schedule:
Full-time position
Monday to Friday
In-office position
Pay:
Competitive pay based on experience
Pay: $50,000.00 - $72,000.00 per year
Work Location: In person
Salary : $50,000 - $72,000