Functional Area Analyst III

KSA Integration

$90K — $120K *
Aerospace & Defense
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • Bachelor's degree in operations research, political/military science, computer science, information systems, or related fields required.
  • 7+ years of experience in U.S. military operations across various domains.
  • 5+ years collecting and managing complex datasets with DoW stakeholders.
  • Experience supporting analytic or operations research teams in force structure planning and capability assessments.
  • Proficient in SQL for database management and querying.

Responsibilities

  • Extract, transform, load, and verify U.S. military data weekly across multiple domains.
  • Develop and maintain integrated databases for current and future military data.
  • Collaborate with DoW data sources to acquire essential data and document constraints.
  • Provide U.S. military subject matter expertise to support strategic studies and analyses.
  • Document data transformation processes and implement business rules quarterly.

Benefits

  • Medical, Dental, Vision with substantial premium support for employees and dependents.
  • Flexible work environment promoting work/life balance.
  • 401K plan with company match.
  • Tuition reimbursement and professional development programs available.
  • Observed federal holidays and generous PTO.
Full Job Description
Position Overview: The Functional Area Analyst III supports the Joint Data Support (JDS) Division within OSW-CAPE and plays a central role in building and maintaining the authoritative databases of current and future U.S. military force structure, capabilities, and deployment data that underpin Department-wide strategic analysis and senior leader decision support. Operating with significant independence, this mid-to-senior analyst leads day-to-day data activities, mentors staff, and serves as a primary point of contact with DoW data stakeholders.

This Position is Contingent Upon Award

Benefits:
  • Medical, Dental, Vision (82% of employee's premium paid by company, 25% towards dependents)
  • HSA / FSA Medical Plans
  • PTO
  • Flexible Work Environment and Encourage Work/Life Balance
  • 401K with Company Match
  • Observes all federal holidays
  • Professional Development/Tuition Reimbursement Program
  • Annual Career Development Process


Job Type: Full-time/Exempt

Location: Pentagon/Limited Teleworking available.

Anticipated Start Date: Summer 2026

Position Responsibilities:

Data Collection & Database Management
  • Extract, transform, load, and verify U.S. current and future force structure data across all domains (Air, Land, Sea, Space, Cyber, and SOF) at UNCLASSIFIED, SECRET, and TOP SECRET levels on a weekly basis.
  • Develop, maintain, and enhance at least five integrated databases containing current and future-year U.S. military data to support priority analyses and future force planning.
  • Maintain at least two current and historical operations databases covering force structure, deployment, COCOM demand and employment, and DoW sourcing.
  • Maintain at least two databases covering the capabilities and characteristics of U.S. systems and platforms.
  • Develop and maintain databases covering equipment age and performance data for Army, Marine Corps, Navy, Air Force, and SOF ground vehicles, ships, aircraft, and space assets.

Stakeholder Collaboration & Data Acquisition
  • Collaborate with at least 15 DoW data sources and key stakeholders to acquire force structure, deployment, logistics, and capability data; document data quality constraints, classification, format, and pedigree.
  • Submit quarterly data requests for access to DoW authoritative data sources and develop automated tools and processes to expedite acquisition.
  • Assess and report all data discrepancies to data sources and key stakeholders quarterly for resolution.

Analytic Support & Study Support
  • Provide data and U.S. military subject matter expertise to support at least 10 yearly studies and analyses, including Department-wide scenarios, strategic guidance, and national security strategy.
  • Create, transform, and tailor at least five datasets per quarter to support studies, analyses, models, simulations, and other analytic methods including machine learning, AI, and statistical analysis.
  • Provide subject matter expertise on forces and capability readiness analysis; assist DoW analysts in acquiring data from key stakeholders.
  • Support at least 10 technical studies, analyses, or rapid assessments annually.
  • Complete at least 10 yearly additional support tasks; timelines mutually agreed upon with the Government.

Data Quality, Documentation & Automation
  • Document the data review, analysis, and transformation process quarterly in accordance with study requirements.
  • Identify and implement business rules governing input methodologies, transformation requirements, limitations, and caveats; review and update quarterly.
  • Develop and maintain a systemic and repeatable transformation routine for all JDS data products (at least five per year); automate transformations using advanced data tools and techniques.
  • Update data products quarterly and make new or updated products available to users via collaboration websites within 48 hours of finalization.
  • Fulfill all data requests within 48 hours of receipt unless an alternate timeline is negotiated.

Client Services
  • Collect, compile, and analyze customer feedback monthly to improve product and service quality.
  • Monitor internal data signals and customer feedback weekly; implement improvements and measure effectiveness.
  • Contribute to at least one product or service improvement strategy per year in coordination with JDS product and support teams.


Requirements

  • Bachelor's degree required. Relevant fields include operations research, political/military science, computer science, information systems, or related disciplines.
  • Minimum of 7 years of experience in at least two of the following:
    • U.S. military operations, munitions, readiness, and deployment across air/space, ground, SOF, and maritime domains
    • DoW Planning, Programming, Budgeting, and Execution (PPBE) process
    • Force and capability development within JCIDS or equivalent DoW frameworks
  • Minimum of 5 years of experience collecting, maintaining, and refining complex datasets (e.g., force structure modeling, operational readiness, global logistics data) with DoW stakeholders.
  • Demonstrated experience supporting DoW analytic and/or operations research teams focused on force structure planning, capability gap assessment, or force posture analysis.
  • Proficiency in SQL for managing and querying logistics, force inventory, and personnel readiness databases.
  • Experience with data analysis tools, including at a minimum one of: Python, R, Tableau, or similar platforms.
  • Familiarity with DoW data environments, classification handling, and data governance practices.
  • Experience developing or contributing to automated data transformation pipelines is preferred.
  • Active TOP SECRET clearance with SCI eligibility required prior to start.

Similar Jobs

More Jobs at KSA Integration

  • Knowledge Manager
    $90K — $120K *
    Washington, VA 22747 (Rappahannock County)
    Education, Government & Non-Profit
    In-Person
  • Knowledge Manager
    $80K — $110K *
    Alexandria, VA 22304 (Alexandria City County)
    Education, Government & Non-Profit
    In-Person
  • Functional Area Analyst III
    $90K — $120K *
    Washington, DC 20011 (District Of Columbia County)
    Aerospace & Defense
    In-Person
  • Functional Area Analyst III
    $90K — $120K *
    Arlington, VA 22204 (Arlington County)
    Aerospace & Defense
    In-Person
  • Functional Area Analyst II
    $75K — $95K *
    Washington, DC 20011 (District Of Columbia County)
    Aerospace & Defense
    In-Person

More Aerospace & Defense Jobs

Find similar Functional Area Analyst III jobs: