Data Analyst

About the Role

The Data Analyst supports the Data & Information Systems team by transforming construction project and financial data into meaningful, actionable insights. This role requires familiarity with job cost reporting, project financials, and the systems that drive them — including Acumatica, Procore, and Velixo or similar reporting platforms. The Data Analyst partners closely with Finance, Project Management, and Operations to deliver reliable reports and dashboards that support project performance tracking and business decision-making.

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.

Requirements

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

Success Metrics

• Accuracy, reliability, and timeliness of job cost and project performance reporting.
• Stakeholder satisfaction with reports, dashboards, and analytical deliverables.
• Data quality and issue resolution turnaround across Acumatica, Procore, and reporting outputs.
• Reduction of manual reporting effort through automation and improved workflows.