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 field.
  • 7+ years of experience in U.S. military operations and/or DoW processes.
  • 5+ years of experience managing complex datasets with DoW stakeholders.
  • Experience supporting analytic teams in force structure or readiness assessments.
  • Proficiency in SQL for database management and querying.
  • Familiarity with data analysis tools such as Python, R, or Tableau.
  • Active TOP SECRET clearance with SCI eligibility required.

Responsibilities

  • Extract and verify data on U.S. military force structure weekly.
  • Develop and enhance at least five integrated databases for military data.
  • Collaborate with at least 15 DoW data sources for accurate data acquisition.
  • Provide expertise to support 10 yearly strategic analyses and studies.
  • Automate data transformation processes to enhance reporting efficiency.
  • Document data processes quarterly to ensure compliance and quality.
  • Collect and analyze customer feedback for service improvement.

Benefits

  • Medical, Dental, Vision benefits with significant employer contribution.
  • Flexible work environment to promote work/life balance.
  • 401K plan with company match to support retirement saving.
  • Professional development and tuition reimbursement program available.
  • Observance of all federal holidays for time off.
  • Generous PTO to promote time for personal and family needs.
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

  • Model Based Systems Engineer
    $130K — $150K + paid health insurance & dependents, paid education assistance, *
    Kitty Hawk Technologies
    King George, VA 22485 (King George County)
  • Spirit Aerosystems
    Associate Tool Engineering Technician
    $67K — $103K *
    Spirit Aerosystems
    Wichita, KS 67212 (Sedgwick County)
  • Spirit Aerosystems
    AI Product Delivery Lead
    $114K — $176K *
    Spirit Aerosystems
    Wichita, KS 67212 (Sedgwick County)
  • COMSEC Manager
    $90K — $120K *
    SMS Data Products Group, Inc.
    Albuquerque, NM 87121 (Bernalillo County)
  • Soft Tech Consulting
    DevOps Engineer
    $90K — $130K *
    Soft Tech Consulting
    Washington, DC 20011 (District Of Columbia County)

Find similar Functional Area Analyst III jobs: