Project Data and Cost Analyst

Swid Process Technologies Pvt. Ltd.

Pune

On-site

INR 900,000 - 1,300,000

Full time

4 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Swid Process Technologies Pvt. Ltd. is seeking a Project Data and Cost Analyst in Pune to own project MIS, drive cost control, and manage cash visibility.

You will validate progress, capture all cost components, and reconcile budgets against actuals from site to treasury, ensuring accurate WIP and revenue reporting. The role requires 3+ years in project MIS or EPC analytics, advanced Excel and Power BI skills, and a strong maker-checker discipline.

Qualifications

  • Graduate in Engineering, Finance, Commerce, Statistics or Operations.
  • 3+ years in project MIS, costing, project controls or EPC analytics.
  • Advanced Excel / Equivalent; ERP and Power BI/dashboard skills preferred.
  • Understanding of BoM, inventory, project budgets, accruals and cost-to-complete.
  • Strong analytical judgment, data validation, presentation and follow-up discipline.
  • Treasury, banking portal, borrowing, BG/LC, payroll-control and insurance-record exposure.
  • Strong confidentiality, cybersecurity awareness and maker-checker discipline.

Responsibilities

  • Design and maintain the single source of truth for project MIS, dashboards and portfolio summaries.
  • Validate reported progress against measurements, photographs, dispatch records and approved scope.
  • Capture and reconcile material, labour, contractor, machinery, travel, lodging and other project costs.
  • Compare budget, BoM, actual consumption, committed cost and cost-to-complete project-wise.
  • Analyse productivity, cost per kWp, schedule variance, billing status, cash exposure and expected margin.
  • Issue exception alerts for overruns, abnormal consumption, idle resources, delayed billing and data gaps.
  • Support weekly/monthly reviews, forecasts, project closure and lessons-learned analysis.
  • Reconcile physical progress with billing eligibility, unbilled revenue, retention, advances, WIP and collection position.
  • Prepare the daily bank position and rolling 13-week cash-flow forecast using approved receipt and payment assumptions.
  • Maintain loan, working-capital limit, interest, EMI, covenant, charge, BG, LC, FD, lender NOC and banking registers.
  • Prepare authorized banking and payroll-funding transactions under maker-checker control; never independently approve or release payment.
  • Maintain HR-approved payroll funding/reconciliation and insurance policy, renewal, claim and asset/site declaration records.
  • Maintain and update the Daily Work Report (DWR) every working day with tasks, progress, results, pending actions, blockers and supporting evidence.

Job description

Master Role Bank — Project Data and Cost Analyst
Designation

Project Data and Cost Analyst

Department

Operations

Reports To

Head Projects; functional reporting to PRCC Manager / Commercial Finance Manager; treasury and bank-control oversight by Chief Financial Officer

Direct Reports

None

Backup Coverage

Another Project Data and Cost Analyst; Finance Manager and Controller for treasury continuity; Project Coordinator may collect documents but cannot own or approve financial MIS

Role Purpose

Own project MIS, progress analytics, revenue and cost control, cost-to-complete, margin and cash visibility, together with treasury, banking, payroll-funding and insurance controls, using one reconciled Projects-Finance dataset.

Job Description and Responsibilities
  1. Design and maintain the single source of truth for project MIS, dashboards and portfolio summaries.
  2. Validate reported progress against measurements, photographs, dispatch records and approved scope.
  3. Capture and reconcile material, labour, contractor, machinery, travel, lodging and other project costs.
  4. Compare budget, BoM, actual consumption, committed cost and cost-to-complete project-wise.
  5. Analyse productivity, cost per kWp, schedule variance, billing status, cash exposure and expected margin.
  6. Issue exception alerts for overruns, abnormal consumption, idle resources, delayed billing and data gaps.
  7. Support weekly/monthly reviews, forecasts, project closure and lessons-learned analysis.
  8. Reconcile physical progress with billing eligibility, unbilled revenue, retention, advances, WIP and collection position.
  9. Prepare the daily bank position and rolling 13‑week cash‑flow forecast using approved receipt and payment assumptions.
  10. Maintain loan, working‑capital limit, interest, EMI, covenant, charge, BG, LC, FD, lender NOC and banking registers.
  11. Prepare authorized banking and payroll‑funding transactions under maker‑checker control; never independently approve or release payment.
  12. Maintain HR‑approved payroll funding/reconciliation and insurance policy, renewal, claim and asset/site declaration records.
  13. Maintain and update the Daily Work Report (DWR) every working day with tasks, progress, results, pending actions, blockers and supporting evidence.
Daily Modus Operandi
  1. Collect ERP, site, stores, purchase, contractor and expense data.
  2. Validate progress and cost entries against source evidence; return unsupported data.
  3. Update dashboard, budget‑versus‑actual, productivity and material‑consumption records.
  4. Refresh committed cost, cost‑to‑complete and expected gross margin.
  5. Quantify schedule delay, downtime or abnormal consumption impact.
  6. Share exception alerts with named owners and track corrective action.
  7. Submit daily/weekly MIS and DWR; MIS is not assigned to the Project Coordinator.
  8. Reconcile billing, receipts, retention, advances, unbilled revenue and cash exposure.
  9. Prepare liquidity position and refresh the 13‑week cash forecast.
  10. Track loans, limits, EMI, BG/LC, covenants, insurance and payroll‑funding dates.
  11. Prepare approved bank/payroll transactions and route them to an independent checker and authorized signatory.
  12. Update DWR daily in the company‑provided software and share with the reporting manager.
Role Boundary

This role remains accountable for the outputs listed above even when work is delegated. During absence or vacancy, the named backup may perform essential transactions within documented authority. Technical approvals, commercial commitments, safety waivers and quality acceptance may be exercised only by a competent and authorized person. Handover must include current trackers, pending actions, access credentials under approved custody, documents and due dates.

Key Result Areas
  1. Project MIS and dashboard accuracy
  2. Budget versus actual control
  3. Cost‑to‑complete and margin forecasting
  4. Progress and productivity analytics
  5. Material consumption reconciliation
  6. Early‑warning and management reporting
  7. Revenue billing and cash exposure
  8. Treasury banking and borrowing control
  9. Payroll funding and insurance administration
  10. Daily Work Report completeness and accuracy
Key Performance Indicators
  1. MIS issued on time | Target: 100% daily dashboards; weekly report every Monday | Review: Daily / weekly / monthly
  2. Data accuracy | Target: >= 98% | Review: Monthly
  3. Project costs captured | Target: 100% | Review: Weekly
  4. Forecast accuracy | Target: >= 95% | Review: Monthly
  5. Material reconciliation variance | Target: <= 1% unexplained | Review: Monthly
  6. Major deviation alert | Target: Within 1 working day | Review: Per exception
  7. Billing and cash position reconciled | Target: 100% | Review: Weekly
  8. Daily bank position | Target: 100% by defined time | Review: Daily
  9. 13‑week cash forecast accuracy | Target: >= 90% | Review: Weekly
  10. Covenant BG insurance expiry alert | Target: At least 30 days or agreed lead time | Review: Per item
  11. Unauthorized bank release | Target: Zero | Review: Continuous
  12. Payroll funding failure | Target: Zero avoidable | Review: Monthly
  13. DWR updation and accuracy | Target: 100% of working days with a complete, accurate DWR | Review: Daily
KPI Measurement Method
  1. Items completed within the specified deadline / items due in the review period x 100; use timestamped records.
  2. Correct records/items ÷ records/items checked × 100.
  3. Compliant/on‑time items ÷ total applicable items × 100.
  4. 100 - absolute(frozen forecast - actual) / absolute(actual) x 100. If actual is zero, report absolute variance; no percentage.
  5. Unexplained material variance value ÷ material issued value × 100.
  6. Alert timestamp - time the deviation was identified; compare with one working day and retain the recipient record.
  7. Compliant/on‑time items ÷ total applicable items × 100.
  8. Daily bank‑position reports issued by the approved reporting time / reports due x 100; reconcile opening/closing balances.
  9. 100 - absolute(frozen forecast - actual) / absolute(actual) x 100. If actual is zero, report absolute variance; no percentage.
  10. Expiry date - alert date; verify at least 30 days or the approved item‑specific lead time.
  11. Count of verified incidents/exceptions during the review period.
  12. Count of verified incidents/exceptions during the review period.
  13. Working days with a complete and accurate DWR / working days due x 100; verify work evidence, progress, blockers and manager review.
KPI Weights
  1. MIS issued on time: 15%
  2. Data accuracy: 15%
  3. Project costs captured: 15%
  4. Forecast accuracy: 10%
  5. Material reconciliation variance: 10%
  6. Major deviation alert: 5%
  7. Billing and cash position reconciled: 10%
  8. Daily bank position: 5%
  9. 13‑week cash forecast accuracy: 5%
  10. Covenant BG insurance expiry alert: 5%
  11. Unauthorized bank release: 3%
  12. Payroll funding failure: 2%
  13. DWR upgradation and accuracy: 0%
Performance Framework

Review performance monthly using the specified KPI periods and evidence. Weights total 100% and express relative importance. Assess each KPI against its stated target and approved weight. Non‑Sales roles have no exceeds‑expectations band. Mandatory requirements remain applicable regardless of weight. Where no activity is due, record not applicable with the reason; do not record zero or invent achievement.

Target Rules

Project performance and cost report every Monday; dashboards daily. Data accuracy >=98%, cost forecast accuracy >=95%, unexplained material variance <=1%, major deviation alerts within one working day. Treasury support remains as assigned; independent authorization is required for payment release.

DWR is mandatory for every role: update every working day. It is monitored as a separate compliance requirement with no additional weight; existing KPI weights remain unchanged.

Total KPI Weight

100%

Approval Status

Approved targets retained; hierarchy revised

KPI Register — Detailed Records

MIS issued on time
Department: Operations
Target: 100% daily dashboards; weekly report every Monday
Review: Daily / weekly / monthly
Measurement method: Items completed within the specified deadline / items due in the review period x 100; use timestamped records.
Weight: 15%
Status: Approved targets retained; hierarchy revised

Data accuracy
Department: Operations
Target: >= 98%
Review: Monthly
Measurement method: Correct records/items ÷ records/items checked × 100.
Weight: 15%
Status: Approved targets retained; hierarchy revised

Project costs captured
Department: Operations
Target: 100%
Review: Weekly
Measurement method: Compliant/on‑time items ÷ total applicable items × 100.
Weight: 15%
Status: Approved targets retained; hierarchy revised

Forecast accuracy
Department: Operations
Target: >= 95%
Review: Monthly
Measurement method: 100 - absolute(frozen forecast - actual) / absolute(actual) x 100. If actual is zero, report absolute variance; no percentage.
Weight: 10%
Status: Approved targets retained; hierarchy revised

Material reconciliation variance
Department: Operations
Target: <= 1% unexplained
Review: Monthly
Measurement method: Unexplained material variance value ÷ material issued value × 100.
Weight: 10%
Status: Approved targets retained; hierarchy revised

Major deviation alert
Department: Operations
Target: Within 1 working day
Review: Per exception
Measurement method: Alert timestamp - time the deviation was identified; compare with one working day and retain the recipient record.
Weight: 5%
Status: Approved targets retained; hierarchy revised

Billing and cash position reconciled
Department: Operations
Target: 100%
Review: Weekly
Measurement method: Compliant/on‑time items ÷ total applicable items × 100.
Weight: 10%
Status: Approved targets retained; hierarchy revised

Daily bank position
Department: Operations
Target: 100% by defined time
Review: Daily
Measurement method: Daily bank‑position reports issued by the approved reporting time / reports due x 100; reconcile opening/closing balances.
Weight: 5%
Status: Approved targets retained; hierarchy revised

13‑week cash forecast accuracy
Department: Operations
Target: >= 90%
Review: Weekly
Measurement method: 100 - absolute(frozen forecast - actual) / absolute(actual) x 100. If actual is zero, report absolute variance; no percentage.
Weight: 5%
Status: Approved targets retained; hierarchy revised

Covenant BG insurance expiry alert
Department: Operations
Target: At least 30 days or agreed lead time
Review: Per item
Measurement method: Expiry date - alert date; verify at least 30 days or the approved item‑specific lead time.
Weight: 5%
Status: Approved targets retained; hierarchy revised

Unauthorized bank release
Department: Operations
Target: Zero
Review: Continuous
Measurement method: Count of verified incidents/exceptions during the review period.
Weight: 3%
Status: Approved targets retained; hierarchy revised

Payroll funding failure
Department: Operations
Target: Zero avoidable
Review: Monthly
Measurement method: Count of verified incidents/exceptions during the review period.
Weight: 2%
Status: Approved targets retained; hierarchy revised

DWR upgradation and accuracy
Department: Operations
Target: 100% of working days with a complete, accurate DWR
Review: Daily
Measurement method: Working days with a complete and accurate DWR / working days due x 100; verify work evidence, progress, blockers and manager review.
Weight: 0%
Status: Mandatory requirement; no separate weight

Requirements
  1. Graduate in Engineering, Finance, Commerce, Statistics or Operations.
  2. 3+ years in project MIS, costing, project controls or EPC analytics.
  3. Advanced Excel / Equivalent; ERP and Power BI/dashboard skills preferred.
  4. Understanding of BoM, inventory, project budgets, accruals and cost‑to‑complete.
  5. Strong analytical judgment, data validation, presentation and follow‑up discipline.
  6. Ability to challenge unsupported reporting objectively and confidentially.
  7. Treasury, banking portal, borrowing, BG/LC, payroll‑control and insurance‑record exposure.
  8. Strong confidentiality, cybersecurity awareness and maker‑checker discipline.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

PRCC Manager / Commercial Finance Manager
PRCC Manager / Commercial Finance Manager

Swid Process Technologies Pvt. Ltd. • Pune

On-site
INR 1,800,000 - 2,400,000
Chief Financial Officer
Chief Financial Officer

Swid Process Technologies Pvt. Ltd. • Pune

On-site
INR 6,000,000 - 9,000,000
Finance Manager and Controller
Finance Manager and Controller

Swid Process Technologies Pvt. Ltd. • Pune

On-site
INR 2,500,000 - 4,000,000
Head Projects
Head Projects

Swid Process Technologies Pvt. Ltd. • Pune

On-site
INR 4,000,000 - 7,000,000
Accounts Manager
Accounts Manager

Swid Process Technologies Pvt. Ltd. • Pune

On-site
INR 1,200,000 - 2,400,000
Payables Executive
Payables Executive

Swid Process Technologies Pvt. Ltd. • Pune

On-site
INR 450,000 - 700,000
Accounts Executive
Accounts Executive

Swid Process Technologies Pvt. Ltd. • Pune

On-site
INR 300,000 - 420,000
Chief Operating Officer
Chief Operating Officer

Swid Process Technologies Pvt. Ltd. • Pune

On-site
INR 6,000,000 - 7,500,000
Project Manager
Project Manager

Swid Process Technologies Pvt. Ltd. • Pune

On-site
INR 1,200,000 - 2,400,000
Head Supply Chain
Head Supply Chain

Swid Process Technologies Pvt. Ltd. • Pune

On-site
INR 3,500,000 - 5,500,000