Project Controls Analyst at Stantec

Pune, maharashtra, India -

Full Time

Start Date

Immediate

Expiry Date

13 Jun, 26

Salary

0.0

Posted On

15 Mar, 26

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Power Bi Desktop, Etl, Data Visualization, Data Sources, Sharepoint, Azure, Power Query, Dax, Row-Level Security, Agile, Power Bi Services, Advance Excel, Analytical Thinking, Communication, Project Controls, Data Analysis

Industry

Industrial Machinery Manufacturing

Description

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. 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.

Responsibilities

The Portfolio Analyst supports colleagues, Project Managers, and Leadership by performing data tasks primarily in Power BI, including ETL, relationship management, and creating visuals. Key duties involve connecting various data sources, establishing table logic, and deploying/maintaining dashboards within Power BI Services.