Portfolio Reporting & Analytics Analyst - EPMO

Overview POSITION SUMMARY : The Portfolio Reporting & Analytics Analyst – EPMO is responsible for developing, maintaining, and enhancing enterprise portfolio reporting, analytics, dashboards, and executive-level communications that support organizational decision-making. This role serves as a key contributor within the Enterprise Project Management Office (EPMO), providing visibility into portfolio performance, project health, strategic initiative progress, resource utilization, and organizational priorities. The Portfolio Reporting & Analytics Analyst – EPMO partners closely with business stakeholders, project teams, program leadership, information technology, finance, and executive leadership to collect, validate, analyze, and present portfolio data. This role is responsible for developing and maintaining Smartsheet reports and dashboards, Power BI reporting solutions, portfolio KPIs, governance reporting, and executive-level report-outs used in weekly, monthly, quarterly, and annual business reviews. This role combines analytical expertise, data visualization, portfolio management knowledge, and executive communication skills to transform project and portfolio data into actionable insights that support organizational strategy and operational excellence. The base pay estimate for this role is $66,900-$113,700 annually. The final offer will depend on the skills, experience, and qualifications of the selected candidate. This range is for base pay only and does not include bonuses or other compensation. This position is eligible for an annual bonus. Bonuses are not guaranteed and are awarded based on company and individual performance. Job Highlights ESSENTIAL DUTIES AND RESPONSIBILITIES : ( The ideal candidate must be able to complete all physical requirements of the job with or without a reasonable accommodation) 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…