Data Analyst

Remex, Inc.; Montgomery Township (NJ); On-site; USD 28,000 - 41,000; Part time

Job summary

Remex, Inc. in Skillman, NJ is seeking a part-time Data Analyst to manage the transfer of client data files into our enterprise application software. The role is on-site and requires 15-20 hours per week between 8am and 5pm.

You will analyze and scrub incoming data, convert and load files, verify successful loads, and collaborate with senior management and programmers to improve data loading processes.

Qualifications

• Advanced Excel skills including VLOOKUP, Macros and dynamic formulas.
• Experience converting txt, xml, xlsx, csv files.
• Typing speed 60 WPM.
• Excellent written and verbal communication skills.

Responsibilities

• Analyze and scrub incoming data files to identify errors and ensure required elements are present.
• Manipulate and convert data files for loading into ARM software.
• Load data files into ARM software.
• Verify and confirm files have been loaded correctly and no errors exist.
• Collaborate with senior management to plan how new clients' data will be manipulated and loaded.
• Collaborate with programmers to design and test data loading programs.
• Identify and suggest ways to enhance data manipulation and loading.

Skills

Advanced Excel (VLOOKUP/Macros)

Typing 60 WPM

Clear written and verbal communication

Tools

File type handling (txt/xml/xlsx/csv)

Job description

Established in 1983, Remex, Inc. is a dynamic accounts receivable management company seeking a part-time Data Analyst to manage the transfer of client data files into our enterprise application software. The person selected for our data analyst position must have the requisite technical and communication skills.

The position will be on-site at our Skillman, NJ office. This position will require approximately 15-20 hours per week between 8am and 5pm, and may fluctuate as business needs dictate.

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
• Manipulate 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