Data Analyst

Employer
AboutWeb
Location
Washington D.C.
Posted
Jun 25, 2018
Closes
Aug 02, 2018
Function
Analyst
Hours
Full Time
We are looking for a Data Analyst who possess the proven skills listed below to perform the comparative analysis on vendor client lists.

Excel Tool Set
- VLOOKUP - cross link to multi spreadsheets to aggregate/merge/incorporate Bright customer data fields into Vendor provided client data to conduct comparative/gap Analysis.
- Concatenate - Vendor client data and Bright customer data fields to conduct comparative/gap analysis
- Sort - Multi level sort by fields and cell colors
- Find and Replace - To standardize incoming Vendor client URLs
- Expose Duplicates
- Remove Duplicates
- Pivot Tables - For analysis and statistical reporting
- Strong interpersonal and problem solving skills
- Very detailed oriented.

In addition to the excel tools above, strong analytical skills are required to conduct manual reviews and inspections of anomalies in data received from Vendors to ensure accuracy and completeness of the invoicing lists.

#AW

Similar jobs