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.