Project Scheduler & Revenue Insights Analyst

Johnson Controls; Petaling Jaya; On-site; MYR 60,000 - 100,000; Full time

Benefits offered by this job

Competitive salary

Paid vacation/holidays/sick time

Comprehensive benefits package

On the job/cross training

Collaborative team environment

Zero Harm safety policy

Job summary

Johnson Controls in Malaysia seeks a Project Scheduling & Analysis professional to support the Project Delivery team in scheduling, risk analysis, and revenue reporting. You will develop master schedules, monitor progress, and prepare dashboards and reports for management.

The ideal candidate holds a Bachelor's in engineering and 3-5 years of construction PM experience (MEP preferred), with strong skills in Primavera P6, MS Project, and advanced Excel.

Qualifications

• 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.

Responsibilities

• 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.
• 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.
• Create timesheet templates for site teams.
• Provide support for ad-hoc requests, including data updates, report preparation, and analysis for management.

Skills

Strong analytical skills

Problem-solving

Change management

Education

Bachelor's degree in engineering or related fields

Tools

Primavera P6

Microsoft Project

Advanced Microsoft Excel

Pivot Tables

VLOOKUP / INDEX-MATCH

Conditional Formatting

Chart & Dashboard Creation

Data Analysis & Forecasting

Job description

Johnson Controls in Malaysia seeks a Project Scheduling & Analysis professional to support the Project Delivery team in scheduling, risk analysis, and revenue reporting. You will develop master schedules, monitor progress, and prepare dashboards and reports for management.

The ideal candidate holds a Bachelor's in engineering and 3-5 years of construction PM experience (MEP preferred), with strong skills in Primavera P6, MS Project, and advanced Excel.