Internship CFD database creation for AeroX
Apply now »Date: 23 Apr 2025
Location: Saint-Ouen, FR
Company: Alstom
Req ID:484443
At Alstom, we understand transport networks and what moves people. From high-speed trains, metros, monorails, and trams, to turnkey systems, services, infrastructure, signalling and digital mobility, we offer our diverse customers the broadest portfolio in the industry. Every day, more than 80 000 colleagues lead the way to greener and smarter mobility worldwide, connecting cities as we reduce carbon and replace cars.
One of the AeroX team missions is performing CFD (computational fluid dynamics) simulations to estimate the impact of the train’s design on its performance, as well as on the safety and comfort of the passengers. A methodology was developed to automate and standardize the way these simulations are performed across the AeroX network.
The goal of this internship is to develop a database that will centralize all the simulation results across the network and thus make access and analysis of the simulation data possible by any user. The database needs to be integrated into the AeroX workflow, store the simulation information (such as date, user, project, run number, solver version, elapsed time…) as well as the results stored in *.csv files allowing any user to retrieve the evolution of simulation parameters.
Our intern shall also participate in the development of an easily accessible interface (such as an excel file) for users to query the database, in order to retrieve results for comparative analysis or for statistics purpose.
Missions:
- Get used to the methodology in place for CFD simulations and the cluster working environment
- Propose a database architecture matching the AeroX technical requirements
- Build the database and ensure integration with the current working environment
- Test the functionality of the database on some use cases
- Create the end user interface
- Prepare a technical report detailing the scripts used to build the database and including the complete source code
- Prepare a user manual
- Deliverable:
- Technical report detailing the scripts used to build the database
- Complete source code
- User manual
Profile:
- Master or Bachelor degree in engineering school
- Experience in data management (MariaDB, MySQL)
- Good knowledge of Softwares: STAR-CCM+ (CFD), Python, Java, VBA, Power BI
- Fluent in French & English
Contract: Internship of 6 months as of May 2025
You don’t need to be a train enthusiast to thrive with us. We guarantee that when you step onto one of our trains with your friends or family, you’ll be proud. If you’re up for the challenge, we’d love to hear from you!
Important to note
As a global business, we’re an equal-opportunity employer that celebrates diversity across the 63 countries we operate in. We’re committed to creating an inclusive workplace for everyone.
Job Type:Internship/Apprenticeship
Job Segment:
Database, User Experience, Intern, Java, Developer, Technology, Entry Level