The Construction Data Analyst II supports the Operations team at METCON INC by delivering advanced analysis of construction project data, operational performance, and financial outcomes. This role independently manages complex reporting, supports joint venture pay applications, and develops operational KPIs to help guide timely decisions across the assigned division.
Key Responsibilities
- Collect, validate, reconcile, and manage project data from Procore, scheduling tools, financial platforms, and other operational systems.
- Contribute to operational and financial performance review for every project in the assigned division.
- Analyze budgets, actual costs, commitments, billings, forecasts, and profitability to identify variances, trends, risks, and improvement opportunities.
- Evaluate schedule performance and productivity with project teams and prepare review reports outlining results, concerns, and recommended actions.
- Collaborate with Project Managers, Superintendents, Accounting, and Operations leadership to investigate discrepancies and improve performance.
- Capture historical project data to support benchmarking, estimating, forecasting, and lessons learned.
- Independently prepare and coordinate pay applications for all joint venture projects within scope of responsibility.
- Review schedules of values, completed work, approved change orders, retainage, and supporting documentation to confirm accuracy and completeness.
- Reconcile billing information with project and financial records prior to submission.
- Coordinate required reviews and approvals with project teams, Accounting, and joint venture partners.
- Track deadlines, revisions, approval status, and outstanding billing items; resolve discrepancies and support payment inquiries and financial reviews.
- Develop, maintain, and refine operational KPIs to provide visibility into project and divisional performance.
- Create dashboards and reports that clearly communicate operational and financial information to project teams and leadership.
- Establish consistent metric definitions, data sources, and reporting methods; monitor data quality and address inconsistencies.
- Develop KPI frameworks and reporting tools that can serve as templates for other business units.
- Present analytical findings and practical recommendations to support timely, informed decisions.
- Independently identify and implement improvements to analytical tools, reporting processes, and operational workflows within established authority.
- Anticipate leadership information needs and provide analysis supporting business unit priorities and strategic planning.
- Streamline recurring reporting and automate manual processes where practical.
- Track recommended actions and communicate progress to Operations leadership.
- Document reporting procedures and guide employees using dashboards, KPIs, and analytical tools.
- Support cross-divisional initiatives, special projects, and other duties as assigned.
Required Qualifications
- Bachelor’s degree in construction management, Data Analytics, Engineering, Finance, Accounting, or a related field (preferred as listed).
- Two or more years of relevant experience in construction data analysis, project controls, financial reporting, or construction operations.
- Ability to independently manage complex analytical assignments and deliver accurate, timely results.
- Advanced Excel skills and strong analytical and problem-solving abilities.
- Working knowledge of construction budgets, job costing, forecasting, progress billing, and project performance measures.
- Ability to exercise sound judgment, maintain confidentiality, and collaborate across departments.
- Strong attention to detail, organization, and written and verbal communication skills.
Preferred Experience
- Experience preparing pay applications and supporting joint venture reporting.
- Experience developing dashboards, KPIs, or reporting improvements.
- Data integration and reporting automation tools experience.
Technology Stack
- Procore, Bluebeam
- Power BI, Tableau
- P6, Microsoft Project
- Microsoft Excel, Microsoft Office
- Construction accounting and financial reporting platforms
Working Conditions
- Office environment with occasional job site visits.
- Travel is required.
- Flexible work hours as needed to meet reporting, project review, and billing deadlines.
- Valid driver’s license required.
- Must follow applicable safety requirements when visiting job sites.
Physical Requirements
- Ability to sit and work at a computer for extended periods.
- Ability to walk active job sites occasionally, including uneven terrain.
- Ability to review and interpret digital reports, spreadsheets, and project data.
- Ability to perform essential job functions with or without reasonable accommodation.
Location and Experience
- Location: Raleigh, NC (onsite)
- Minimum experience: 2 years