College Intern - IT (Data Analyst)

Stevens Transport•Dallas, TX

2d•Onsite

About The Position

The Data Analyst – Summer Intern supports data analysis and reporting initiatives related to safety and operational performance within the transportation environment. This role focuses on assisting with data preparation, validation, analysis, and reporting under the guidance of experienced analysts and engineers. The internship is designed to provide hands‑on exposure to how data is used to identify trends, support process improvement, and inform decision‑making. The role emphasizes learning, execution, and contribution to defined analytical tasks, rather than independent ownership of safety strategy or regulatory interpretation.

Requirements

Demonstrated foundational knowledge in data analysis, analytics, computer science, information systems, statistics, mathematics, engineering, or related quantitative disciplines through education, training, or practical experience.
Exposure to data analysis concepts such as datasets, tables, metrics, and basic analysis techniques.
Basic proficiency with Microsoft Excel and an interest in learning SQL and analytical tools.
Strong attention to detail and interest in data accuracy and quality.
Willingness to learn, accept feedback, and work within established processes.
Clear written and verbal communication skills suitable for an early‑career or developmental role.
Ability to commit to a full‑time schedule during the defined internship period.

Nice To Haves

Exposure through coursework, training, certifications, or projects to SQL, Power BI, Tableau, Microsoft Fabric, or similar tools.
Experience with academic, professional, or personal projects involving data analysis, dashboards, or reporting.
Familiarity with basic programming or scripting concepts (SQL, Python, or similar).
Interest in pursuing a career path in data analytics, business intelligence, or related disciplines.

Responsibilities

Assist with extracting, cleaning, and preparing data from multiple sources to support reporting and analytical needs.
Support analysis of structured datasets to identify trends, patterns, and anomalies under guidance.
Help validate data accuracy and completeness prior to downstream reporting or analytics use.
Gain exposure to structured data workflows, including raw, validated, and business‑ready datasets.
Assist in organizing and documenting datasets as they move through defined data layers.
Support basic data transformations aligned with established data modeling and quality standards.
Assist with building and maintaining reporting outputs using approved analytics tools.
Support routine monitoring of data processes and flag potential issues for review.
Gain exposure to version control and deployment concepts as applicable to analytics workflows.
Write and modify SQL queries to support reporting and analytical tasks under supervision.
Learn and apply foundational SQL concepts to retrieve and structure data.
Assist with documentation of query logic and data definitions.
Assist with the development and maintenance of reports, dashboards, and analytical outputs.
Help translate analytical findings into clear summaries for technical and non‑technical stakeholders.
Ensure reporting aligns with defined metrics and documented business requirements.
Document analytical processes, data definitions, and transformation logic.
Collaborate with IT and business teams on data‑related projects and ad‑hoc requests.
Participate in meetings, training sessions, and project reviews to build technical and professional skills.