Portfolio Data Analyst

Ampcus, Inc

Chesterfield Court House (VA)

Hybrid

USD 90,000 - 130,000

Full time

2 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

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

The role focuses on transforming IT portfolio data into actionable insights and building interactive Power BI dashboards to support strategic decision-making. The ideal candidate will work with multiple data sources, gather requirements from stakeholders, develop dashboards, identify investment trends, and improve portfolio reporting and

Qualifications

  • 5+ years of progressive experience in business analysis or data analysis.
  • Experience supporting enterprise IT portfolio or program management.
  • Strong Power BI proficiency: data modeling, DAX, report design, dashboards, accessibility.
  • Knowledge of BA methodologies: requirements gathering, user stories, acceptance criteria.
  • Understanding IT portfolio management concepts: lifecycle, investment, risk governance.
  • Ability to translate data into executive-level insights and manage multiple workstreams.

Responsibilities

  • Engage stakeholders to elicit and validate analytical requirements and reports.
  • Build and maintain Power BI dashboards to support portfolio decisions.
  • Analyze data from multiple sources to identify trends and optimization opportunities.
  • Coordinate with Planview product owners to improve analytics.
  • Automate recurring reports and ensure data quality.
  • Develop risk and governance insights using data analytics.
  • Apply AI-assisted analytics to accelerate insights.

Skills

Business analysis
Data analysis
Stakeholder facilitation
Executive communication
Independent work

Tools

Power BI
Planview
DAX
Data modeling
Report design
Dashboard development
WCAG 2.1 AA accessibility

Job description

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.
  • 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.
  • 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.
  • 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.

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
Portfolio Data Analyst

Ampcus Inc • Chesterfield Court House (VA)

Hybrid
USD 85,000 - 110,000
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 • Chesterfield Court House (VA)

Hybrid
USD 85,000 - 110,000
Portfolio Data Analyst
Portfolio Data Analyst

TOMORROW HIRE • Virginia

Hybrid
USD 61,000 - 88,000
Portfolio Data Analyst
Portfolio Data Analyst

Yakshna Solutions • Herndon (VA)

On-site
USD 95,000 - 100,000
401(k)
Health insurance
Dental insurance
+5
Data Analyst - Portfolio Data Analyst
Data Analyst - Portfolio Data Analyst

Lateral Insights • Great Falls (VA)

Hybrid
USD 90,000 - 120,000
Data Analyst
Data Analyst

Ethereum Technologies LLC • Virginia

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

Robotics Technologies • Chesterfield Court House (VA)

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

Robotic Process Automation LLC • Virginia

On-site
USD 87,000 - 117,000