Portfolio Reporting & Analytics Analyst – EPMO

US Anesthesia Partners

Portfolio Reporting & Analytics Analyst at USAP developing and enhancing enterprise portfolio dashboards and reporting solutions. Providing analytical support for project management decisions and resource utilization.

Posted 7/23/2026full-timeRemote • 🇺🇸 United StatesMid-LevelSenior💰 $66,900 - $113,700 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in developing and maintaining Power BI dashboards, reporting solutions, and analytics for portfolio management. Proficient in data analysis, project management principles, and delivering actionable insights to executive leadership.

Highest-signal resume keywords

Power BI Dashboard DevelopmentPortfolio ReportingData AnalyticsSmartsheet AdministrationKPI Development

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data ModelingDAXPower QueryPortfolio ManagementBusiness IntelligenceGovernance ReportingFinancial AnalysisProject Management MetricsReporting StandardsData Validation

Soft Skills

Analytical SkillsProblem-Solving SkillsCommunication SkillsOrganizational SkillsCustomer-Focused Mindset

Tools & Technologies

Power BISmartsheetMicrosoft ExcelMicrosoft PowerPointReporting Tools

Certifications & Qualifications

Microsoft Power BI CertificationPMPCAPMPMI-PBA

Industry Keywords

EPMOPMO OperationsHealthcare ITPortfolio ManagementStrategic Initiatives

Tech Stack

Tools & technologies

PMP

About the role

Key responsibilities & impact

Develops, maintains, and enhances enterprise portfolio dashboards, reports, and analytics using Power BI, Smartsheet, Excel, and other reporting tools.
Serves as the primary administrator and subject matter expert for EPMO reporting and analytics solutions.
Designs and maintains executive dashboards that provide visibility into project health, portfolio performance, strategic initiatives, resource utilization, risks, and key performance indicators.
Develops reporting standards, data definitions, KPI frameworks, and portfolio metrics to ensure consistency across the organization.
Collects, validates, analyzes, and reconciles project, financial, resource, and portfolio data from multiple systems and sources.
Identifies portfolio trends, risks, issues, dependencies, and opportunities and provides actionable recommendations to EPMO leadership.
Produces and distributes weekly, monthly, quarterly, and annual portfolio reports for leadership and governance committees.
Supports executive governance meetings by preparing presentation materials, scorecards, dashboards, and supporting analytics.
Creates and maintains portfolio health metrics, project performance indicators, and organizational performance reporting.
Supports demand management, capacity planning, resource planning, and portfolio prioritization activities through data analysis and reporting.
Develops and maintains Power BI datasets, dashboards, data models, calculated measures, and visualizations.
Partners with project managers, program managers, and business leaders to ensure reporting requirements are understood and delivered.
Monitors portfolio reporting accuracy and performs ongoing data quality assessments and corrective actions.
Develops executive-level presentations and report-outs using data visualization and storytelling techniques.
Supports EPMO governance processes by tracking and reporting project status, milestones, risks, issues, budgets, benefits realization, and strategic alignment.
Recommends and implements reporting process improvements, automation opportunities, and dashboard enhancements.
Maintains documentation for reporting processes, KPI definitions, dashboard specifications, and reporting procedures.
Provides reporting and analytics support for annual planning, strategic initiatives, and organizational performance reviews.
Supports audits and compliance activities related to project and portfolio reporting.
Participates in EPMO continuous improvement initiatives.
Other duties as assigned.

Requirements

What you’ll need

Bachelor's degree required; business analytics, information systems, data analytics, finance, business administration, or related field preferred.
3-7 years of experience in portfolio reporting, business intelligence, data analytics, PMO operations, or related disciplines.
Demonstrated experience developing Power BI dashboards and executive reporting solutions required.
Experience working within a Project Management Office (PMO), Enterprise PMO (EPMO), Portfolio Management, or Program Management environment preferred.
Experience administering and reporting from the Smartsheet platform strongly preferred.
Experience with portfolio management, project management, governance reporting, and KPI development preferred.
Experience supporting executive leadership reporting and strategic decision-making preferred.
Healthcare IT experience strongly preferred.
Microsoft Power BI certification preferred but not required.
PMP, CAPM, PMI-PBA, or related certification is a plus, but not required.
Advanced knowledge of portfolio reporting, business intelligence, and data analytics principles.
Advanced experience with Microsoft Power BI, including dashboard development, data modeling, Power Query, and DAX.
Strong experience with Smartsheet reporting, dashboards, and portfolio management solutions.
Strong analytical and problem-solving skills with the ability to identify trends and translate data into actionable insights.
Ability to develop executive-level dashboards, scorecards, and visual presentations.
Understanding of project, program, and portfolio management principles and methodologies.
Knowledge of project management metrics, KPIs, governance reporting, and performance management frameworks.
Strong written, verbal, presentation, and communication skills.
Ability to present complex information in a concise and meaningful manner to executive leadership.
Experience gathering reporting requirements and translating business needs into reporting solutions.
Strong organizational skills and attention to detail.
Ability to manage multiple priorities and deadlines simultaneously.
Customer-focused mindset with a commitment to quality and continuous improvement.
Advanced proficiency in Microsoft Excel, PowerPoint, and reporting tools.
Ability to read, write, and speak English.

Benefits

Comp & perks

Eligible for an annual bonus.
No guaranteed bonuses; awarded based on company and individual performance.