Back to search

Portfolio Data Analyst

The Portfolio Data Analyst role elevates the Commonwealth's IT portfolio intelligence from compliance reporting to strategic decision support, sitting at the intersection of business analysis, data analytics, and enterprise portfolio management.

  • United States +3 more
  • Full-time
  • Hybrid
  • MAX VENDOR RATE: ***
  • Posted Nov 18, 2026
INDUSTRYManagement & OperationsManagement Consulting

Locations (4)

  • United States
  • Canada
  • Mexico
  • India

Responsibilities

  • Engage stakeholders across Commonwealth and Commonwealth agencies to elicit, document, and validate business requirements for PMCOE analytical initiatives, Planview enhancements, and reporting solutions.
  • Facilitate requirements workshops and working sessions, synthesizing input from diverse stakeholders.
  • Maintain a requirements traceability matrix to ensure analytical deliverables align to PMCOE strategic objectives.
  • Synthesize information from the Demand function, Planview records, and legislative budget data to identify patterns, trends, redundancies, and optimization opportunities across 67 agencies.
  • Produce cross-agency demand analyses that surface common technology needs, shared service opportunities, software consolidation candidates, and reuse potential.
  • Monitor and analyze project performance data (schedule variance, cost variance, risk exposure, and milestone trends) to identify systemic issues.
  • Design, build, and maintain Power BI dashboards and reports that make Commonwealth IT portfolio data accessible, interpretable, and actionable.
  • Connect and integrate data from multiple data sources to create unified portfolio views.
  • Automate recurring reports and data refreshes.
  • Partner with the Planview Product Owner and platform administrators to support the transformation of Planview into a strategic, data-driven portfolio intelligence platform.
  • Analyze Planview data quality, identifying gaps, inconsistencies, and stale records.
  • Recommend data model, taxonomy, and field-level standards for consistent cross-agency comparison.
  • Build Planview-native reports and views that complement Power BI dashboards.
  • Analyze agency IT budget submissions, biennium appropriations, and spending actuals to identify financial trends, funding gaps, unfunded mandates, and cost anomalies.
  • Cross-reference financial data with Planview investment records to validate cost disclosures and produce reconciled portfolio financials.
  • Apply data analysis techniques to identify common risk patterns, recurring issues, and systemic vulnerabilities across the Commonwealth IT portfolio.
  • Develop and maintain risk indicator dashboards that provide PMCOE leadership with early warning signals of portfolio-level distress.
  • Contribute to PMCOE risk reporting frameworks by translating data-driven findings into structured risk narratives, prioritized action items, and governance recommendations.
  • Apply AI and machine learning tools, including large language model assistants, automated classification, and predictive analytics, to accelerate portfolio analysis.
  • Identify and pilot opportunities to integrate AI-assisted capabilities into PMCOE analytical workflows.

Requirements

  • Experience in a Public Sector

Nice to have: AI-assisted analysis tools

Skills

Power BIData modelingDAXReport designDashboard developmentBusiness analysis frameworksRequirement solicitationUser story writingAcceptance criteria definitionStakeholder facilitationIT portfolio management conceptsData analysis methodsPower BIPlanview

Full description

Company Description: IMCS Group is one of the fastest growing MWBE (Minority Woman Owned Enterprise) staffing firms in the U.S. We focus on bringing a Diversity Recruitment approach to Fortune 500 companies within North America and EMEA region contingent labor programs. IMCS Group excels in providing top talent in IT, Healthcare, Engineering, Finance, Light Industrial, Contact Center, and Clerical. We have offices in the US, Canada, Mexico, and India in which we can provide support to our clients. Short Description: We need a (Portfolio) Data Analyst with experience with multiple data sources and creating visualizations of that data analysis DAYS ON SITE: 2 days a week required MAX VENDOR RATE: *** Deadline to submit: Fri 11/20 by 4 pm EST Complete Description: *Both Web Cam and In Person. (The first will be a webcam, but if we feel we need to have an in person interview - we would like that flexibility) 2 days a week hybrid/onsite required We need a (Portfolio) Data Analyst with experience with multiple data sources and creating visualizations of that data analysis More about the role The Portfolio Data Analyst is a role within the PMCOE, created to elevate the Commonwealth's IT portfolio intelligence from compliance reporting to strategic decision support. This position sits at the intersection of business analysis, data analytics, and enterprise portfolio management, translating investment data, agency strategic plans, and Planview portfolio records into actionable insights for *** leadership and Commonwealth agency executives. This role operates as part of the Customer Experience FUSE function: it receives information already gathered and consolidated through ***'s Demand function, primarily agency Strategic Partner engagement and ITSP intake, and synthesizes that information, together with Planview, governance, and financial data, into portfolio-level knowledge. The Portfolio Business Analyst does not independently conduct agency-level demand sensing; that work belongs to the Demand function under the Director of Customer Relationships. The value this role adds is downstream: pattern recognition, cross-agency synthesis, and decision-ready analysis built on top of information the Demand function has already collected. The ideal candidate brings strong analytical and requirements-gathering skills, hands-on Power BI experience, and a curiosity about how data can drive better public-sector investment decisions. Experience applying AI-assisted analysis tools to accelerate insight generation is a strong differentiator for this role. This isa high-visibility position with direct impact on how Virginia's ***B+ annual IT investment portfolio is understood, governed, and optimized. Business Requirements and Acceptance Criteria ●Engage stakeholders across *** and Commonwealth agencies to elicit, document, and validate business requirements for PMCOE analytical initiatives, Planview enhancements, and reporting solutions. ●Facilitate requirements workshops and working sessions, synthesizing input from diverse stakeholders, including agency IT directors, portfolio managers, budget analysts, and executive sponsors, into actionable specifications. ●Maintain a requirements traceability matrix to ensure that analytical deliverables remain aligned to PMCOE strategic objectives and stakeholder expectations. Portfolio Synthesis and Trend Intelligence ●Synthesize information produced by the Demand function, Planview records, and legislative budget data to identify patterns, trends, redundancies, and optimization opportunities across 67 agencies. ●Produce cross-agency demand analyses that surface common technology needs, shared service opportunities, software consolidation candidates, and reuse potential, drawing on Demand function information as the primary input rather than independent agency outreach. ●Monitor and analyze project performance data (schedule variance, cost variance, risk exposure, and milestone trends) to identify systemic issues, recurring risk patterns, and predictive indicators of project distress. ●Build a forward-looking view of Commonwealth technology demand, investment gaps, and emerging priorities by fusing Demand function information with financial and portfolio performance data. ●Design, build, and maintain Power BI dashboards and reports that make Commonwealth IT portfolio data accessible, interpretable, and actionable for audiences ranging from project managers to agency heads and *** executive leadership using data visualization ●Connect and integrate data from multiple data sources to create unified portfolio views. ●Automate recurring reports and data refreshes ●Iterate on dashboard design based on structured stakeholder feedback, usage patterns, and evolving PMCOE reporting priorities. Planview Analytics Partnership ●Partner with the Planview Product Owner and platform administrators to support the transformation of Planview from a project tracking tool into a strategic, data-driven portfolio intelligence platform for the Commonwealth. ●Analyze Planview data quality, identifying gaps, inconsistencies, and stale records across agency submissions, and recommend remediation approaches for platform administrators to evaluate. ●Recommend data model, taxonomy, and field-level standards that would enable consistent cross-agency comparison, filtering, and aggregation, for review and implementation by the Planview Product Owner. ●Build Planview-native reports and views that complement Power BI dashboards, ensuring portfolio data is accessible within the platform as well as through external reporting tools. Financial and Portfolio Analysis ●Analyze agency IT budget submissions, biennium appropriations, and spending actuals to identify financial trends, funding gaps, unfunded mandates, and cost anomalies across the Commonwealth portfolio. ●Cross-reference financial data with Planview investment records to validate cost disclosures, identify discrepancies, and produce reconciled portfolio financials for executive reporting. ●Identify cross-agency demand patterns, such as common modernization initiatives, shared infrastructure needs, or recurring security investments, which represent opportunities for ***-led shared services or enterprise procurement. Risk and Issue Intelligence ●Apply data analysis techniques to identify common risk patterns, recurring issues, and systemic vulnerabilities across the Commonwealth IT portfolio, including expired contracts, unfunded mandates, stalled projects, and IV&V compliance gaps. ●Develop and maintain risk indicator dashboards that provide PMCOE leadership with early warning signals of portfolio-level distress. ●Contribute to PMCOE risk reporting frameworks by translating data-driven findings into structured risk narratives, prioritized action items, and governance recommendations. AI-Assisted Analysis and Innovation ●Apply AI and machine learning tools, including large language model assistants, automated classification, and predictive analytics, to accelerate portfolio analysis, pattern recognition, and insight generation. ●Identify and pilot opportunities to integrate AI-assisted capabilities into PMCOE analytical workflows, including document review, ITSP assessment, anomaly detection, and narrative generation. ●Stay current on emerging AI tools and data analytics best practices relevant to public sector portfolio management, contributing recommendations to PMCOE capability development. Required Qualifications ●5 or more years of progressive experience in business analysis, data analysis, or a closely related role, with demonstrated experience supporting enterprise IT portfolio or program management. ●Demonstrated proficiency with Power BI, including data modeling, DAX, report design, dashboard development, and meeting WCAG 2.1 AA accessibility standards. ●Knowledge of business analysis frameworks and best practices, including requirement solicitation, user story writing, acceptance criteria definition, and stakeholder facilitation. ●Knowledge of IT portfolio management concepts, including project lifecycle, investment categorization, financial management, and risk governance. ●Knowledge of data analysis methods and tools, including the ability to work with structured datasets, identify patterns and anomalies, and produce clear analytical narratives. ●Skill in translating complex data findings into clear, executive-ready insights, reports, and presentations for both technical and non-technical audiences. ●Skill in designing data visualizations that are accurate, accessible, and aligned to audience decision-making needs. ●Ability to manage multiple concurrent analytical workstreams with competing priorities and deadlines in a fast-paced government environment. ●Ability to work independently and proactively, identifying opportunities for analytical value without waiting for direction. ●Excellent written and verbal communication skills, with demonstrated ability to document requirements and present data-driven findings clearly and concisely. EEOC Disclaimer: IMCS Group is an equal opportunity employer and makes employment decisions without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran status, disability status, age, or any other status protected by law. IMCS Group is committed to maintaining an inclusive workforce, where employees are hired, retained, compensated, and promoted based on their contributions to our Company.

Portfolio Data Analyst at IMCS Group Inc | Referso Jobs