Construction Data Analyst: Cost, WIP & Dashboards

Place Services Inc.

Woodstock (GA)

On-site

USD 65,000 - 90,000

Full time

4 days ago

Be an early applicant

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

Place Services Inc. is seeking a Data Analyst to transform construction project and financial data into actionable insights.

You will collaborate with Finance, Project Management, and Operations to deliver reports and dashboards that track job cost, WIP, and profitability, while ensuring data quality across ERP systems. The role requires familiarity with Acumatica, Procore, and Velixo or similar live reporting tools, plus strong SQL and BI skills.

Qualifications

Bachelor’s degree in Data Analytics, Information Systems, Finance, Accounting, or a related field.
2–4 years of experience in a data analyst, reporting analyst, or similar role; experience in the construction industry strongly preferred.
Proficiency in SQL for querying relational databases.
Experience with Acumatica ERP preferred; familiarity with construction accounting modules (job cost, project management, subcontracts) is a strong plus.
Experience with Procore or comparable construction project management platforms preferred.
Familiarity with Velixo, Jet Reports, or similar Excel-based live reporting tools connected to ERP systems is a plus.
Proficiency in BI tools such as Power BI or Tableau for dashboard development.
Advanced Excel skills including pivot tables, Power Query, and complex formulas.
Understanding of construction accounting concepts — job costing, WIP, AIA billing, cost codes — is highly desirable.
Strong attention to detail, analytical mindset, and ability to communicate findings clearly to non-technical stakeholders.
Experience with Python or R for data analysis is a plus.

Responsibilities

Design, develop, and maintain recurring and ad hoc reports and dashboards focused on job cost performance, WIP status, project profitability, subcontract tracking, and company-wide financial KPIs.
Extract, cleanse, and transform data from Acumatica (ERP), Procore (project management), and other operational systems to support integrated reporting.
Build and maintain Velixo reports (or equivalent Excel/cloud-based reporting tools) that pull live data from Acumatica for Finance and Accounting use.
Analyze project cost trends, variances between estimated and actual costs, and cost-to-complete projections to surface risks and opportunities.
Support the preparation of WIP schedules and month-end reporting packages in coordination with the accounting team.
Collaborate with Project Managers and field operations to understand data needs and translate them into reporting solutions.
Monitor data quality across source systems; identify discrepancies and work with system administrators to resolve issues.
Document report logic, data definitions, and business rules to build a reliable reporting knowledge base.
Assist with system integration testing and UAT for upgrades or new platform rollouts.
Respond to ad hoc data requests from Finance, Operations, and executive leadership with accuracy and timeliness.