Data Analytics Intern: Power BI & Python (Construction)

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

Benefits offered by this job

Competitive pay and advancement

Ongoing professional training and dev

Health insurance benefits

Job summary

Hoffman Construction is seeking a Data Analyst Intern to drive informed decision-making by extracting insights from diverse data sources. You will develop and maintain reporting tools, clean and prepare data, and create Power BI dashboards for project teams.

The role involves data wrangling, data privacy, and collaboration with data science initiatives during a 20-hour weekly schedule during the school year.

Qualifications

• Experience with Windows and Microsoft Office 365 (Excel, Word, Outlook, Power Point and Teams).
• Ability to 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 Python programming and machine learning algorithms.

Responsibilities

• Extract, transform, and load data from diverse data sources for analysis and reporting.
• Check data quality and clean data as needed.
• Maintain reports and dashboards for Department and Project Managers.
• Create reports and dashboards in Power BI.
• Assist data analyst on construction project with duties as assigned.
• Mine historical construction data and improve data quality.
• Assist in data strategy efforts, including updating data flowcharts and data swim lanes.
• Assist in data science efforts, including identifying activities where ML or Python automation is useful.
• Host a meeting to teach the Data team something new.
• Publish meeting minutes and follow up on action items.
• Complete data courses in DataCamp, Enterprise DNA, and LinkedIn Learning.

Skills

Data analysis tools

Power BI

Python

Excel

Office 365 apps

Education

High School diploma or GED

Pursuing a bachelor's degree in Data Science/Math/CS/Engineering

Tools

Procore

Smartsheet

Job description

Hoffman Construction is seeking a Data Analyst Intern to drive informed decision-making by extracting insights from diverse data sources. You will develop and maintain reporting tools, clean and prepare data, and create Power BI dashboards for project teams.

The role involves data wrangling, data privacy, and collaboration with data science initiatives during a 20-hour weekly schedule during the school year.