Construction Project Controls Analyst: Forecast & Schedule Insight

Oregonite; Oakland (CA); Hybrid; USD 70,000 - 120,000; Full time

Benefits offered by this job

Health insurance

Dental & Vision coverage

401(k) with company match

Hybrid/Remote options

Job summary

Consor in Oakland, CA is seeking a Project Controls Analyst to support cost, schedule, budget, and forecast data, ensuring timely, accurate reporting for project leadership. The role focuses on maintaining cost-control workbooks, schedules in Primavera P6, and producing dashboards and variance analyses.

Ideal candidates have 2–5 years in project controls, strong Excel skills, and experience with cost reporting, budgeting, and schedule updates.

Qualifications

• Bachelor’s degree in engineering, construction management, business, finance, economics, project management, or a related discipline; equivalent education/experience may be considered.
• 2–5 years of relevant experience in project controls, cost control, scheduling, construction or project management, finance, or capital program support.
• Working knowledge of Primavera P6 and Microsoft Excel, including data validation, formulas, pivot tables, charts, data analysis, and reporting tools.
• Familiarity with cost reporting, budgeting, forecasting, cash flow, schedule updates, progress measurement, and variance analysis.
• Demonstrated ability to organize and analyze complex information, communicate effectively in written and verbal formats, manage multiple priorities and deadlines, and collaborate with cross-functional project teams.
• Experience supporting transit, rail, infrastructure, construction, or other capital improvement programs is preferred.

Responsibilities

• Maintain assigned cost-control workbooks, cost reports, commitment logs, invoice records, accruals, expenditure logs, and related supporting documentation.
• Support quarterly budget and forecast updates, including development and maintenance of estimate-to-complete (ETC) and estimate-at-completion (EAC) inputs.
• Reconcile project controls data against financial system extracts and identify discrepancies for review and resolution.
• Track approved budgets, funding allocations, commitments, actual expenditures, and forecasted cash flow by control account, WBS element, contract, or other reporting structure.
• Prepare cost variance summaries, supporting analyses, and detailed backup for review by the Senior Project Controls Lead.
• Support the identification and documentation of cost trends, variances, and potential impacts to project budgets and forecasts.
• Maintain Primavera P6 schedule data, schedule update logs, calendars, coding structures, layouts, and related schedule control files.
• Support monthly schedule update reviews, including validation of progress, review of activity logic and constraints, identification of open-ended activities, and completion of schedule quality checks.
• Extract, organize, and analyze schedule information for dashboards, reports, look-ahead schedules, milestone tracking, and trend analysis.
• Monitor critical and near-critical paths, key milestones, float movement, progress status, and schedule variances, and elevate observations to the Senior Project Controls Lead.
• Assist with the review and documentation of schedule narratives, schedule changes, and related change logs.
• Support the identification and reporting of emerging schedule trends and potential impacts to project delivery.
• Compile and validate cost, schedule, risk, and performance data from project teams, contractors, financial systems, and other sources.
• Maintain project controls dashboards, logs, trackers, databases, and document control records.
• Prepare recurring monthly and ad hoc reports, charts, dashboards, and presentation materials using approved templates and reporting standards.
• Identify data trends, variances, exceptions, and inconsistencies and prepare concise supporting analyses for review by the Senior Project Controls Lead.
• Perform data quality and completeness checks to ensure reported information is accurate, traceable, and submitted on time.
• Maintain documentation to facilitate auditability and traceability of reported project controls information.

Skills

Project controls

Cost control

Scheduling

Data analysis

Communication

Education

Bachelor’s degree (engineering / construction management / business)

Tools

Primavera P6

Microsoft Excel

Job description

Consor in Oakland, CA is seeking a Project Controls Analyst to support cost, schedule, budget, and forecast data, ensuring timely, accurate reporting for project leadership. The role focuses on maintaining cost-control workbooks, schedules in Primavera P6, and producing dashboards and variance analyses.

Ideal candidates have 2–5 years in project controls, strong Excel skills, and experience with cost reporting, budgeting, and schedule updates.