Q2 Impact

Compensation

Full Description

Security Assistance Data Analyst About Q2IMPACT Q2IMPACT is a data-first organization known for delivering innovative, customized solutions in monitoring, evaluation, learning, digital transformation, and performance management for government, security, and development partners. Drawing on deep expertise in advanced analytics, digital platforms, and AI, we help clients solve their most complex data, knowledge management, and operational challenges. Our collaborative culture values curiosity, partnership, and technical excellence. Position Summary: The Security Assistance Data Analyst will serve as core member of Q2IMPACT’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 The Security Assistance Data Analyst shall: • 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. Qualifications: • 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. Preferred Experience: • 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. Required Security Clearance: U.S. Citizenship. Active Secret-level clearance. A Secret security clearance is required for this position; however, the Data Analyst may begin work with an interim Secret security clearance. Location: Washington, DC Benefits of Joining Q2IMPACT: • A dynamic group of professionals with diverse backgrounds and expertise, committed to delivering high-quality results and making a meaningful impact in communities around the world. • An opportunity to lead and shape a growing firm that has a solid reputation in the industry and is poised for further expansion. • A chance to work across development, diplomacy, and defense sectors, with a broad portfolio of projects and clients. • A supportive and inclusive culture that values innovation, excellence, and collaboration. • Competitive salary and benefits package, including health, dental, and vision insurance, and paid time off. Join our team at Q2IMPACT, where your talents, expertise, and passion can make a difference. Apply today and become part of a dynamic and growing organization. WORKING CONDITIONS & REQUIRED EQUIPMENT The incumbent in these positions will work in a professional office environment and will utilize the following equipment when working • Computer (laptop or desktop) • Printer/Photocopier/Scanner/Fax • Telephone • Other (Specify if any) The physical demands and work environment that have been described is representative of those an employee encounters while performing the essential functions of these positions. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions in accordance with the Americans with Disabilities Act. These position descriptions provide an overview of the major functions and requirements of these roles. This document is not intended to be an exhaustive list encompassing every duty and requirement of the positions; the Employee’s Manager may assign other duties as related or as otherwise deemed appropriate and necessary within the general scope, without the need for additional compensation.