Data Analyst

Lateral Insights LLC

Richmond (VA)

Hybrid

USD 90,000 - 130,000

Full time

3 days 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

Lateral Insights LLC in Richmond, VA is seeking a senior business/data analyst to support PMCOE analytical initiatives across 67 agencies. In a hybrid role, you will translate stakeholder requirements into Planview enhancements and reporting solutions, and design Power BI dashboards that reveal portfolio performance.

You will unify data from Demand, Planview, and budget data, monitor project performance, and deliver executive-ready insights.

Qualifications

  • 8+ years of progressive experience in business analysis or data analysis, supporting enterprise IT portfolios.
  • Proficiency with Power BI and DAX, plus WCAG 2.1 AA accessibility standards.
  • Knowledge of requirements elicitation, user stories, acceptance criteria, and stakeholder facilitation.
  • Understanding IT portfolio management concepts, including project lifecycle, investment categorization, financial management, and risk governance.
  • Ability to translate complex findings into executive-ready insights and presentations.
  • Ability to design accurate, accessible data visualizations.

Responsibilities

  • Work with 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 agency IT directors, portfolio managers, budget analysts, and executive sponsors into actionable specifications.
  • Maintain a requirements traceability matrix to keep deliverables aligned to PMCOE objectives and stakeholder expectations.
  • Synthesize information from Demand function, Planview records, and legislative budget data to identify patterns, trends, redundancies, and optimization opportunities across 67 agencies.
  • Produce cross-agency demand analyses highlighting technology needs, shared service opportunities, software consolidation candidates, and reuse potential.
  • Monitor and analyze project performance data 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 combining Demand function information with financial and portfolio performance data.
  • Design, build, and maintain Power BI dashboards and reports for audiences from project managers to agency heads and VITA leadership.
  • Connect and integrate data from multiple sources to create unified portfolio views, and automate recurring reports and data refreshes.
  • Iterate on dashboard design based on structured stakeholder feedback and evolving PMCOE reporting priorities.
  • Partner with Planview Product Owner to transform Planview into a strategic, data-driven portfolio intelligence platform.
  • Assess Planview data quality by identifying gaps and recommending remediation approaches.
  • Recommend data model, taxonomy, and field-level standards for cross-agency comparisons.
  • Build Planview-native reports and views to complement Power BI dashboards.
  • Analyze agency IT budget submissions, biennium appropriations, and spending actuals to identify financial trends and cost anomalies.
  • Cross-reference financial data with Planview investment records to validate disclosures.
  • Identify cross-agency demand patterns for shared services or enterprise procurement.
  • Apply data analysis to identify risk patterns and systemic vulnerabilities across the portfolio.
  • Develop and maintain risk indicator dashboards for PMCOE leadership.
  • Contribute to PMCOE risk reporting with structured narratives and governance recommendations.
  • Apply AI/ML tools to accelerate portfolio analysis and narrative generation.
  • Identify and pilot AI-enabled capabilities in PMCOE workflows.
  • Stay current on AI/data analytics best practices for public sector portfolio management.

Skills

8+ years experience
Power BI
DAX
WCAG 2.1 AA
Requirements elicitation
Stakeholder facilitation
Data analysis
Executive storytelling

Tools

Planview
AI tools
Predictive analytics
Large language models

Job description

Lateral Insights LLC supports PMCOE by turning multi-source investment, governance, and financial information into decision-ready insights for the Commonwealth. In this hybrid role in Richmond, VA, you will help improve portfolio intelligence through stakeholder-driven requirements, data integration, and analytics that enable clearer planning across 67 agencies.

What you’ll do
  • Work with 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 agency IT directors, portfolio managers, budget analysts, and executive sponsors into actionable specifications.
  • Maintain a requirements traceability matrix to keep deliverables aligned to PMCOE strategic objectives and stakeholder expectations.
  • 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 highlight common technology needs, shared service opportunities, software consolidation candidates, and reuse potential, using Demand function information as the primary input.
  • Monitor and analyze project performance data, including 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 combining 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 and actionable for audiences ranging from project managers to agency heads and VITA executive leadership.
  • Connect and integrate data from multiple sources to create unified portfolio views, and automate recurring reports and data refreshes.
  • Iterate on dashboard design based on structured stakeholder feedback, usage patterns, and evolving PMCOE reporting priorities.
  • Partner with the Planview Product Owner and platform administrators to support transforming Planview from a project tracking tool into a strategic, data-driven portfolio intelligence platform.
  • Assess Planview data quality by identifying gaps, inconsistencies, and stale records, and recommend remediation approaches for platform administrators to evaluate.
  • Recommend data model, taxonomy, and field-level standards to support consistent cross-agency comparison, filtering, and aggregation.
  • Build Planview-native reports and views to complement Power BI dashboards and ensure portfolio data is accessible both within the platform and via external reporting tools.
  • 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, identify discrepancies, and produce reconciled portfolio financials for executive reporting.
  • Identify cross-agency demand patterns that represent opportunities for VITA-led shared services or enterprise procurement.
  • Apply data analysis to identify common risk patterns 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 to 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, 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.
What you bring
  • 8+ years of progressive experience in business analysis, data analysis, or a closely related role, including demonstrated experience supporting enterprise IT portfolio or program management.
  • Proficiency with Power BI: 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.
  • Ability to use data analysis methods and tools with structured datasets to identify patterns and anomalies and produce clear analytical narratives.
  • Skill in translating complex findings into clear, executive-ready insights, reports, and presentations for technical and non-technical audiences.
  • Ability to design accurate, accessible data visualizations aligned to audience decision-making needs.
  • Capability 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, including documenting requirements and presenting data-driven findings clearly and concisely.
Tools you’ll use
  • Power BI, DAX
  • Large language model assistants
  • Automated classification
  • Predictive analytics
  • AI and machine learning tools
  • WCAG 2.1 AA
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Analyst - Portfolio Data Analyst
Data Analyst - Portfolio Data Analyst

Lateral Insights • Great Falls (VA)

Hybrid
USD 90,000 - 120,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

Skywalk Global • Virginia

Hybrid
USD 90,000 - 120,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
Analyst, Office of the CIO
Analyst, Office of the CIO

Sony Pictures Entertainment, Inc • Culver City (CA)

On-site
USD 85,000 - 120,000