Data Analyst

Hoffman Construction Company is hiring an in-person Data Analyst to support construction analytics that feed estimating, operational performance, benchmarking, and strategic decision-making. The role focuses on building and maintaining a centralized historical project database, turning project data into dashboards, quality controls, and automated analytics. You will work closely with the Data Manager and partner with internal teams to align reporting needs with company and project priorities.

Position details

• Location: Tempe, AZ (onsite)
• Reports to: Data Manager
• Salary: USD 71,000 - 87,000 per year (DOE)
• Experience: 3+ years

What you’ll do

• Partner with self-perform companies to design, build, and maintain a centralized historical project database.
• Organize historical self-perform data, including unit rates, labor rates, cost of work, production metrics, and related measures.
• Analyze historical project performance to improve the accuracy of future cost estimates.
• Help develop productivity, cost, and performance benchmarks by market sector and self-perform discipline.
• Collaborate with affiliate company team members to align analytic and reporting needs with company and project priorities.
• Create and continuously enhance reports and dashboards using Excel, Smartsheet, Power BI, or other approved analytics tools.
• Deliver insights on productivity, labor utilization, cost performance, and profitability.
• Identify opportunities to automate data collection and reporting to keep data updates accurate and timely.
• Build quality-control processes, including automated validation checks.
• Validate and reconcile project information from multiple source systems; identify and correct discrepancies, omissions, and inconsistencies.
• Participate in creating semantic models for reporting and AI work.
• Support continuous enhancement of data analytics tools that promote predictability and operational efficiencies.
• Collaborate with data science and technology teams on advanced analytical efforts, including potential AI-enabled estimating and forecasting initiatives.
• Act as a subject matter expert for data, reporting, and analytics tools, staying current with technological advancements and industry trends.
• Communicate findings clearly to technical and non-technical audiences, and educate cross-functional teams on effective tool usage aligned to project goals.
• Foster cross-department collaboration to develop data products and tools, define success metrics, and present outcomes that support actionable insights and strategic decision-making.

Requirements

• Education: Bachelor’s degree in Information Systems, Data Analytics, Data Science, Information Science/Management, or a related field, or equivalent work experience.
• Experience: Three (3) + years of professional data analysis and BI reporting experience.
• Preferred: Statistical analysis and data science (ML).
• Proficiency with Power BI, Excel, Smartsheet, and other data analytic tools, with an aptitude for learning new tools.
• Proficiency in data analysis skills including data cleansing and preparation, data visualization, mathematical and statistical calculation, and dashboarding/reporting.
• Proficiency with data (semantic) modeling techniques.
• Proficiency in DAX and Smartsheet programming languages.
• Practical experience with statistical analysis using tools such as Excel, Power BI, R, or Python.
• Python experience, including creating automations, especially within Power BI.
• Knowledge and experience with Generative AI tools such as ChatGPT, Claude, MS Copilot, or similar.
• Ability to work with disparate data sources to support operational efficiencies and data-driven decisions.
• Ability to communicate complex information across data-literate audiences.
• Ability to solve problems independently and cooperatively with teammates.
• Technical writing experience, including queries, reports, and presentations.
• Knowledge of Microsoft Fabric and the medallion structure of data flows is beneficial.
• Knowledge of basic software development practices (Development, Testing, Production environments) is beneficial.
• Knowledge of data security concepts and processes is beneficial.
• Previous construction industry experience is beneficial, as is familiarity with construction management software such as Procore.

Technologies

• Power BI, Excel, Smartsheet
• DAX
• R, Python
• ChatGPT, Claude, MS Copilot
• Microsoft Fabric
• Generative A.I.

Physical and mental requirements

• Workday: Combination of sitting/walking and standing.
• Legs: Must be able to climb stairs (about 5% of the day).
• Hands/Arms: Constant use of hands/fingers for mouse/keyboard/computer use.
• Vision: Visual acuity in near, mid, and far-range vision, including color vision, peripheral vision, depth perception, and hand/eye coordination.
• Hearing: Ability to hear conversational levels in person, over the telephone and radio, and hear alarms on equipment.
• Speech: Ability to be heard in person, speak in front of groups, and be understood over the telephone and radio.
• Lift/Carry: Up to 50 lb computer/drawings (minimal).
• Bending/Twisting: Minimal.
• Kneeling/Crouching/Crawling: Minimal.
• Performance: Constant mental alertness, accuracy, and attention to detail; ability to work independently, make decisions, and follow through on assignments.
• Communication: Strong organizational and computer skills; elevated competency to read/write/speak English, interpret construction-related documentation, and communicate with coworkers.