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 lab's 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 MCDOT's 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 people's 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 MHRFeedback@maricopa.gov to initiate the interactive process.

Apply Now!