Project Controls Analyst

Project Controls AnalystLocation: 1-2 days in office/week in Oakland Duration: 18 month contract Pay range: $90.00/hour - $97.00/hourTOP THINGS: 1) Financial Acumen & Program Controls; 2) Resource Planning/Reconciliation experience; 3) Large program experience and soft skills (communication, cross-functional engagement, etc.)Department OverviewThe Electric Operations team ensures the delivery of safe and reliable electric service to our customers. Electric Operations is responsible for every aspect of electric distribution and transmission operations, including planning, engineering, maintenance and construction, asset management, business planning, restoration and emergency response.Job ResponsibilitiesSchedule Development and Analysis:In coordination with Project Manager develop project schedule and cash flow/forecast plans with functional department input.Attend Project and Job kickoff and walk down meetings.Create, maintain and update schedules.Document, monitor and communicate project milestones and risks with appropriate stakeholders.Participate in project status meetings, collect progress data and revise project plan as needed.Monitor financial progress and maintain Project Manager's order group.Develop, maintain and control project schedule plans using appropriate software (for ex: SAP Project System, SAP Work Management System, and MS Project).Cost Plan Development and Analysis:Use the cost and schedule plan to determine if project objectives are achievable. Create, maintain, and update monthly forecast budgets. Prepare various cost reports and maintain forecast accuracy.Prepare project performance analysis, cost, and schedule status reports. Identify cost and schedule variances from objectives and recommend corrective action.Assess and report on project performance using established industry standards.Ensure that responses to project budget, and GRC or FERC cost requests reflect accurate and current project cost information and stakeholders are in concurrence.Provide regular communication on project cost, schedule and risk status to project team members, stakeholders and public.Interface with design and planning resources and software systems.Review and assist in the preparation of Advance Authorizations, Job Estimates and Re-Authorizations and assist PM in routing for approval.Prepare journal entries and coordinate or process goods receipts in current software system.Input data into various programs and prepare various cost and forecasting reports.Project Documentation & Reporting:Verify that project cost and schedule milestones were/were not attained and provide input to identify future process or business improvements and work with responsible parties to implement.Manage orders from inception through completion and all required documentation is entered in current software system (Ex: EDMS).Resolve all open items, ensure compliance requirements are met and settlement rules are entered, and close out order.Maintain scope change, contingency release, change order, and journal entry logs.Maintain written and electronic project documentation and records for required aspects of the project: Maintain project files in accordance with established guidelines and requirements (Ex: utilizing the electronic document management system or EDMS).Document change order requests, project status, key issues, risks and resolution, priority changes and approvals.Provide Project Manager with monthly report of project costs and/or schedule information including variance analysis according to an agreed upon level of detail and prioritization.Provide Project Team members with current status report containing schedule and cost information.Comply with Utility Operations Policies, Standards and Guidelines.Assist PM with Post Job Critique.Central Data Management Functions - Quality and Analysis:Prepare various monthly and weekly project management reports and report performance reports to management group including scorecards.Ensure quality of reports for the department, to report out to stakeholders.Validate weekly and monthly data sets.May provide support to project manager(s) as necessary.Fulfill ad-hoc requests for cost-related data analysis.Participate on (or lead) various process improvement initiatives within Project Management.Central Financial Analysis Functions - Project Budget & Cycle Forecast Monitoring/Reporting:Prepare various monthly and weekly project performance reports - budget and cycle forecast reports; and finance status reports, utilizing the financial tracking software (e.g. SAP/BW system and EPM).Coordinate and work with all stakeholders, on creating new reports, that best measure and support good business decisions, to meet the Year End Annual Budget target.Coordinate and summarize project cycle forecast variance explanations for the department, to report out to stakeholders.Ensure that all responses to budget, quarterly cycle requests reflect accurate and current project cost information and stakeholders are in concurrence.Post and update all the project performance; budget and cycle forecast; and status reports on the Project Management website.FINANCIAL AND PERFORMANCE MANAGEMENT:Monitor, analyze and report out on the Department's Forecasting Performance, with weekly performance reports, utilizing the financial tracking tools (e.g. SAP/BW).Analyze financial results on a monthly basis, providing explanations of significant cost drivers to PM Leadership – reports such as the Green-Red Scorecard and Lessons Learned Reports.QualificationsMinimum:Bachelor's degree from an accredited college or its equivalent in education and experience7 years as a Project Controls Analyst; OR, 10 years of experience in electric or gas transmission and/or, distribution business operations area, business planning, accounting, finance, construction management and/or project management; OR 8 years of related experience if hired externallyCertified Associate in Project Management (CAPM) or Project Management Professional (PMP) CertificationDesired:Experience with appropriate software tools, currently SAP Work Management, Controlling Orders, Planning Orders, BW and Analysis for OfficeProject Management, Project Controls, or Construction Management experienceRisk Management and Earned Value Analysis experienceAccounting/budgeting knowledgeMathematical skillsForecasting skillsProficiency in EXCEL, ACCESS, Primavera P6Knowledge of P6 schedulingKnowledge of Unifier, ProjectWise, and/or HeavyBidBenefits: (employee contribution) Health insurance Health savings account Dental insurance Vision insurance Flexible spending accounts Life insurance Retirement plan