Back to Jobs
Recently postedTechnology

Portfolio Data & Power BI Analyst

Stellar Professionals LLCVA🇺🇸United States

Quick overview

SeniorityMid Senior
Work modeOn Site
LocationVA, United States
SQLMicrosoft ExcelLLMPower BIData Analysis

Job description

Position Title: Senior IT Portfolio & Business Intelligence Analyst

Location: Chesterfield, VA (Local Richmond-area candidates preferred; must physically reside within the US for the duration of the assignment)

Work Arrangement: Hybrid (2 days onsite per week required)

Interview Process: Webcam Interview (1st round via webcam, with potential follow-up in-person interview if requested)

Role Summary

Seeking a Senior Portfolio Data Analyst to elevate enterprise IT portfolio intelligence from compliance reporting to strategic decision support. Sitting at the intersection of business analysis, financial analytics, and portfolio management, this role synthesizes investment records, agency strategic plans, and Planview data into executive-ready Power BI visualizations and actionable insights.

Key Responsibilities

  • BI Dashboarding & Data Integration: Design, build, and maintain accessible Power BI dashboards and reports by connecting multiple data sources via APIs, web services, Power Query, and SQL, while automating recurring data refreshes.

  • Portfolio Synthesis & Financial Analysis: Analyze IT budgets, appropriations, spending actuals, and project performance metrics (schedule/cost variance, risk exposure) to surface cross-agency patterns, redundancies, and shared service opportunities.

  • Planview Analytics & Governance: Partner with Planview administrators to audit data quality, standardize taxonomies, build native Planview views, and maintain early-warning risk indicator dashboards.

  • Requirements & AI-Assisted Analysis: Facilitate stakeholder workshops, maintain requirements traceability matrices, and leverage AI/ML tools (such as LLM assistants and anomaly detection) to accelerate portfolio trend analysis.

Required Skills & Qualifications

  • Business & Portfolio Analysis: 5+ years of progressive experience in business analysis or data analysis supporting enterprise IT portfolio or program management.

  • Power BI & Visualization: 3+ years of hands-on experience with Microsoft Power BI (data modeling, DAX, report design, WCAG 2.1 AA accessibility standards) and 3+ years using visualization/query toolsets such as Excel, Power Query, or direct SQL.

  • Data Connectivity: 3+ years of experience extracting and integrating data from multiple sources using APIs, web services, or other connectivity tools.

  • Executive Communication: 3+ years of experience translating complex analytical findings into clear, executive-ready narratives and presenting to senior and C-level leaders.

Will your resume get past this employer's screening? Check your resume against this job, free

Similar jobs