Strategic Project Scheduler & Revenue Analyst

Alloy Enterprises; Petaling Jaya; On-site; MYR 67,000 - 123,000; Full time

Benefits offered by this job

Competitive salary

Paid vacation/holidays/sick time

Comprehensive benefits package

On-the-job/cross training

Job summary

Johnson Controls is seeking a skilled Project Scheduling & Analysis professional to support the Project Delivery team in scheduling, risk analysis, and reporting related to revenue, billing, and operations.

You will develop baselines, monitor timelines, and manage billing dashboards while coordinating with Lines of Business and site teams. Strong Primavera P6 and advanced Excel skills are required.

Qualifications

• Bachelor's degree in engineering or related field; 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, and 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, EOT assessments, LAD evaluations, and prepare delay chronology reports.
• Monitor schedule variances and update revised completion dates in coordination with LOB.
• Manage PPM Tollgate processes and upload documentation to SharePoint.
• Update SEA Revenue Tracker, backlog, forelog; perform revenue bridging analyses and prepare revenue charts.
• Develop billing trackers and dashboards for daily and monthly monitoring.
• Create timesheet templates for site teams; support ad-hoc data updates, reports, and analyses for management.

Skills

Analytical thinking

Problem-solving

Change management

Communication skills

Procurement management

Subcontractor management

Education

Bachelor's degree in engineering or related field

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 is seeking a skilled Project Scheduling & Analysis professional to support the Project Delivery team in scheduling, risk analysis, and reporting related to revenue, billing, and operations.

You will develop baselines, monitor timelines, and manage billing dashboards while coordinating with Lines of Business and site teams. Strong Primavera P6 and advanced Excel skills are required.