Data and Analytics Intern (Summer 2027)

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.