INTERNSHIP DETAILS
Werkstudent*in (w/m/d) Datenanalyse
CompanyJENOPTIK AG
LocationJena
Work ModeOn Site
PostedMay 6, 2026

Internship Information
Core Responsibilities
The student will be responsible for the automated creation of delivery scheduling and demand planning lists using Excel, VBA, and Power Query. Additionally, they will maintain forecast tools, analyze on-time delivery deviations, and support data cleansing in ERP and CRM systems.
Internship Type
full time
Company Size
1779
Visa Sponsorship
No
Language
German
Working Hours
40 hours
Apply Now →
You'll be redirected to
the company's application page
About The Company
Jenoptik – MORE LIGHT. We are a company where bright ideas are born. Changing the world with light demands for an exploring spirit. Discover challenges the world is facing, at Jenoptik you change the world.
💡PHOTONICS: Optical technologies are at the heart of our business. Explore the variety of our photonics-based products and services: We’re on Mars with NASA. We’re behind the quality of your smartphone camera lenses. We enable smart manufacturing with laser & metrology solutions customized to your manufacturing environment. We make roads and communities safer.
🚀MARKETS: Our key target markets primarily include the semiconductor equipment industry, electronics, life science and medical technology, metrology as well as smart mobility incl. road traffic safety and civil security.
🌎LOCATIONS: The Jenoptik Group headquarters are in Jena, Thuringia, Germany. Next to our major sites in Germany, we maintain production and assembly sites in the USA, France, the United Kingdom and Asia-Pacific.
🌳SUSTAINABILITY: Together with our customers, we create forward-looking trends in the fields of energy efficiency, healthcare, the environment, mobility, and safety. With our products we can make significant contributions to meeting the societal challenges we face as well as to the conservation and efficient use of resources.
🌈INCLUSION: As an international company with about 4,600 employees, we are aware of our responsibility to create an appreciative and unprejudiced working environment and support diversity, equity and inclusion in our teams. We are committed to increasing the number of international und female managers in our company and signed the “Charta der Vielfalt”, an employer initiative for diversity, in 2020.
Grow with leading and bright ideas. Become a JENIUS.
Impressum, Legal Notice: https://www.jenoptik.com/legal-notice
About the Role
Ihre Aufgaben:
Du arbeitest direkt an den Themen Forecast, Bedarfsplanung und Datenanalyse und bekommst die Möglichkeit, echte Business-Prozesse aktiv mitzugestalten.
- Entwicklung und Automatisierung von Excel-Tools (inkl. VBA & Power Query), die im Tagesgeschäft wirklich genutzt werden
- Weiterentwicklung bestehender Reports sowie Einbringen eigener Ideen für bessere Analysen und Prozesse
- Erstellung und Analyse von Forecast-Daten auf monatlicher und quartalsweiser Basis
- Identifikationen von Abweichungen, z. B. im Bereich On-Time-Delivery, und Unterstützung bei der Ursachenfindung
- Arbeit mit Daten aus Systemen wie SAP, CRM und Business Warehouse (BW), um eine verlässliche Datenbasis sicherzustellen
- Unterstützung dabei, datenbasierte Prozesse effizienter, smarter und zukunftsfähig zu gestalten
- Enge Zusammenarbeit mit dem Customer-Care-Team sowie Schnittstellen zu Operations, Produkt- und Projektmanagement – so lernst du das Tagesgeschäft aus erster Hand kennen
Ihr Profil:
- Gültige Immatrikulation in einem wirtschaftsingenieurwissenschaftlichen, wirtschaftsinformatischen oder kaufmännischen Studiengang
- Ausgeprägtes analytisches Denkvermögen und strukturierte Arbeitsweise
- Hohe Zahlenaffinität sowie schnelle Auffassungsgabe
- Sehr gute Kenntnisse in MS Office, insbesondere Excel
- Fundierte Kenntnisse in der VBA-Programmierung
- Analytisches Denkvermögen sowie strukturierte und selbständige Arbeitsweise
- Sehr gute Deutsch- und Englischkenntnisse in Wort und Schrift
Ihre Ansprechpartner/in:
Name: Lina Schmidt
E-Mail: recruiting@jenoptik.com
Das bieten wir:

Key Skills
Data AnalysisExcelVBAPower QueryForecastingSAPERPCRMData CleaningProcess OptimizationAnalytical ThinkingEnglishGerman
Categories
Data & AnalyticsTechnologyLogisticsManufacturingEngineering
Prep Tools
FREE
YOUR RESUME KNOWS THE QUESTIONS
AI Question Predictor
Based on Werkstudent*in (w/m/d) Datenanalyse role
Tell me about your experience with Data Analysis
Why do you want to work at JENOPTIK AG?
Describe a challenging project you've led
FREE
20,000+ INTERVIEW QUESTIONS
Question Database
Curated for Data & Analytics
Data & Analytics
168+ Qs
Technology
162+ Qs
Logistics
347+ Qs
Manufacturing
568+ Qs
FREE
STUCK ON A QUESTION? PRACTICE IT
Practice Any Question
Get instant AI feedback
"How would you design a scalable system for JENOPTIK AG's use case?"
Record your answer & get scored