Business/Data Analyst - IT Portfolio

Intellibee

Chesterfield (MO)

On-site

USD 85,000 - 110,000

Full time

3 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

Benefits offered by this job

Long-Term Stability
Comprehensive Health Coverage
401(k) program
GC Assistance

Job summary

Intellibee seeks a Portfolio Data Analyst to provide decision-ready insights from IT portfolio data, Planview records, and budget information. This onsite role in Chesterfield, MO, involves building Power BI dashboards and strengthening Planview reporting and data quality for cross-agency portfolio intelligence.

You will elicit requirements across VITA and Commonwealth agencies, facilitate workshops, and synthesize data to guide PMCOE strategic objectives.

Qualifications

  • 5+ years in business/data analysis with enterprise IT portfolio experience.
  • Power BI proficiency with data modeling, DAX, report design, and WCAG 2.1 AA accessibility.
  • Experience gathering requirements, writing user stories, defining acceptance criteria, and facilitating.
  • Knowledge of IT portfolio concepts including project lifecycle, investments, financial management, and risk governance.
  • Ability to translate complex findings into executive-ready insights and presentations.

Responsibilities

  • Elicit, document, and validate business requirements for PMCOE analytics initiatives and reporting solutions.
  • Build Power BI dashboards and reports aligned to PMCOE objectives.
  • Integrate data from multiple sources to create unified portfolio views.
  • Monitor project performance data to surface systemic issues and risks.
  • Collaborate with Planview product owner to transform Planview for portfolio intelligence.
  • Analyze Planview data quality and recommend remediation approaches.

Skills

Power BI
DAX
Data analysis
Executive communication
Stakeholder facilitation
SQL

Tools

Planview
APIs
Web services
Excel
Power Query

Job description

Intellibee is seeking a Portfolio Data Analyst to support VITA leadership with decision-ready insights drawn from IT portfolio information, agency strategic plans, and Planview records. In this onsite role in Chesterfield, MO, you will translate requirements into analytical outputs, build portfolio dashboards in Power BI, and help strengthen Planview reporting and data quality for cross-agency portfolio intelligence.

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 analytical 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 shared 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 surface 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 using data visualization so Commonwealth IT portfolio data is accessible and actionable for project managers, agency heads, and VITA executive leadership.
  • Connect and integrate data from multiple sources to create unified portfolio views.
  • Automate recurring reports and data refreshes.
  • Iterate on dashboard design based on 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 for the Commonwealth.
  • Analyze Planview data quality by identifying gaps, inconsistencies, and stale records across agency submissions, then recommend remediation approaches for platform administrators to evaluate.
  • Recommend data model, taxonomy, and field-level standards to enable consistent cross-agency comparison, filtering, and aggregation for review and implementation by the Planview Product Owner.
  • Build Planview-native reports and views to ensure portfolio data is available within the platform as well as through 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, including modernization initiatives, shared infrastructure needs, or recurring security investments, that can inform VITA-led shared services or enterprise procurement.
  • Use 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 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 AI-assisted opportunities within 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 and contribute recommendations to PMCOE capability development.
What You Bring
  • 5 or more years of progressive experience in business analysis, data analysis, or a closely related role, including demonstrated experience supporting enterprise IT portfolio or program management.
  • Power BI proficiency, 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.
  • Experience using data analysis methods and tools to work with structured datasets, identify patterns and anomalies, and produce clear analytical narratives.
  • Ability to translate complex findings into executive-ready insights, reports, and presentations for technical and non-technical audiences.
  • Skill designing accurate, accessible data visualizations aligned to audience decision-making needs.
  • Ability to manage multiple 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, including documented requirements and clear data-driven presentation.
  • Experience presenting to senior and C-Level leaders (Required 3 Years).
  • Experience with Microsoft PowerBI (Required 3 Years).
  • Experience pulling data from multiple sources using APIs, web services, or other connectivity (Required 3 Years).
  • General data visualization experience using toolsets such as Excel, Power Query, or direct SQL (Required 3 Years).
Technologies
  • Power BI, DAX
  • WCAG 2.1 AA
  • APIs, web services
  • Excel, Power Query, SQL
  • Large language model assistants, machine learning, predictive analytics
Benefits at Intellibee
  • Long-Term Stability: Join multi-year opportunities with room to grow.
  • Comprehensive Health Coverage: Quality healthcare benefits for you and your family.
  • Future Planning: Enroll in a 401(k) program.
  • GC Assistance: Support for immediate Green Card processing, if required.

Location: Chesterfield, MO (onsite)
Experience: 5+ years
Employment Focus: Portfolio data analysis and requirements-to-reporting delivery for VITA leadership, including Power BI and Planview support.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Business/Data Analyst - IT Portfolio, Chesterfield, VA, US
Business/Data Analyst - IT Portfolio, Chesterfield, VA, US

Intellibee Inc • Virginia

On-site
USD 90,000 - 130,000
Long-Term Stability
Comprehensive Health Coverage
Future Planning
+1
Portfolio Data Analyst
Portfolio Data Analyst

TOMORROW HIRE • Virginia

Hybrid
USD 61,000 - 88,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 - Hybrid Chesterfield, VA
Portfolio Data Analyst - Hybrid Chesterfield, VA

Novalink Solutions LLC • Richmond (VA)

On-site
USD 90,000 - 130,000
Portfolio Data Analyst
Portfolio Data Analyst

Mbi Llc • Virginia

On-site
USD 110,000 - 150,000
Portfolio Data Analyst – Contract Position
Portfolio Data Analyst – Contract Position

BranCore Technologies • Chesterfield Court House (VA)

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

Lateral Insights LLC • Richmond (VA)

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

Lateral Insights • Great Falls (VA)

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

Yakshna Solutions • Herndon (VA)

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