Project Controls Analyst

Were active members of the communities we serve. Thats why at Stantec we always design with community in mind. We believe growing a great design company happens from the inside out. We look for people who are drawn to use every talent they possess, plus creativity, determination and a drive to do the extraordinary.

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