Find Jobs
Find Jobs Near You – Available Work in Your Location
Data and Analytics Intern (Summer 2027)
Career Insights for Data Analyst
See where this job fits in the broader career landscape. Knowing your career path helps you see what's possible from here.
Scorecard
Based on Ohio data
Review key factors to help you decide if this role fits your goals. How is this calculated?
What they do
A Data Analyst develops computer programs to analyze large customer information databases for companies and organizations. Analyzes data to identify patterns and provide information relevant to a particular business, industry or field; analysis may be used for marketing, or to detect fraud in financial transactions, or for research. Develops computer programs to protect confidential customer information.
$79,165 / year median in Ohio
+12% projected growth
Job Description
Position Summary We are seeking a proactive and detail-oriented Data and Analytics Intern to support the development of scalable data structures, reporting solutions, and data-intake processes within a growing Fortune 500 organization. The intern will work with global operations data, help transform information from multiple sources into analysis-ready datasets, and support reporting for key performance indicators. This role provides hands-on experience in data engineering, business intelligence, operations management, and process improvement. The ideal candidate is organized, adaptable, technically curious, and capable of solving problems with increasing independence. Responsibilities Design and build standardized data structures and intake processes that support future data-lake, automation, and analytics capabilities. Use Python, SQL, and Excel to collect, clean, transform, validate, and consolidate data from multiple business sources. Analyze operational KPIs and SIOP-related metrics to identify trends, data-quality issues, risks, and opportunities for improvement. Develop or enhance Power BI reports and other analytical tools used to support operational and leadership decision-making. Collaborate with cross-functional stakeholders to identify reporting gaps and inefficiencies in existing business processes. Prepare clear summaries and presentations that communicate analytical findings and recommended actions. Maintain accurate documentation covering data sources, transformation logic, reporting processes, data lineage, and quality controls. Qualifications Currently enrolled in a degree program in Data Science, Computer Science, Information Systems, Business Analytics, Supply Chain Analytics, or a related field. Proficiency in Python, including experience with Pandas, NumPy, or similar data-manipulation libraries. Foundational understanding of SQL, relational databases, and data-modeling concepts. Strong analytical and problem-solving skills with close attention to detail. Effective written and verbal communication skills. Ability to work independently, manage priorities, and complete assignments with minimal supervision. Preferred Qualifications Familiarity with Microsoft Fabric, Azure Data Factory, Snowflake, or similar data-pipeline and cloud-data platforms. Intermediate to advanced Microsoft Excel skills, including structured tables, data validation, named ranges, and form design. Experience developing reports or dashboards in Microsoft Power BI. Exposure to data-intake, workflow-automation, or form-based data-collection processes. Basic understanding of data-governance principles, including data quality, documentation, ownership, and lineage. Experience with Power Automate, Power Apps, SharePoint, or other Microsoft 365 tools. Comfort collaborating with cross-functional stakeholders in a global business environment. Physical and Environmental Demands No special physical requirements beyond those associated with a standard office or remote-working environment. Travel Required None. #LI-RB1
Benefits
- Dental Insurance