Portfolio Data Analyst

Ampcus Inc

Chesterfield Court House (VA)

Hybrid

USD 85,000 - 110,000

Full time

23 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Ampcus Inc. is seeking a Portfolio Data Analyst in Chesterfield, VA (Hybrid: 2 days per week onsite) to transform IT portfolio and financial data into actionable insights.

You will build Power BI dashboards, analyze multiple data sources, and collaborate with Planview stakeholders to enhance analytics and reporting capabilities for executive decision-making.

Qualifications

  • 5+ years of progressive experience in business analysis, data analysis, or a related field.
  • Experience supporting enterprise IT portfolio or program management.
  • Proficiency in Power BI, including data modeling, DAX, report design, dashboard development, WCAG 2.1 AA accessibility standards.
  • Knowledge of business analysis methodologies and best practices, including requirements gathering, user stories, acceptance criteria, and stakeholder facilitation.
  • Understanding of IT portfolio management concepts, including project lifecycle, investment categorization, financial management, and risk governance.
  • Experience analyzing structured datasets, identifying patterns and anomalies, and developing analytical reports.
  • Ability to translate complex data findings into executive-level insights, reports, and presentations.
  • Strong data visualization skills.
  • Ability to manage multiple analytical workstreams and competing priorities.
  • Excellent written and verbal communication skills.

Responsibilities

  • Build and maintain Power BI dashboards and reports to support portfolio-level decision-making.
  • Integrate multiple data sources to create unified portfolio views.
  • Automate recurring reports and data refreshes.
  • Improve dashboard design based on stakeholder feedback and reporting requirements.
  • Collaborate with Planview product owners and platform administrators to improve portfolio analytics and reporting capabilities.
  • Analyze Planview data quality and identify gaps, inconsistencies, and outdated records.
  • Develop Planview-native reports and views to complement Power BI dashboards.
  • Analyze IT budget submissions, appropriations, and actual spending to identify financial trends and cost anomalies.

Skills

Power BI
Data analysis
Business analysis
Stakeholder facilitation
Planview
AI-assisted analytics
Data modeling

Tools

Planview

Job description

Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team.

Job Title: Portfolio Data Analyst

Location(s): Chesterfield, VA

(Hybrid: 2 days per week onsite)

Job Summary

We are seeking an experienced Portfolio Data Analyst with strong business analysis, data analytics, and enterprise IT portfolio management experience.

The ideal candidate will have experience working with multiple data sources, analyzing complex datasets, identifying trends, and developing interactive data visualizations using Power BI.

This role focuses on transforming IT portfolio, financial, project performance, and governance data into actionable insights that support strategic decision-making. The candidate will work closely with stakeholders to gather requirements, develop dashboards, identify investment trends, and improve portfolio reporting and analytics.

Experience using AI-assisted analysis tools to accelerate insight generation is highly desirable.

Key Responsibilities
Business Requirements and Acceptance Criteria
  • Engage stakeholders to elicit, document, and validate business requirements for analytical initiatives, reporting solutions, and Planview enhancements.
  • Facilitate requirements workshops and working sessions with business and technical stakeholders.
  • Translate stakeholder input into actionable business specifications.
  • Maintain requirements traceability to ensure analytical deliverables align with business objectives.
Portfolio Analysis and Trend Intelligence
  • Analyze information from multiple data sources to identify patterns, trends, redundancies, and optimization opportunities.
  • Conduct cross-functional and cross-agency demand analysis to identify common technology needs and shared service opportunities.
  • Monitor project performance, including schedule variance, cost variance, risks, and milestone trends.
  • Identify systemic issues, recurring risks, and predictive indicators of project performance.
  • Develop forward-looking insights into technology demand, investment gaps, and emerging priorities.
  • Build and maintain Power BI dashboards and reports to support portfolio-level decision-making.
  • Integrate multiple data sources to create unified portfolio views.
  • Automate recurring reports and data refreshes.
  • Improve dashboard design based on stakeholder feedback and reporting requirements.
Planview Analytics
  • Collaborate with Planview product owners and platform administrators to improve portfolio analytics and reporting capabilities.
  • Analyze Planview data quality and identify gaps, inconsistencies, and outdated records.
  • Recommend data models, taxonomies, and field-level standards to support consistent reporting.
  • Develop Planview-native reports and views to complement Power BI dashboards.
Financial and Portfolio Analysis
  • Analyze IT budget submissions, appropriations, and actual spending to identify financial trends, funding gaps, and cost anomalies.
  • Reconcile financial information with portfolio investment records.
  • Identify discrepancies and prepare accurate financial reporting for executive stakeholders.
  • Identify opportunities for shared services, infrastructure improvements, and enterprise procurement.
Risk and Issue Analysis
  • Analyze portfolio data to identify recurring risks, issues, and systemic vulnerabilities.
  • Identify potential concerns involving expired contracts, unfunded mandates, stalled projects, and compliance gaps.
  • Develop and maintain risk indicator dashboards to provide early warning signals.
  • Translate analytical findings into risk reports, prioritized action items, and governance recommendations.
AI-Assisted Analysis and Innovation
  • Apply AI and machine learning tools, including large language models, automated classification, and predictive analytics, to accelerate data analysis.
  • Identify opportunities to integrate AI-assisted capabilities into analytical workflows.
  • Explore AI applications for document review, assessment, anomaly detection, and automated report generation.
  • Stay current with emerging AI tools and data analytics best practices.
Required Qualifications
  • 5+ years of progressive experience in business analysis, data analysis, or a related field.
  • Experience supporting enterprise IT portfolio or program management.
  • Strong proficiency in Power BI, including:
    • Data modeling
    • DAX
    • Report design
    • Dashboard development
    • WCAG 2.1 AA accessibility standards
  • Knowledge of business analysis methodologies and best practices, including requirements gathering, user stories, acceptance criteria, and stakeholder facilitation.
  • Understanding of IT portfolio management concepts, including project lifecycle, investment categorization, financial management, and risk governance.
  • Experience analyzing structured datasets, identifying patterns and anomalies, and developing analytical reports.
  • Ability to translate complex data findings into executive-level insights, reports, and presentations.
  • Strong data visualization skills.
  • Ability to manage multiple analytical workstreams and competing priorities.
  • Ability to work independently and proactively identify analytical opportunities.
  • Excellent written and verbal communication skills.
Preferred Skills
  • Experience with Planview portfolio management tools.
  • Experience integrating and analyzing data from multiple enterprise systems.
  • Experience with financial and IT investment portfolio analysis.
  • Knowledge of AI-assisted analytics, machine learning, and predictive analytics.
  • Experience in public-sector IT portfolio management.

Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veterans or individuals with disabilities.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Portfolio Data Analyst - Hybrid Chesterfield, VA
Portfolio Data Analyst - Hybrid Chesterfield, VA

Novalink Solutions LLC • Richmond (VA)

On-site
USD 90,000 - 130,000
Portfolio Data Analyst - Hybrid Chesterfield, VA
Portfolio Data Analyst - Hybrid Chesterfield, VA

Novalink Solutions • Richmond (VA)

On-site
USD 85,000 - 125,000
Portfolio Data Analyst – Contract Position
Portfolio Data Analyst – Contract Position

BranCore Technologies, LLC • Chesterfield Court House (VA)

Hybrid
USD 85,000 - 110,000
Project & Program Controls Analyst
Project & Program Controls Analyst

Ampcus Inc • City of White Plains (NY)

On-site
USD 70,000 - 95,000
Data Analyst
Data Analyst

Robotic Technologies Automation • Virginia

On-site
USD 87,000 - 117,000
Data Analyst
Data Analyst

Quantum Technologies. LLC • Virginia

On-site
USD 84,000 - 120,000
Data Analyst
Data Analyst

Valiant Technologies LLC • Virginia

On-site
USD 84,000 - 120,000
Data Analyst
Data Analyst

Robotics Technologies LLC • Chesterfield Court House (VA)

On-site
USD 84,000 - 120,000
Data Analyst
Data Analyst

Ethereum Technologies • Virginia

On-site
USD 84,000 - 120,000
Enterprise Portfolio Manager
Enterprise Portfolio Manager

Ampcus, Inc • City of White Plains (NY)

On-site
USD 80,000 - 120,000