Security Assistance Data Analyst

Commonwealth Trading Partners

6d•Onsite

About The Position

Position Summary: The Security Assistance Data Analyst will serve as core member of CTP's embedded team within the U.S. Department of State’s Bureau of Political-Military Affairs (PM/SA). The Security Assistance Data Analyst serves as the office’s primary data analyst, responsible for managing, analyzing, and optimizing data and information to support budget tracking and responses to Requests for Information (RFIs) in coordination with program managers and the Defense Security Cooperation Agency (DSCA). This role requires expertise in data management and visualization, leveraging the Microsoft suite of applications to develop workflows, dashboards, and other tools that enhance operational efficiency and decision-making. The Data Analyst will ensure data accuracy, streamline reporting processes, and provide actionable insights to support program objectives. Additionally, the analyst will collaborate with stakeholders to identify data-driven solutions, maintain compliance with relevant policies, and contribute to the continuous improvement of security assistance operations

Requirements

Bachelor’s Degree in international relations, political science, economics, or a related field preferred, or equivalent combination of education and relevant experience.
Proficiency in data analysis and visualization tools, including Microsoft Excel, Lists, Power BI, and other Microsoft suite applications.
At least two (2) years of demonstrated experience developing automated workflows and dashboards to streamline data management and reporting processes.
Experience working with large datasets, ensuring data accuracy, and optimizing information for decision-making.
Ability to translate complex data into actionable insights and communicate findings effectively to diverse audiences.
Strong organizational skills and attention to detail.
Ability to manage multiple ongoing tasks and processes simultaneously.
Strong oral and written communication skills with experience presenting complex information.
Active SECRET security clearance preferred, must have ability to obtain
Candidate must be authorized to work in the United States. No sponsorships provided.

Nice To Haves

Previous experience working within PM/SA.
Knowledge of U.S. government security assistance or security cooperation programs.
At least two (2) years of experience working on budget and fiscal processes for large-scale programs, preferably with the U.S. Department of State or the U.S. Department of War.

Responsibilities

Support PM/SA program officers in the budgeting and execution process of the office's multi-billion-dollar accounts, including general accounting; data entry and validation; reconciliation; and reporting from the data management systems in use.
Liaison with the Defense Security Cooperation Agency (DSCA) and account examiners at the Office of Management and Budget, as directed.
Track the funding approval process for over $6 billion in security assistance programming annually, including the clearance process within State, the U.S. Department of War, and the Office of Management and Budget.
Provide budgetary research, data collection, validation, analysis, modeling and reporting of country program activities for a variety of briefings and products, optimize current data management systems.
Provide timely responses to requests for budgetary and financial data and information pertaining to the funding approval process.
Support program officers to assist with and provide budget formulation and analysis support for all PM/SA programs, and incorporating strategic planning elements as related to the Department’s various and relevant strategy documents, as well as metrics and performance measures in the budget formulation exercise.
Perform analytical, forecasting and interpretive functions for the management and control of budgetary and financial resources, including tracking current and prior year funds for programs supported by the office.
Perform studies and audits on control, allocation and allotment of funds throughout the year, assuring that allocations and allotments are in accordance with pertinent laws, e.g., Appropriations Laws, Foreign Assistance Act, the Arms Export Control Act, and other financial and legislative regulations.
Make recommendations to program officers to improve the effectiveness and efficiency of financial controls, and implement improvements as directed.
Comply with all internal controls and procedures to protect organizational integrity and prevent unauthorized use or misappropriation of all classified and sensitive (but unclassified) material and equipment in assigned areas.