Portfolio Analytics & Insights Analyst (Power BI)

U.S. Anesthesia Partners; Northern (KY); Hybrid; USD 67,000 - 114,000; Full time

Job summary

U.S. Anesthesia Partners seeks a Portfolio Reporting & Analytics Analyst – EPMO to develop, maintain, and enhance enterprise portfolio reporting, dashboards, and executive communications that support decision-making across the organization.

The role partners with PMO, IT, finance, and leadership to deliver Power BI and Smartsheet solutions, KPI frameworks, and governance reporting for weekly to annual reviews, with opportunities for growth.

Qualifications

• Bachelor's degree in business analytics, information systems, data analytics, finance, business administration, or related field.
• 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 administering and reporting from the Smartsheet platform strongly preferred.
• Experience with portfolio management, governance reporting, and KPI development preferred.

Responsibilities

• 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 KPIs.
• 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.

Skills

Power BI dashboards

Executive reporting

PMO experience

Data analytics

English communication

Analytical thinking

Data storytelling

Presentation skills

Stakeholder collaboration

Multi-priority management

Education

Bachelor's degree

Tools

Power BI

Smartsheet

Excel

Power Query

DAX

Job description

U.S. Anesthesia Partners seeks a Portfolio Reporting & Analytics Analyst – EPMO to develop, maintain, and enhance enterprise portfolio reporting, dashboards, and executive communications that support decision-making across the organization.

The role partners with PMO, IT, finance, and leadership to deliver Power BI and Smartsheet solutions, KPI frameworks, and governance reporting for weekly to annual reviews, with opportunities for growth.