Mid Level Data Analyst

Redhorsecorp; Washington (District of Columbia); On-site; USD 120,000 - 180,000; Full time

Job summary

Redhorse Corporation seeks an Executive Data Analyst to provide staff-level support to FBI NSB and senior leaders. You will extract data from enterprise databases, create Power BI dashboards, and draft briefing papers, policy updates, and resource justifications for executive review.

You will collaborate across FBI divisions, synthesize information, and present actionable insights on program performance, budgets, and readiness.

Qualifications

• Executive Staff-level experience with federal agencies or equivalent.
• Experience coordinating complex programs under tight deadlines.
• Strong data visualization and briefing material preparation skills.

Responsibilities

• Author executive briefing papers, memos, and status reports.
• Draft policy updates, MOUs, RFIs, and executive responses.
• Coordinate with FBI divisions to gather information and track deliverables.
• Brief senior executives on program status and resource constraints.
• Develop advanced Power BI reports with clear visuals for executives.

Skills

Executive briefing

Data analysis

Stakeholder management

Policy evaluation

Research

Education

Bachelor’s degree in Economics/Analytics/Business/Finance

MBA or Master’s degree

Tools

Microsoft Power BI

MS Excel

PowerPoint

Word

SharePoint

Job description

About the Organization

Now is a great time to join Redhorse Corporation. We are a solution-driven company delivering data insights and technology solutions to customers with missions critical to U.S. national interests. We’re looking for thoughtful, skilled professionals who thrive as trusted partners building technology-agnostic solutions and want to apply their talents supporting customers with difficult and important mission sets.

About the Role

Redhorse transforms the way government uses data and technology. To support this mission, we are seeking an executive Data Analyst to provide Executive Staff-level support to the FBI National Security Branch (NSB) and senior operational leadership.

In this role, you will serve as a key analyst conducting rigorous quantitative and qualitative evaluations of high-impact national security programs. You will bridge operational performance with strategic resource decisions—extracting data from enterprise databases, building insightful Power BI visualizations, and authoring executive briefing papers, policy drafts, and resource justifications. Your analytical rigor will directly advise FBI executive leadership on program resourcing, operational readiness, and strategic mission execution.

• Author executive-level briefing papers, white papers, and memos that succinctly explain complex program data, resource allocations, operational issues, and strategic recommendations.
• Research and draft Branch-level policy updates, technical and programmatic status papers, classification evaluations, Memorandums of Understanding (MOUs), and formal responses to RFIs and taskers.
• Coordinate and partner across internal and external FBI divisions to gather information, synthesize submissions, and track deliverables for executive leadership.
• Brief senior executive management on program status, operational milestones, resource constraints, and courses of action.
• Apply quantitative and qualitative methodologies to evaluate program performance, discover trends, and formulate data-backed solutions.
• Query and extract operational and programmatic data across disparate enterprise databases and record systems.
• Manipulate complex datasets in Excel using advanced formulas and pivot tables, and develop interactive Power BI reports featuring clear tables and demonstrative graphics for executive briefing materials.
• Research prior and current federal practices, statutory guidance, policies, and regulations to inform comparative analysis and decision‑making.
• Manage and maintain the Branch tasking system, tracking incoming taskers and logging approved executive submissions.
• Attend high‑level stakeholder meetings, capturing comprehensive meeting minutes, action items, and executive follow‑up items.
• 5+ years of expert‑level experience in the federal government (intelligence community, defense, or law enforcement) leading and coordinating complex projects under aggressive deadlines.
• 3+ years of experience successfully working in an Executive Staff-level environment advising senior leadership.
• 3+ years of experience researching, analyzing, and authoring policy drafts, programmatic status papers, classification reviews, MOUs, and analytical products for executive or interagency audiences.
• 3+ years of experience writing and producing data‑and‑resource‑focused summary reports, briefs, and talking points linking operational performance to fiscal allocations.
• 3+ years of experience aligning operational outcomes with fiscal goals and federal budgetary principles.
• 3+ years of experience using MS Excel (spreadsheets and pivot tables), Microsoft Power BI, PowerPoint, Word, and SharePoint lists/workflows as analytical and briefing tools.
• 1+ year of direct experience writing formal reports and delivering oral briefing materials to executive leaders.
• Submission of a relevant professional writing sample demonstrating executive‑level analysis is required.
• Active Top Secret (TS) security clearance with SCI eligibility and willingness to undergo an FBI suitability determination/polygraph.

We encourage all candidates who meet the basic requirements to apply, even if you do not have any of the following experience:

• Bachelor’s, MBA, or Master’s degree from an accredited college or university in Economics, Data Analytics, Business, Finance, or a related analytical or quantitative discipline.
• 5 years of experience utilizing Microsoft Excel as an advanced quantitative and analytical modeling tool.
• 5 years of experience with federal Planning, Programming, Budgeting, and Execution (PPBE) processes, resource allocation, and program evaluation methodologies.
• 5 years of direct experience writing resource justifications, congressional budget justifications (CBJ/CJ), and formal responses for Congressional, OMB, DOJ, and ODNI audiences.

The salary range provided for this position represents the anticipated base salary for successful candidates. Actual compensation will be determined based on a variety of factors, including relevant experience, education, certifications, skills, security clearance level, geographic location, market conditions, and internal equity. In addition to base salary, eligible employees may participate in Redhorse's comprehensive benefits programs and may be eligible for performance‑based or other incentive compensation, where applicable.

Redhorse Corporation is an equal opportunity employer. All qualified applicants will receive consideration for employment and will not be discriminated against on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, veteran status, disability, or any other protected class.

If you are a qualified individual with a disability or a disabled veteran, you may request a reasonable accommodation if you are unable or limited in your ability to access job openings or apply for a job on this site as a result of your disability. You can request reasonable accommodations by contacting Talent Acquisition [e-mail]

Redhorse Corporation shall, in its discretion, modify or adjust the position to meet Redhorse’s changing needs.This job description is not a contract and may be adjusted as deemed appropriate in Redhorse’s sole discretion.