Job Details:
Microsoft Project Specialist Excel
Project Analyst
The Project Analyst is responsible for all required project management administrative activities to support the assigned Project Managers. The Project Analyst performs the following project activities such as, but not limited to, project plan development and maintenance, activity sequencing, labor reporting, financial monitoring, variance analysis, cash flow analysis, etc. The Project Analyst is responsible for creating and maintaining project plans using Microsoft Project. The Project Analyst interfaces with project team staff to ensure the appropriate project plan activity updates are completed according to the schedules. The Project Analyst provides support to the Project Managers as part of Capital Portfolio activities as quarterly re-forecasting, monthly closing, and original budget setting.
Responsibilities
• Directly support Project Manager for all project activities through the project lifecycle
• Ensure assigned projects adhere to style, consistency and level of detail established by the Capital Portfolio Training and the project guidelines as established by the Division Portfolio Analyst
• Create and maintain project plans with work breakdown structure, activities, deliverables and milestones using the Microsoft Project
• Monitor and track work completed against estimated work and update the project plan using labor reporting systems for reference
• Capture, document and maintain all project assumptions
• Assist with project cash flow and variance analysis
• Track costs associated with rework and work with the Project Manager to identify root causes and develop recommended corrective actions
• Complete project status reports for Project Managers and the leadership team
• Create project funding requests to obtain project funding
• Collaborate with the Project Manager to identify opportunities to improve budget forecast by understanding the cause of budget variances
• Ensure timely creation and distribution of applicable project status updates and reporting
• Support the project manager in completing the activities required for the Capital Portfolio process to include quarterly re-forecasting, monthly close and labor tracking
Required Skills:
• Significant Experience creating and updating project plans, tasks, and timelines using Microsoft Project (online evaluation required)
• Working knowledge of work breakdown structures (WBS) and project management methodologies, particularly those in the PMI Project Management Body of Knowledge
• Ability to define and sequence activities
• Experience developing/facilitating/refining time and cost-based work estimates
• Strong interpersonal skills and ability to work with cross-functional teams
• Attention to detail and establish consistency across all projects
• Experience working across and meeting the needs of multiple projects on an on-going basis
• Experience with Microsoft PowerPoint to develop presentations for project funding activities, reporting and project status communication
• Advanced or Expert MS Project skills (5 years minimum; version 2003, 2007, 2010, 2013 or 2016)
• Advanced or Expert MS Excel Skills (5 years minimum on basic features; 1 year minimum with pivot tables & “VLOOKUP” formulas a must)
If interested please forward your resume in word format to kevin@libertyjobs.com