Description
1. Primary Purpose of Job
The Senior Portfolio Analyst will support the Project Management team by designing, developing, and maintaining advanced Power BI reporting solutions and data analytics capabilities. Operating at a senior level, this role leads the delivery of high-quality dashboards and insights across projects, programmes, and portfolios, while also supporting and guiding junior analysts within the team.
The role requires a robust Power BI background combined with a solid understanding of project and programme management data – including cost, schedule, utilisation, and risk – enabling the analyst to work confidently with project controls data and translate it into meaningful, decision-ready reporting for Project Managers and leadership.
Power BI Reporting & Analytics
• Design, develop, and maintain advanced Power BI dashboards and reports providing real-time visibility into project performance, cost, schedule, utilisation, and portfolio-level KPIs.
• Translate project and programme data into actionable insights for Project Managers and leadership,
ensuring reports are intuitive, accurate, and aligned to stakeholder needs.
• Replace manual, Excel-heavy reporting with standardised, automated Power BI dashboards, driving consistency and reducing reporting effort across the team.
• Establish and maintain best practices for Power BI data modelling, report design, and governance, ensuring solutions are scalable and maintainable across multiple projects.
• Support and guide junior analysts in Power BI development, providing peer review and sharing knowledge to raise overall team capability.
Power Platform Development & Automation
• Design and develop Power Apps (Canvas and Model-Driven) to support project management use cases such as registers, logs, approvals, and trackers.
• Build and maintain Power Automate flows to automate routine reporting, notifications, and approval processes across the project delivery team.
• Manage integration
📌 Senior Portfolio Analyst (Pune)
🏢 Stantec
📍 Pune