[Remote] Administrative Assistant

Note: The job is a remote job and is open to candidates in USA. RPStaffing is conducting an immediate search for a temporary Administrative Associate with a major Washington, DC area nonprofit. This fully remote role involves verifying submitted data, preparing data for aggregation, and finalizing reports on the aggregated data.

Responsibilities

• Compare data on Excel file to data submitted on a PDF and note any differences in the Excel file (Oct)
• Use a VLOOKUP in Excel to compare list of ~700 respondents required to report data to the list of respondents received and note variances (Sept/Oct)
• Send Login/Passwords to accredited organizations who need to submit data, as needed via email (Sept/Oct)
• Aggregate Reports (Nov/Dec)
• Map data file to be able to complete a mail merge in MS Word and then convert to PDF
• Ensure formatting is correct and make any edits in PDF
• Split PDF into 700+ individual reports
• Rename 700+ files according to provided syntax

Skills

• Excel (VLOOKUP, Sorting, Check for Duplicate, able to navigate Pivot Table)
• PDF/ MS Word (mail merge from a data file, combining documents, editing and formatting, and splitting large documents into smaller client specific documents)
• Detail Oriented to ensure confidentiality of client data is not sent to other organizations
• Communication (frequent updates on progress)
• Strong organizational and time management skills with demonstrated flexibility and the ability to manage multiple tasks and issues of varying complexity, while managing priorities and meeting deadlines
• Strong written and verbal communication skills with the ability to generate original correspondence and reports and convey ideas clearly and effectively

Company Overview