Data Analyst

Job Summary

The Data Analyst is responsible for analyzing, modeling, and interpreting complex datasets to support decision‑making across the civil engineering organization. This role focuses on leveraging data from Deltek Vision/Vantagepoint, the Microsoft technology stack, and Power BI to develop predictive models, dashboards, and analytical insights that enhance project performance, financial forecasting, resource planning, and operational efficiency. In addition to supporting project, financial, and operational analytics, this role also provides analytical support for Human Resources initiatives, including workforce reporting, talent metrics, and HR data insights that inform organizational planning and employee experience strategies.

In this role, an employee will be expected to develop and demonstrate proficiency regarding the essential functions of the job listed below.

• Extract, analyze, and model data from Deltek Vision/Vantagepoint, Microsoft SQL Server, and other enterprise systems.
• Design, build, and maintain Power BI dashboards and data visualizations that deliver actionable insights to project managers, financial teams, and leadership.
• Develop predictive models and statistical analyses to support forecasting, project risk identification, and operational decision‑making.
• Create and maintain scalable data pipelines and ETL processes using Microsoft tools such as Power Query, SQL, Dataverse, and SharePoint integrations.
• Ensure data accuracy, integrity, and consistency through rigorous validation and quality assurance processes.
• Collaborate cross‑functionally with engineering, project management, finance, Human Resources, and IT teams to understand business needs and develop tailored analytical solutions.
• Communicate complex analytical results clearly to non‑technical audiences through visualizations, summaries, and presentations.
• Support data governance, security best practices, and standardization of KPIs and reporting frameworks.
• Research and recommend emerging technologies or analytical techniques to advance the firm's data capabilities.
• Document analytical methods, data structures, dashboards, and models following internal documentation standards.
• Partner with the Human Resources team to develop HR dashboards and metrics, recurring reporting and analytics related to workforce trends, headcount, turnover, retention, compensation insights, and talent planning, ensuring data quality and actionable interpretation of HR data.
• Serve as a subject‑matter expert for HRIS data structure, reporting, and integrations.

• Proficient in Power BI, including DAX, Power Query, data modeling, and advanced visualization design.
• Strong experience with SQL, including queries, stored procedures, and data modeling techniques.
• Understanding of Deltek Vision/Vantagepoint data structures, reporting tables, and integration patterns.
• Proficiency in statistical analysis, predictive modeling, or machine learning techniques.
• Experience with Python or R for data analysis is preferred.
• Familiarity with the Microsoft ecosystem:
  Excel, SharePoint, Teams, Power Automate, Azure‑based tools.
• Strong analytical and problem‑solving skills with the ability to approach technical and business challenges methodically.
• Ability to translate business requirements into technical solutions and data‑driven recommendations.
• Excellent communication skills (verbal and written), including the ability to present findings to varied audiences.
• Ability to work independently and collaboratively in a team‑oriented environment.

• Bachelor's Degree in Data Science, Statistics, Computer Science, Engineering, Information Systems, or related field required.
• Master's Degree preferred.

• 3–7 years of experience in data analytics or data science, preferably within the AEC (Architecture, Engineering & Construction) industry.
• Experience supporting enterprise analytics using Deltek Vision/Vantagepoint strongly preferred.
• Demonstrated experience with Power BI dashboard development and data modeling.
• Experience working with SQL databases and building data pipelines or ETL processes.
• Familiarity with predictive analytics,…