FOIA Data Analyst

TechOp Solutions International; Washington (District of Columbia); On-site; USD 70,000 - 100,000; Full time

Job summary

TechOp Solutions International in Washington, DC is seeking a FOIA Data Analyst to support DHS by handling cradle-to-grave FOIA processing, data analysis, and reporting to monitor workload and trends. The role requires at least three years of FOIA experience and strong Excel skills, including pivot tables, charts, and trend analysis, with U.S.

citizenship and ability to obtain security clearance. You will prepare concise summaries for leadership and coordinate with agency personnel to track

Qualifications

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

Responsibilities

• Process FOIA requests through the full lifecycle from intake to final responses for government approval.
• Review records and recommend FOIA exemptions and redactions.
• Coordinate with agency personnel to obtain records and track actions.
• Maintain accurate case records and monitor processing deadlines.
• Collect, organize, validate, and analyze FOIA workload data.
• Use Excel to build pivot tables, charts, graphs, and recurring reports.
• Identify trends in request volume, backlog, and processing times.
• Review data for missing information, inconsistencies, and errors.
• Prepare summaries and presentations for program leadership.
• Support data requests and suggest improvements to tracking and reporting processes.
• Safeguard sensitive information and maintain documentation.

Skills

FOIA processing

Excel

Data analysis

Report writing

U.S. citizenship

Security clearance

Attention to detail

Communication

Tools

FOIA case management tools

Electronic redaction tools

Job description

Overview

TechOp Solutions International is seeking a FOIA Data Analyst to support the Department of Homeland Security (DHS). This position combines full-cycle Freedom of Information Act (FOIA) processing with data analysis and reporting to help monitor workload, identify trends, and support program decisions.

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.

Responsibilities

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

Qualifications

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

Preferred Qualifications

• Experience supporting DHS or a DHS component.
• Experience analyzing FOIA workloads, backlogs, and processing performance.
• Experience using FOIA case management and electronic redaction tools.