Data Analyst

Hoffman Construction Company; Boise (ID); On-site; USD 65,000 - 100,000; Full time

Job summary

Hoffman Construction Company is seeking a motivated Data Analyst to join the expanding Data team. You will gather, analyze, and translate complex data from multiple sources into clear, actionable insights to support project outcomes.

You will develop reports and dashboards using Power BI, Smartsheet, and Excel, and apply sanctioned AI tools to assist DAX coding. The role reports to the Data Manager and requires strong organizational and communication skills, attention to detail, and the ability

Qualifications

• Proficient in Power BI, Excel, Smartsheet and other data analytic tools.
• Strong data analysis skills: cleansing, visualization, stats, dashboarding and reporting.
• Proficient in data (semantic) modeling techniques.
• Experience with DAX and Smartsheet programming languages.
• Statistical analysis experience using Excel, Power BI, R or Python.
• Python programming for automations, especially with Power BI.
• Knowledge of Generative AI tools (ChatGPT, Claude, Copilot).
• Ability to synthesize disparate data sources to drive operational efficiencies.
• Ability to communicate complex information to varied audiences.
• Technical writing experience for queries, reports, presentations.
• Knowledge of Microsoft Fabric and data flow architectures is beneficial.
• Understanding of basic software development environments (Dev/Test/Prod).
• Awareness of data security concepts is beneficial.
• Construction industry experience is beneficial.
• Familiarity with Procore is beneficial.

Responsibilities

• Collaborate with project teams to align analytic needs with project priorities and data sources.
• Develop and enhance reports and dashboards using Power BI, Smartsheet, Excel and related tools.
• Create data analytics tools to promote predictability and efficiency for projects and corporate entities.
• Build semantic models to support reporting and AI initiatives.
• Aggregate and analyze data from diverse sources to deliver actionable insights.
• Identify data inconsistencies, determine root causes, and rectify issues.
• Deliver weekly and monthly reports to executives and stakeholders.
• Serve as data, reporting and analytics subject matter expert and stay current with trends.
• Educate cross-functional teams on using analytics tools to meet project goals.
• Lead cross-department collaboration to develop data products and define success metrics.
• Automate data collection and reporting processes for timely updates.

Skills

Power BI

Smartsheet

Excel

Data cleansing

Data visualization

Semantic modeling

DAX

Python automation

AI tooling

Communication

Technical writing

Microsoft Fabric

Procore familiarity

Education

Bachelor's degree in Information Systems/Data Analytics/Data Science/Information Science/Management

Tools

Power BI

Excel

Smartsheet

Job description

Position Summary: Hoffman Construction is looking for a motivated and growth-oriented Data Analyst to join our expanding Data team. In this role, you will play a key part in enabling data-driven decisions by gathering, analyzing, and translating complex data from multiple sources into clear, actionable insights that support project outcomes. You will work closely with project teams to develop meaningful reports and visualizations, while ensuring data accuracy and integrity through effective collection and cleansing practices.

The ideal candidate is comfortable creating reports and dashboards using Power BI, Smartsheet, and Excel, and using sanctioned AI tools to facilitate DAX coding. This candidate will have strong data skills and be comfortable automating workflows. Reporting to the Data Manager, this position requires strong organizational and communication skills, exceptional attention to detail, and the ability to manage priorities and meet deadlines in a fast-paced, collaborative environment.

This is an in-person position at the main office or on the project jobsite.

Compensation Range: $65,000 - $100,000 DOE + Incentives

Essential Responsibilities:

• Collaborate with project team members to align analytic and reporting needs with project priorities, leveraging data from multiple platforms.
• Participate in the creation and continuous enhancement of reports and dashboards using Power BI, Smartsheet, Excel, or other data reporting tools.
• Participate in the creation and continuous enhancement of data analytics tools to promote predictability and operational efficiencies for project teams and corporate entities.
• Participate in the creation of semantic models for use in reporting and AI work.
• Aggregate and analyze data from diverse sources, ensuring comprehensive insights and synthesis by employing innovative data visualization techniques.
• Detect inconsistencies and incorrect data, determine root cause, and rectify issues.
• Oversee the creation and delivery of weekly and monthly reports to internal and external stakeholders, including executives and client representatives.
• Serve as the subject matter expert on data, reporting, and analytics tools, keeping abreast of technological advancements and industry trends.
• Educate and guide cross-functional teams on leveraging analytics and reporting tools effectively, aligning with project goals.
• Foster collaboration across departments to develop data products and tools, defining success metrics and delivering presentations that drive actionable insights and support strategic decision-making.
• Determine ways to automate data collection and reporting processes to ensure accurate and timely data updates.

Qualifications:

Position Related Skills

• Proficient using Power BI, Excel, Smartsheet, and other data analytic tools, with an aptitude for learning new tools.
• Proficient in data analysis skills such as data cleansing and preparation, data visualization, mathematical and statistical calculation, dashboarding and reporting.
• Proficient with data (semantic) modeling techniques required.
• Proficient in both DAX and Smartsheet programming languages.
• Practical experience in statistical analysis using statistical packages, including Excel, Power BI, R, or Python.
• Experience with Python programming and creating automations, especially within Power BI.
• Knowledge of and experience with Generative A.I. tools such as ChatGPT, Claude, MS Copilot, or similar.
• Ability to digest disparate data sources and decipher how they can be best used to create operational efficiencies and support data-driven decisions.
• Ability to communicate complex information to a range of data-literate audiences.
• Ability to solve problems independently and cooperatively with other team members.
• Proficient technical writing experience in relevant areas, including queries, reports, and presentations.
• Knowledge of Microsoft Fabric and the medallion structure of data flows is beneficial.
• Knowledge of basic software development practices such as Development, Testing, and Production environments is beneficial.
• Knowledge of data security concepts and processes is beneficial.
• Previous experience in the construction industry is beneficial.
• Familiarity with construction management software, such as Procore, is beneficial.

Professional Experience and Education

• Bachelor's degree in Information Systems, Data Analytics, Data Science, Information Science/Management, or a related field of study, or equivalent work experience required.
• Five (5) + years of professional data analysis and BI reporting experience, including statistical analysis and data science (ML) preferred.

Competencies:

Action-oriented

• Taking on new opportunities and tough challenges with a sense of urgency, high energy, and enthusiasm
  • Readily takes action on challenges
  • Identifies and seizes new opportunities
  • Displays a can-do attitude in good and bad times
  • Steps up to handle tough issues

Manages ambiguity

• Operating effectively, even when things are not certain or the way forward is not clear
  • Deals comfortably with the uncertainty of change
  • Effectively handles risk
  • Can decide and act without the total picture
  • Is calm and productive, even when things are ambiguous
  • Deals constructively with problems that do not have a clear solution

Collaborates

• Building partnerships and working collaboratively with others to meet shared objectives
  • Works cooperatively with others across the organization to achieve shared objectives
  • Represents own interests while being fair to others and their areas
  • Partners with others to get work done

Communicates effectively

• Developing and delivering multi-mode communications that convey a clear understanding of the unique needs of different audiences
  • Is effective in a variety of communication settings: one-on-one, small and large groups, or among diverse styles and position levels
  • Attentively listens to others
  • Adjusts to fit the audience and the message
  • Provides timely and helpful information to others across the organization
  • Encourages the open expression of diverse ideas and opinions

Manages complexity

• Making sense of complex, high quantity, and sometimes contradictory information to effectively solve problems
  • Asks the right questions to accurately analyze situations
  • Acquires data from multiple and diverse sources when solving problems
  • Uncovers root causes to difficult problems

Physical and Mental Requirements:

• Standing/Walking/Sitting: Workday is a combination of sitting/walking and standing.
• Legs: Must be able to climb stairs - 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. Color vision, peripheral vision, depth perception, hand/eye coordination.
• Hearing: Sufficient to hear conversational levels in person and over the telephone andradio; sufficient to hear alarms on equipment.
• Speech: Sufficient to make oneself heard in person, speak in front of groups, and be understood over the telephone and radio.
• Lift/Carry: Up to 50lb computer/drawings- minimal.
• Bending/Twisting: Minimal.
• Kneeling/Crouching/Crawling: Minimal.
• Constant mental alertness, accuracy, and attention to detail required.
• Must be able to work independently, make decisions, and follow through on all assignments.
• Must use creativity, independent judgment, and organizational and problem-solving skills to determine the best method to accomplish desired results.
• Must be able to plan and organize work.
• Must possess strong organizational and computer use skills and have an elevated level of competency to read/write/speak English, interpret construction related documentation and communicate with coworkers.