Project Controls Consultant I

C. Bachelor's Degree Day-to-Day Responsibilities/Workload

• Download financial data from various sources (SAP, SharePoint, Excel files) to prepare forecast reports. (approximately 1200+ records)
• Prepare/review /update project budgets/baselines, short- and long-term forecasts, and expenditure plans for electrical substation construction projects.
• Develop routine reports to assist in cost monitoring and management.
• Meet with Project Managers and review the project scope, timelines, forecast costs, including budgets, actuals, and commitments.
• Assist Project managers in reviewing and reporting on cost over/underruns versus approved budget/forecast.
• Conduct cost assessments and risk assessments and provide variance explanations for changes in project scope, materials, schedule.
• Update change management tool based on impact analysis.
• Prepare and present the monthly financial summary for a portfolio of over 50 projects to project management leadership.
• Provide risk analysis reports for various construction programs.

Required Skills/Attributes knowledge of Microsoft 365 applications, Intermediate MS Excel, knowledge of python programing and basic understanding of MS Access Desired Skills/Attributes Expert knowledge of MS Excel, Intermediate level knowledge of Python programming for risk analysis reporting, cluster analysis, and predictive analytics, knowledge of Power BI, and Microsoft Access Equal Opportunity Employer / Disabled / Protected Veterans The Know Your Rights poster is available here: https://www.eeoc.gov/sites/default/files/2023-06/22-088_EEOC_KnowYourRights6.12.pdf The pay transparency policy is available here: https://www.dol.gov/sites/dolgov/files/ofccp/pdf/pay-transp_%20English_formattedESQA508c.pdf For temporary assignments lasting 13 weeks or longer, AppleOne is pleased to offer major medical, dental, vision, 401k and any statutory sick pay where required. We are committed to working with and providing reasonable accommodations to individuals with disabilities. If you need a reasonable accommodation for any part of the employment process, please contact your staffing representative who will reach out to our HR team. AppleOne participates in the E-Verify program in certain locations as required by law. Learn more about the E-Verify program.

https:

//e-verify.uscis.gov/web/media/resourcesContents/E-Verify_Participation_Poster_ES.pdf We also consider for employment qualified applicants regardless of criminal histories, consistent with legal requirements, including, if applicable, the City of Los Angeles' Fair Chance Initiative for Hiring Ordinance. Pursuant to applicable state and municipal Fair Chance Laws and Ordinances, we will consider for employment-qualified applicants with arrest and conviction records, including, if applicable, the San Francisco Fair Chance Ordinance. For Los Angeles, CA applicants: Qualified applications with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act.