Project Planner, Project Delivery

Johnson Controls, Inc.; Petaling Jaya; On-site; MYR 60,000 - 90,000; Full time

Benefits offered by this job

Competitive salary

Paid vacation/holidays/sick time

Comprehensive benefits package

On the job/cross training

Encouraging and collaborative team

Job summary

Johnson Controls is seeking a skilled Project Scheduling & Revenue Analyst to support the Project Delivery team in scheduling, risk analysis, and revenue reporting. You will develop master schedules, monitor budgets, and build dashboards to track billing and forelog performance.

The role emphasizes collaboration with Lines of Business, SharePoint documentation, and ad-hoc data analysis for management decisions in a dynamic project environment.

Qualifications

• Bachelor's degree in engineering or related field with 3–5 years in construction project management (MEP preferred).
• Proficient in Primavera P6, Microsoft Project, and Advanced Microsoft Excel (Pivot Tables, VLOOKUP/INDEX-MATCH, Conditional Formatting, Charts).
• Strong analytical, problem-solving and change management skills.
• Experience in subcontractor and procurement management.
• In-depth understanding of PPM processes, revenue tracking, and billing.
• Excellent communication and collaboration skills.

Responsibilities

• Develop baseline master work programs and project schedules.
• Prepare S-Curve and manpower histograms based on project timelines.
• Conduct delay analysis, EOT assessments, LAD evaluations, and reports.
• Monitor schedule variances and update completion dates with LOB.
• Manage PPM Tollgate processes and upload documentation to SharePoint.
• Update SEA Revenue Tracker, backlog, forelog; analyze revenue changes.
• Create timesheet templates for site teams and support ad-hoc data requests.

Skills

Primavera P6

Microsoft Project

Excel - Advanced

Pivot Tables

VLOOKUP / INDEX-MATCH

Conditional Formatting

Chart & Dashboard Creation

Data Analysis & Forecasting

Analytical skills

Communication & collaboration

Subcontractor & procurement management

PPM processes understanding

Education

Bachelor's degree in engineering or related fields

Tools

Primavera P6

Microsoft Project

Excel (Advanced)

Pivot Tables

VLOOKUP / INDEX-MATCH

Conditional Formatting

Chart & Dashboard Creation

Data Analysis & Forecasting

Job description

Who we are:

Johnson Controls, a global leader in thermal management, mission-critical building systems, energy efficiency, and decarbonization, helps customers use energy more productively, reduce carbon emissions, and operate with the precision and resilience required in rapidly expanding industries such as data centers, healthcare, pharmaceuticals, advanced manufacturing, and higher education.

For more than 140 years, Johnson Controls has delivered performance where it really matters. Backed by advanced technology, lifecycle services and an industry-leading field organization, we elevate customer performance, turn goals into real-world results and help move society forward.

What you will do:

Support the Project Delivery team in project scheduling, risk analysis, performance monitoring, and preparation of reports related to revenue, billing, and operational support.

How you will do it:

A. Project Scheduling & Analysis

• Develop baseline master work programs and project schedules, including manpower histogram charts.

• Prepare S-Curve and manpower histograms based on project timelines.

• Conduct delay analysis, Extension of Time (EOT) assessments, Liquidated Damages (LAD) evaluations, and prepare delay chronology reports.

• Monitor schedule variances and update revised completion dates in coordination with Lines of Business (LOB).

• Manage PPM Tollgate processes and upload documentation to SharePoint.

B. Revenue & Billing Monitoring

• Update SEA Revenue Tracker, backlog, and forelog.

• Perform revenue bridging analysis to identify gaps in revenue changes.

• Prepare monthly and quarterly revenue charts.

• Manage forelog files and analyze sales data.

• Update UBR feedback, billing plans, total billing plans, and Power BI remaining data.

• Develop billing trackers and dashboards for daily and monthly monitoring.

C. Operational Support

• Create timesheet templates for site teams.

• Provide support for ad-hoc requests, including data updates, report preparation, and analysis for management.

What we look for:

• Bachelor's degree in engineering or related fields with 3–5 years of experience in construction project management (MEP experience preferred).

• Proficient in Primavera P6, Microsoft Project, and Advanced Microsoft Excel, including:

  • Pivot Tables

  • VLOOKUP / INDEX-MATCH

  • Conditional Formatting

  • Chart & Dashboard Creation

  • Data Analysis & Forecasting

• Strong analytical, problem-solving, and change management skills.

• Experience in subcontractor and procurement management.

• In-depth understanding of PPM processes, revenue tracking, and billing.

• Excellent communication and collaboration skills.

What we offer:

• Competitive salary

• Paid vacation/holidays/sick time

• Comprehensive benefits package

• On the job/cross training opportunities

• Encouraging and collaborative team environment

• Dedication to safety through our Zero Harm policy

#LI-AA3
#LI-Onsite