Data Analytics Intern: Power BI & Python (Part-Time)

Hoffman Construction Company; Claude (TX); On-site; USD 34,000 - 43,000; Part time

Job summary

Hoffman Construction Company seeks a Data Analyst Intern for the school year in Texas Panhandle. This part-time, in-person role supports 20 hours per week and focuses on extracting insights from diverse data sources, maintaining reports, and creating dashboards in Power BI.

Learn data privacy, cleaning, visualization, and collaborate with project teams on construction data initiatives. You will assist in data strategy, update data flowcharts, and potentially explore machine learning or Python

Qualifications

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

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.

Skills

Excel

Data visualization

Python

Power BI

Data cleaning

Microsoft Office 365

Team collaboration

Tools

Smartsheet

Procore

Job description

Hoffman Construction Company seeks a Data Analyst Intern for the school year in Texas Panhandle. This part-time, in-person role supports 20 hours per week and focuses on extracting insights from diverse data sources, maintaining reports, and creating dashboards in Power BI.

Learn data privacy, cleaning, visualization, and collaborate with project teams on construction data initiatives. You will assist in data strategy, update data flowcharts, and potentially explore machine learning or Python