Data Analyst

Requirements

• High level of proficiency with Excel - advanced capabilities including VLOOKUP, Macros and dynamic formula writing
• Ability to work with and convert various file types including txt, xml, xlsx, csv, etc.
• Typing speed at least 60 WPM
• Excellent written and verbal communication skills

Duties

• Analyze and scrub incoming data files containing consumer information to identify potential errors and ensure all required/expected data elements are present
• Multiply and convert data files to ensure they are in proper format for loading
• Load data files into ARM software
• Verify and confirm files have been loaded correctly and no errors exist
• Collaborate as needed with senior management to plan and execute how new clients' data files will be manipulated and loaded
• Collaborate as needed with programmers as needed to facilitate design and testing of custom programs used for loading data files
• Identify and suggest ways file manipulation and loading can be enhanced or completed more efficiently

Compensation

$18.00 - $23.00 per hour