Federal IT Capital Planning Analyst

QinetiQ US (formerly Avantus Federal); Washington (District of Columbia); Hybrid; USD 98,000 - 110,000; Full time

Job summary

QinetiQ US is seeking a Functional/Financial Analyst to support FHWA CPIC, IT Spend Plan, and OITS initiatives in a highly visible federal program.

You will help FHWA manage its IT portfolio, prepare required OMB and DOT investment reporting, and guide FHWA offices through the IT procurement approval process. This role is hybrid with potential on-site work at DOT HQ in Washington, DC.

Qualifications

• Bachelor's degree.
• Minimum of 4 years of experience in federal IT CPIC, IT budget formulation or execution, or IT portfolio management.
• Experience preparing OMB IT portfolio or investment reporting (e.g., Federal IT Dashboard, AITPS/AITPSD, or OMB Circular A-11 Section 55 data).
• Experience collecting, reconciling, and validating financial or portfolio data from multiple stakeholders.
• Advanced proficiency in Microsoft Excel or Google Sheets, including lookups, pivot tables, and data validation.
• Ability to obtain and maintain a DOT Public Trust.
• This is a hybrid position with potential regular on-site presence at U.S. DOT Headquarters in Washington, DC.

Responsibilities

• Support the management and execution of all phases of FHWA's CPIC program, including Investment Review Board (IRB) processes.
• Maintain the FHWA IT Spend Plan: fill data gaps, map line items to TBM cost pools and towers, reconcile FHWA and Department versions, and manage change requests.
• Prepare, review, and track Interim Procurement Requests (IPRs) with FHWA program offices and the DOT OCIO IT Spend Plan approval team, and communicate decisions to requesting offices.
• Plan and run Department and OMB data calls, such as IT Spend Plan updates, software inventory, Budget Data Requests (including cybersecurity), and annual investment reporting. Consolidate and validate office responses before submission.
• Prepare and submit Monthly IT Dashboard (MITDB) updates in DOT's CPIC tool (CIMS) for major IT investments, including risks, operational performance metrics, and project data.
• Support annual OMB IT portfolio submissions, including the Agency IT Portfolio Summary (AITPS) and Agency IT Portfolio Summary Details (AITPSD), and major and non-major investment reporting.
• Maintain office-level IT Spend Plan workbooks and hold recurring check-ins with FHWA program offices.
• Support integration of investment planning with FHWA strategic planning, enterprise architecture, and budgeting, including IT budget submissions requested by the FHWA Chief Financial Officer.
• Prepare materials, analysis, and ad hoc reports for the Investment Review Board, Architecture Review Board, and FHWA leadership.
• Provide investment management analysis, including risk assessments, earned value management, operational analysis, and cost savings and cost avoidance reporting.
• Develop and maintain CPIC standard operating procedures and desk guides.
• Monitor the FHWA CPIC mailbox, respond to stakeholder questions, and support stakeholder outreach, education, and training.
• Recommend improvements to CPIC processes, data quality, and stakeholder communications.

Skills

Excel proficiency

Communication skills

Public Trust eligibility

Education

Bachelor's degree

Tools

Google Sheets

CIMS portfolio tool

Job description

QinetiQ US is seeking a Functional/Financial Analyst to support FHWA CPIC, IT Spend Plan, and OITS initiatives in a highly visible federal program.

You will help FHWA manage its IT portfolio, prepare required OMB and DOT investment reporting, and guide FHWA offices through the IT procurement approval process. This role is hybrid with potential on-site work at DOT HQ in Washington, DC.