IT Portfolio / Data Analyst

Apex Consulting Solutions, LLC.; Washington (District of Columbia); On-site; USD 90,000 - 130,000; Full time

Job summary

Apex Consulting Solutions, LLC seeks an experienced IT Portfolio/Data Analyst to support federal clients with portfolio management, CPIC, and executive decision support. You will analyze investments, programs, and systems to inform strategic planning and governance.

The role requires strong analytical, research, writing, and communication skills to translate complex technical data into clear materials for government decision-makers, while collaborating with government stakeholders and

Qualifications

• Bachelor's degree required or equivalent professional experience in IT, information systems, business, public administration, or computer science.
• Minimum 5 years of professional experience in IT portfolio management, strategic planning, business analysis, program analysis, or related work, preferably with federal clients.
• Experience analyzing IT investments, programs, systems, applications, services, and portfolio performance to support decision-making.
• Familiarity with IT planning, CPIC, OMB guidance and reporting.
• Strong Excel and PowerPoint skills with excellent written and verbal communication.

Responsibilities

• Support development and maintenance of IT portfolio strategies, plans, roadmaps, and updates.
• Analyze IT investments, programs, applications, systems, and services for alignment with priorities.
• Conduct current-state and target-state assessments to identify gaps and risks.
• Lead CPIC activities including reporting, investment analysis, and business case support.
• Create executive briefs, reports, and data-call responses for government leadership.
• Collaborate with government stakeholders, offices, technical teams, and contractors to translate complex data into actionable insights.

Skills

Excel

PowerPoint

Communication

Independent work

Stakeholder engagement

Education

Bachelor's degree in Information Technology / Information Systems / Business / Public Administration / Computer Science

Tools

Power BI

Tableau

Power Apps

Power Automate

Job description

Apex Consulting Solutions is seeking an experienced IT Portfolio/Data Analyst to support federal clients with IT portfolio management, strategic planning, investment analysis, Capital Planning and Investment Control (CPIC), and executive decision support.

The successful candidate will analyze IT investments, programs, systems, and initiatives; assess portfolio performance and priorities; support planning and governance activities; and develop clear, executive-level materials for Government decision-makers. The position requires strong analytical, research, writing, and communication skills, as well as the ability to work with both technical and business stakeholders.

Key Responsibilities

• Support the development and maintenance of IT portfolio strategies, plans, roadmaps, and periodic portfolio updates.
• Analyze IT investments, programs, applications, systems, and services to assess alignment with organizational priorities and strategic objectives.
• Conduct current-state and target-state assessments to identify portfolio gaps, risks, dependencies, opportunities, and resource considerations.
• Lead and support Capital Planning and Investment Control (CPIC) activities within iMatrix, including OMB requirements and reporting, investment analysis, portfolio reviews, business case development, and supporting documentation.
• Analyze portfolio data and develop trends, performance metrics, dashboards, and decision-support materials for Government stakeholders.
• Research and analyze federal IT policies, regulations, OMB guidance, and oversight requirements and assess their impact on IT programs and investments.
• Identify and track portfolio risks, dependencies, assumptions, issues, milestones, and performance indicators, and support the development of mitigation strategies.
• Support IT portfolio reviews, working groups, stakeholder engagements, and executive-level planning and governance activities.
• Develop executive briefings, presentations, reports, decision papers, data-call responses, and other analytical products for senior Government leadership.
• Collaborate with Government stakeholders, program offices, technical teams, and contractors to collect, validate, analyze, and translate complex technical and portfolio information into clear, concise, and actionable insights.

Key Requirements

• Must have a minimum Secret clearance or ability to obtain a Secret clearance.
• Bachelor’s degree in Information Technology, Information Systems, Business, Public Administration, Computer Science, or a related field. Equivalent relevant professional experience may be considered in lieu of a degree.
• Minimum 5 years of professional experience in IT portfolio management, strategic planning, business analysis, program analysis, management consulting, or a related discipline, preferably supporting federal clients.
• Demonstrated experience supporting IT portfolio planning, investment analysis, strategic initiatives, or enterprise technology programs.
• Experience analyzing IT investments, programs, systems, applications, services, and portfolio performance to support organizational priorities and decision-making.
• Demonstrated ability to identify and assess risks, dependencies, gaps, trends, opportunities, and performance considerations across programs or portfolios.
• Experience developing executive-level briefings, presentations, reports, decision papers, analytical products, and other written deliverables for senior stakeholders.
• Familiarity with federal IT planning, CPIC, IT investment management, OMB guidance and reporting.
• Strong Microsoft Excel and PowerPoint skills, along with excellent written and verbal communication skills and the ability to manage multiple priorities while working independently and collaboratively with Government and contractor teams.

Preferred Qualifications

• Experience supporting the U.S. Federal agencies.
• Experience with IT portfolio management, CPIC, Capital Planning, investment analysis, or enterprise IT planning.
• Experience developing technology strategies, roadmaps, portfolio assessments, or investment recommendations.
• Experience with Power BI, Tableau, Power Apps, Power Automate, or similar data visualization and automation tools.
• Experience supporting a PMO, enterprise portfolio management office, governance organization, shared service organization, or newly established federal office.
• Experience working with senior Government executives and preparing materials for executive-level briefings and decision-making.