Methods Analyst II - Portfolio Reporting Analyst Job Listing at City of Edmonton in Edmonton, AB (Job ID 52838)

Description

Reporting to the Manager of Business Case Development & Reporting, the Portfolio Reporting Analyst plays a key role in enabling enterprise-wide planning and decision-making through integrated portfolio analytics and reporting. This role focuses on developing and maintaining analytical tools, dashboards, and models that consolidate data from multiple systems to provide accurate, timely, and actionable insights. The Analyst supports the development of portfolio management processes within the Portfolio Lifecycle framework across EPS business areas. They conduct process assessments and gap analyses to identify areas for improvement, develop detailed process maps, workflows, SOPs, and metrics to measure performance, and provide detailed reporting. This position is ideal for a detail-oriented, analytically minded professional who thrives on transforming complex data into meaningful insights and driving process improvements that support organizational effectiveness across all business areas. Responsibilities include:

• Develop, maintain, and enhance reporting tools and dashboards using Power BI, Excel, and Smartsheet to support the full portfolio lifecycle.
• Integrate data from multiple systems to ensure accurate, current, and comprehensive reporting for strategic planning and decision-making.
• Coordinate data collection and validation efforts across business areas to support enterprise-wide portfolio performance measurement.
• Translate complex data into actionable insights using effective data visualization techniques tailored to diverse audiences.
• Prepare comprehensive reports and recommendations to improve organizational efficiency and develop business analysis products like Smartsheet dashboards and reports.
• Prepare reports, presentations, and briefing notes to communicate findings to senior leaders and stakeholders.
• Manage recurring and ad hoc reporting requirements for internal stakeholders and senior leadership.
• Design, build, and maintain analytical models and templates that support enterprise-wide data analysis and forecasting.
• Leverage tools such as Power BI, Excel, and SharePoint to automate and streamline reporting processes.
• Implement system requirements based on portfolio design, develop process maps, and document detailed workflows and SOPs.
• Maintain and update the project portfolio lifecycle process in Smartsheet, ensuring it meets EPS business requirements.
• Support the execution of other branch priority initiatives and strategic projects.
• Oversee the effective completion of deliverables by other team members or contributors on assigned initiatives.
• Other related duties as required.