Data Analytics Intern - Engineering & SAP Operations

Description

Within our testing engineering department, we focus on the rigorous validation and performance testing of advanced hydraulic cartridge valves. We are currently modernizing our testing infrastructure to be faster and more scalable for production. In this internship role, you will get hands-on experience bridging the gap between complex engineering data and high-level strategic planning, ensuring our technical innovations are backed by solid data visualization and commercial viability.

As a Data Analyst Intern for the Manufacturing Engineering department, you will play a supporting dual role in our technical capabilities and our business strategy. Your primary project will be helping us take complex raw data generated by our hydraulic test stands and transforming it into clear, actionable visual dashboards for our engineering team.

In addition to engineering data, you will collaborate with department leadership to pull and format sales figures, project costs, and production volumes. You will use this commercial data to help build compelling business cases, assisting us in proving out the ROI of large-scale engineering projects (such as new automation) and forecasting future departmental needs.

Responsibilities

• Test Data Analysis & Visualization Support
• Assist in extracting, cleaning, and formatting high-volume test data generated by data acquisition software and hardware control systems.
• Help design and build automated dashboards to visually display key performance metrics of hydraulic valves, pass/fail rates (QPPM) (FPY), and overall equipment effectiveness (OEE).
• Work closely with current data analysis and engineering teams to understand how data flows from our newly structured testing programs to end-user reports.
• Learn to identify trends, anomalies, and performance bottlenecks in test results to help the team optimize testing throughput.
• Project Justification & Sales Analytics Support
• Support the gathering and formatting of historical sales data and future market projections to help evaluate the financial viability of proposed engineering projects.
• Collaborate on developing preliminary ROI (Return on Investment) models to justify capital expenditures for new testing equipment.
• Assist in creating clear, persuasive presentation slides that combine technical test results with commercial sales projections for upper management review.
• Track ongoing project costs against initial projections, highlighting any variances to department leadership.

Requirements

• Currently pursuing a Bachelor’s degree in Data Science, Business, Business Analytics, Finance, or a related field.
• Working knowledge of data analysis and data visualization concepts through coursework or academic projects.
• Proficiency in Microsoft Excel (e.g., PivotTables, VLOOKUPs, basic macros) and familiarity with visualization tools (e.g., Power BI, Tableau).
• Knowledge of SQL for data extraction.
• A strong interest in working within a manufacturing, engineering, or laboratory environment.
• High-level understanding of data structures generated by hardware/software integration platforms.
• Academic or project experience in building cost-benefit analyses, business models, or interpreting sales projections.
• Excellent communication skills, with a proven ability to translate complex information into easy-to-understand insights.
• A proactive, inquisitive mindset with a willingness to learn and tackle open-ended problems.
• Additional Information
• The pay range for this position is based on credit hours ranging from $19.00-$26.00