FOIA Data Analyst

TechOp Solutions International; United States; On-site; USD 70,000 - 95,000; Full time

Job summary

TechOp Solutions International is seeking a FOIA Data Analyst to support DHS. This role combines full-cycle FOIA processing with data analysis and reporting to monitor workload, identify trends, and support program decisions.

The ideal candidate has at least three years of cradle-to-grave FOIA experience and strong Microsoft Excel skills for pivot tables, charts, graphs and trend analysis. U.S. citizenship and ability to obtain a security clearance are required.

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 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 from intake to final response.
• Review records and recommend exemptions and redactions.
• Coordinate with agency personnel to obtain records and track actions.
• Maintain accurate case records and monitor deadlines.
• Collect, organize, validate, and analyze FOIA data.
• Use Excel to build pivot tables, charts, and recurring reports.
• Identify trends in request volume, aging, backlog, and productivity.
• Review data for missing information and inconsistencies.
• Prepare summaries and presentations for leadership.
• Support data requests and improve tracking and reporting processes.
• Safeguard sensitive information and maintain documentation.

Skills

Cradle-to-grave FOIA

Microsoft Excel (pivot tables, charts,

Data analysis & reporting

Attention to detail

Tools

FOIA case management software

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.