Data Analyst - Portfolio Data Analyst

Lateral Insights

Great Falls (VA)

Hybrid

USD 90,000 - 120,000

Full time

4 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

Lateral Insights is seeking a Portfolio Data Analyst - Finance and Investment to help elevate Virginia’s IT portfolio intelligence. The role focuses on transforming investment data and Planview records into actionable insights for VITA leadership and Commonwealth executives.

The ideal candidate will have strong Power BI experience, stakeholder engagement skills, and a curiosity for AI-assisted analysis to accelerate insight generation in a high-visibility public sector environment.

Qualifications

  • 8+ years of progressive experience in business/data analysis with portfolio or program mgmt.
  • Proficiency with Power BI, data modeling, DAX, and accessible dashboard design.
  • Experience in requirements elicitation, user stories, acceptance criteria, and stakeholder facilitation.
  • Knowledge of IT portfolio management concepts and financial/risk governance.

Responsibilities

  • Engage stakeholders to elicit, document, and validate PMCOE analytics requirements.
  • Synthesize data from Planview, Demand, and budgets into actionable insights.
  • Design, build, and maintain Power BI dashboards for executives and project managers.
  • Monitor project performance and identify risks and optimization opportunities.

Skills

Power BI
Data analysis
Requirements gathering
Executive storytelling

Tools

Planview
DAX

Job description

EOE Statement We are an equal employment opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status or any other characteristic protected by law.

Category Information Technology

Description

Role: Portfolio Data Analyst - Finance and Investment

Location: Richmond 2 days a week onsite VA

Interview Types: Both Web Cam and In Person. (The first will be a webcam, followed by a in-person in Richmond VA)

Summary:

We need a (Portfolio) Data Analyst with experience with multiple data sources and creating visualizations of that data analysis. 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 VITA leadership and Commonwealth agency executives.

This role operates as part of the Customer Experience FUSE function: it receives information already gathered and consolidated through VITA'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 $1B+ annual IT investment portfolio is understood, governed, and optimized.

Business Requirements and Acceptance Criteria
  • Engage stakeholders across VITA 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 VITA 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 VITA-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
  • 8 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.

Full-Time/Part-Time Full-Time

This position is currently accepting applications.

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 • Richmond (VA)

On-site
USD 85,000 - 125,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 – 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
Data Analyst
Data Analyst

Lateral Insights LLC • Richmond (VA)

Hybrid
USD 90,000 - 130,000
Portfolio Data Analyst
Portfolio Data Analyst

Ampcus, Inc • Chesterfield Court House (VA)

Hybrid
USD 90,000 - 130,000
Portfolio Data Analyst
Portfolio Data Analyst

Ampcus Inc • Chesterfield Court House (VA)

Hybrid
USD 85,000 - 110,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
Portfolio Data Analyst: Finance & Investment
Portfolio Data Analyst: Finance & Investment

Lateral Insights • Great Falls (VA)

Hybrid
USD 90,000 - 120,000
Portfolio Data Analyst | Power BI & Exec Insights (Hybrid)
Portfolio Data Analyst | Power BI & Exec Insights (Hybrid)

TOMORROW HIRE • Virginia

Hybrid
USD 61,000 - 88,000