Stantec is a global leader in sustainable engineering, architecture, and environmental consulting. The diverse perspectives of our partners and interested parties drive us to think beyond what’s previously been done on critical issues like climate change, digital transformation, and future-proofing our cities and infrastructure. We innovate at the intersection of community, creativity, and client relationships to advance communities everywhere, so that together we can redefine what’s possible. The Stantec community unites approximately 32,000 employees working in over 450 locations across 6 continents. Primary Purpose of Job: The Portfolio Analyst supports and interacts with other colleagues within our Team, in relation to project data. This support is also extended to Project Managers, Program Managers, and Leadership Team in some cases. Successful candidates display strong analytical, problem-solving, organizational, and written/oral communication skills. Key Accountabilities: - Perform task on Power BI desktop (Basic to Advance) like ETL (Extract, Transform and Load), Manage Relationship and creating Visuals. - Setting up meeting and understanding the requirements of the stakeholders. - Connecting various data sources to Power BI (Folder, Files, SharePoint folder, Azure, or such databases). - Establishing the logic and primary keys for table relationship in Power BI. - Perform task independently using advance Power Query steps, DAX formula, Measures etc. - Capable of implementing row-level security on data along with an understanding of application security layer models in Power BI. - Should be creative in terms of producing visuals and showing data in presentable format. - Keep track of various dashboards created and targets. - Execute agile type of task under typical program/portfolio. - Creating and updating Power BI Procedures specific to Project. - Work on advance excel & Power BI to carry out any type of project analysis. - Analytical thinking for translating data into meaningful statistics & information. - Deployment of Dashboard and Maintenance of Power BI Services for various clients within Workspace. Handling Admin activities of Power BI workspace. - Effective Verbal & Written Communication, Proactiveness & ownership attitude is required. - Delivering Quality and Timely deliverables. - Any Graduate in Engineering; Post-Graduate in Construction Management would be preferable. - Should have experience in Power BI advance. - Power BI Certification preferred. - Working knowledge of Advance Excel. - Interest to learn & develop project controls capabilities. - Excellent written & verbal communication skills. - Basic understanding about the Project Management Knowledge areas & Planning Terminologies. **Primary Location:** India | Pune **Organization:** Stantec IN Business Unit **Employee Status:** Regular **Job Level:** Nonmanager **Travel:** No **Schedule:** Full time **Job Posting:** 09/06/2025 05:06:24 **Req ID:** 1001022