FOIA Data Analyst

• Process FOIA requests throughout the full lifecycle, from intake and acknowledgment through records searches, review, redaction, and preparation of final responses for government approval.
• Review responsive records and recommend applicable FOIA exemptions and redactions.
• Coordinate with agency personnel to obtain records, resolve questions, and track outstanding actions.
• Maintain accurate case records and monitor processing deadlines.
• Collect, organize, validate, and analyze FOIA case and workload data.
• Use Microsoft Excel to build and maintain pivot tables, charts, graphs, and recurring reports.
• Identify trends in request volume, case aging, backlog, processing times, and productivity.
• Review data for missing information, inconsistencies, and errors.
• Prepare summaries and presentations that clearly communicate findings to program leadership.
• Support data requests and recommend improvements to tracking and reporting processes.
• Safeguard sensitive information and maintain organized documentation.

The ideal candidate will have at least three years of cradle-to-grave FOIA experience and strong Microsoft Excel skills, including pivot tables, charts, graphs, and trend analysis., * At least three years of cradle-to-grave federal FOIA processing experience.

• Strong proficiency in Microsoft Excel, including pivot tables, charts, graphs, and trend analysis.
• Experience applying FOIA exemptions, reviewing records, and preparing redactions and response packages.
• Ability to organize and analyze data and translate findings into clear reports.
• Strong attention to detail and ability to identify and resolve data discrepancies.
• Strong written and verbal communication skills.
• Ability to manage multiple assignments and meet deadlines.
• U.S. citizenship.
• Ability to obtain and maintain the required security clearance., + Experience supporting DHS or a DHS component.
• Experience analyzing FOIA workloads, backlogs, and processing performance.
• Experience using FOIA case management and electronic redaction tools.