Data Analyst Intern

Hoffman Construction Co of America; Amarillo (TX); On-site; USD 26,000 - 33,000; Part time

Job summary

Hoffman Construction Co of America is seeking a Data Analyst Intern to help drive informed decisions by extracting insights from diverse data sources. You will build and maintain reporting tools in Excel, Smartsheet, and Power BI, ensure data quality, and assist in data science initiatives on construction projects.

The role is a part‑time internship (~20 hours/week during the school year) with opportunities to learn data strategy, ML concepts, and data visualization in a fast‑paced environment.

Qualifications

• High School diploma or GED required.
• Pursuing a bachelor’s degree in Data Science, Mathematics, Statistics, Computer Science, Engineering, or equivalent.
• Experience with construction data preferred.

Responsibilities

• Extract, transform, and load data from diverse data sources for analysis and reporting.
• Create and maintain reports and dashboards in Power BI.
• Assist data analyst on construction projects and data science initiatives.

Skills

Power BI

Python

Smartsheet

Excel

Data analysis

Data visualization

Machine learning

Procore

Matplotlib

Seaborn

Teamwork

Communication

Education

High School diploma or GED

Pursuing a bachelor’s degree in Data Science/Math/CS/Engineering or related field

Tools

Procore

Smartsheet

Power BI

Python

Job description

POSITION SUMMARY

The Data Analyst Intern will help to drive informed decision‑making by extracting insights from diverse data sources. The intern may assist the project team or departments by developing and maintaining reporting and analytical tools (Excel, Smartsheet, Power BI), cleaning data and ensuring data quality, ensuring data privacy and security, data visualization and reporting, and other duties as assigned. The Data Analyst Intern will also help prepare construction data for data science initiatives. The work commitment during the school year is roughly 20 hours per week. You will work with your team to come up with a work schedule that will allow you to achieve 20 hours per week of work time during your school year.

Salary Range

$25.13 - $31.50 per hour (plus assignment adjustment, if applicable)

PRINCIPAL RESPONSIBILITIES

• Extract, transform, and load data from diverse data sources for data analysis and reporting uses.
• Check for data quality and clean data, if necessary.
• Help to maintain reports and dashboards for Department Managers and Project Managers.
• Create reports and dashboards in Power BI.
• Assist the data analyst on a construction project with duties as assigned.
• Help to mine historical construction data and improve data quality where needed.
• Assist in data strategy efforts, including updating data flowcharts and creating data swim lanes.
• Assist in data science efforts such as identifying current construction activities where machine learning or Python automation might be useful, sourcing data for data science activities, preparing data for data science activities, training, and testing machine learning algorithms, and building data science workflows.
• Host a meeting with the objective of teaching the Data team something new.
• Write and publish meeting minutes. Follow up on meeting action items.
• Complete data course(s) in DataCamp, Enterprise DNA, and/or LinkedIn Learning.

QUALIFICATIONS

Position Related Skills

• Experience in Windows and Microsoft Office 365 (Excel, Word, Outlook, Power Point and Teams), and have a general understanding of working within a computer network.
• Knowledge of, or ability to quickly learn, project management software such as Procore or Smartsheet.
• Experience with data analysis tools such as MS Power BI and Python.
• Experience with data reporting tools such as MS Power BI, Matplotlib, and Seaborn.
• Knowledge of, or experience with, Python programming and machine learning algorithms.
• Be willing to travel for up to a week to a project site that may be located outside of the Pacific Northwest.
• Demonstrate an understanding of construction and/or a willingness to learn in a fast‑paced, on the job environment.
• Highly developed visual observation and interpretation skills.
• Ability to work well and maintain a cooperative attitude through high‑pressure situations.
• Excellent time‑management skills and ability to multi‑task and prioritize work while frequently interrupted by phone calls and questions on work in progress.
• Excellent written and oral communication skills with an ability to develop strong interpersonal relationships.
• Ability to work closely with a variety of trade and craft people in a field work situation. Patience and professionalism are essential.
• Must be a strong team player with the ability to collaborate with various personnel within and across departments and at all levels of leadership.

Professional Experience and Education

• High School diploma or GED required.
• Pursuing a bachelor’s degree in Data Science, Mathematics, Statistics, Computer Science, Engineering, or equivalent degree and/or equivalent field work experience preferred.
• Education background or experience in methods of construction preferred.

Physical and Mental Requirements

• Workday is a combination of being stationary and moving about the work location. Must be able to spend equal amounts of time in a stationary position in an office environment and moving about the construction site.
• Must be able to ascend and descend ladders, scaffolds, and stairs.Constantly operates a computer and other office productivity machinery, such as a calculator, copy machine, and computer printer.Specific vision abilities required include close vision, depth perception and the ability to adjust focus in an outdoor environment. The worker is required to have close visual acuity to perform an activity such as: preparing and analyzing data and figures; transcribing; viewing a computer terminal; reading printed and digital documentsMust be able to work in proximity to loud equipment more than 50% of the time. Must be able to wear hearing protection as necessary. Often required to communicate with customers and coworkers in an office setting and on the job site.Ability to communicate laws, ordinances, plans, regulations, protocols, directives, and standard operating procedures related to project scope in English.
• Must use independent judgment, organizational, and problem‑solving skills to determine the best method to accomplish desired results.