Portfolio Reporting & Analytics Analyst - EPMO
$66,900–$113,700 year
RemoteUnited States
Job Summary
Develop and maintain enterprise portfolio dashboards, reports, and analytics using Power BI, Smartsheet, and Excel to support organizational decision-making. Collect, validate, and reconcile project, financial, and resource data from multiple sources to identify trends, risks, and opportunities. Design executive-level scorecards and KPI frameworks that provide visibility into portfolio performance, strategic initiatives, and resource utilization. Partner with project managers, program leaders, and business stakeholders to define reporting requirements and deliver weekly, monthly, quarterly, and annual governance updates. Prepare presentation materials for executive meetings and support audit and compliance activities related to portfolio reporting.
Required Qualifications
- Bachelor's degree
- 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
Desired Qualifications
- business analytics, information systems, data analytics, finance, business administration, or related field
- Experience working within a Project Management Office (PMO), Enterprise PMO (EPMO), Portfolio Management, or Program Management environment
- Experience administering and reporting from the Smartsheet platform
- Experience with portfolio management, project management, governance reporting, and KPI development
- Experience supporting executive leadership reporting and strategic decision-making
- Healthcare IT experience
- Microsoft Power BI certification
- PMP, CAPM, PMI-PBA, or related certification
- 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
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.