Materials Technology Intern

Posting Date

Application Deadline

Pay Range

Job Type

Department

About the Position

The Materials Technology Intern is a summer internship opportunity to work within the Materials Testing Laboratory at the Maricopa County Department of Transportation (MCDOT). The intern will support the labs efforts to digitize historical testing records organize and standardize laboratory data and develop reporting tools to better understand and communicate laboratory performance and accomplishments. The intern will have the opportunity to visit MCDOTs various Divisions including Roadway Maintenance Engineering Construction and Materials Transportation Systems Management & Operations and Strategic Communications and Outreach and learn about various subject areas.

By the conclusion of the internship the intern will have gained hands-on experience in data management quality control monitoring and performance reporting within a public-sector laboratory environment and will have used tangible tools to support data-driven decision-making and communication with leadership.

About Us

We value your time. The time with your family. The time you spend on the road. And the time you spend making a difference. At the Maricopa County Department of Transportation (MCDOT) we provide connections that improve peoples lives. By combining innovative technologies with the vast talent of our employees we plan for future needs and operate a transportation system with the community in mind. Are you interested in contributing to the community in which you work live and play Then join our team and help us build connections.

Proud to Offer

• Work with a greater purpose

• Opportunities to learn about maintaining work-life balance in a professional setting

• Providing valuable insight into public sector construction

• Hands-on experience in a materials lab

• Learn more at Work With Us Maricopa County AZ

We Require

• Be currently enrolled as a senior in an undergraduate program in Engineering Data Science Statistics Computer Science Mathematics or a closely related field. Graduate students in a related field may also be considered

• Completion of coursework in statistics quality control data analysis or a related subject

Other Requirements

Strong attention to detail and accuracy when working with large datasets and historical records

We Also Value

• Technical skills:

  • Advanced Excel proficiency including complex formulas structured tables data validation conditional formatting and automated or repeatable workflows (beyond basic data entry and pivot tables)

  • Experience cleaning and organizing datasets from multiple sources (e.g. historical records Excel files or PDFs)

  • Hands-on experience designing and building Power BI dashboards

  • Experience with Python or a similar programming language for data processing or analysis

• Pursuing a degree in Civil Engineering or having prior experience with construction materials testing

Job Contributions

• Complete the entry of historical laboratory testing records from printed log sheets into a centralized electronic database ensuring accuracy and completeness

• Clean organize and standardize laboratory data including historical and current records to ensure consistent formats naming conventions and data quality

• Extract and compile laboratory testing data from electronic sources such as Excel files and PDFs using efficient repeatable methods

• Develop Excel/Power BI-based dashboards and summary reports to track laboratory testing performance by test type project and overall

• Create and update control charts in Excel to monitor laboratory testing results and quality control trends

• Document data processes workflows and assumptions including data sources cleaning steps and dashboard refresh procedures

• Complete micro-learning sessions with all MCDOT Divisions including those that provide support functions for MCDOT projects during a one-week rotation

Working Conditions

• This position requires the employee to be in the office/field or customer-facing for all hours worked

• Exerting up to 20 pounds occasionally 10 pounds frequently or negligible amounts constantly or requires walking or standing to a significant degree

• Position is typically office or administrative work and is not substantially exposed to adverse environmental conditions

Machines Tools Equipment Software and Hardware

Microsoft 365 Advanced Excel and Power BI

Protective Equipment Required

Construction PPE (boots gloves hard hat glasses as needed project specific

Selection Procedure

• Consideration will only be given to candidates who submit online applications

• Candidates will be contacted primarily through email and their Workday online application profile

• Must pass a pre-employment background and/or fingerprint investigation as required by statute or policy including drug and alcohol testing requirements for positions designated as safety-sensitive

Maricopa County is an equal opportunity employer and is committed to providing equal employment opportunities to all applicants. If you require a reasonable accommodation during the application process or to perform the essential functions of the position under the Americans with Disabilities Act (ADA) please contact to initiate the interactive process.

Apply Now!