Summer job - Database Development & Data Management

Are you currently studying at a university or college and looking for a meaningful summer job? At Mycronic, you get a unique opportunity to gain hands-on experience at a global high-tech company at the forefront of technology. 

Mycronic is a global high-tech company whose innovative solutions have been advancing electronics technology for over 40 years. Today we continue to grow and serve customers in an expanding variety of industries. What we do impacts the future of technology, and in turn, the way we live our lives tomorrow. 

 

Background 

Today, no other company can compete with Mycronic's mask writers. Our machines are used in the manufacturing of nearly all displays — from TVs and laptops to smartwatches and car infotainment systems — and even in semiconductor production. The process for the manufacturing happens at a nanometer level, smaller than blood cells and viruses. For all of this to be possible, a great emphasis is put on the quality of software and hardware. 

Mycronic's photomask equipment consists of many subsystems that produce data, which is then analyzed for many different purposes. For example, the mask writers utilize a multi-axis servo to position the laser beam that performs the actual writing of the masks, and all the motions in the system are logged and analyzed to ensure stable system operation. Another important aspect in the manufacturing of lithographic masks at nanometer-scale precision is the ability to measure and verify in the measured data that the patterns match the expected performance. 

Much of this analysis and decision-making is done today with a combination of manual analysis and statistical methods. Machine learning- and deep learning-based analysis offers several potential advantages over more traditional rule-based methods, for example reducing the amount of manual work needed, higher sensitivity for potential issues, or identifying more complex relationships that might be difficult to find with classical statistical analysis. 

 

Description 

The goal of the summer project is to design and implement a SQL database. The initial steps will include conducting a needs analysis, followed by the creation of a conceptual data model. The next phase will involve designing and implementing the SQL database, along with migrating our existing data into the new structure. Naturally, testing and quality assurance will be important parts of the project. 

Responsibilities: 

• Design and implement a database structure based on specific business needs. 
• Create necessary tables, relationships, and indexes to ensure optimal performance and data integrity. 
• Migrate existing data from various sources to the new database, including data cleaning and transformation when needed. 
• Document the database schema and the processes used for data migration. 
• Perform tests to ensure the database functions as expected and that all data has been correctly transferred. 

Qualifications: 

• Ongoing or completed education in computer science, information systems, or a related field. 
• Experience with database management systems such as MySQL, PostgreSQL, or SQL Server. 
• Proficiency in SQL and experience in database design and normalization. 
• Ability to work independently and take initiative. 
• Attention to detail and a high level of accuracy. 

Merits: 

• Experience with data migration and ETL (Extract, Transform, Load) processes. 
• Knowledge of scripting languages such as Python or Bash for automating data handling tasks. 
• Previous experience with similar projects. 

The duration of the summer work is 8-12 weeks, and the location is primarily at Mycronic’s headquarters in Täby just outside of Stockholm. 

 

Details 

Application deadline: We review applications on an ongoing basis, and positions may be filled before the application deadline 2025-05-12. 
How to apply: Apply through our website by answering the application questions and uploading your CV. 

 

Contact and further information 

David Lutman, Group Manager, PG Process Metrology and Test Center, david.luthman@mycronic.com. 

Nils Pallarés, Data Scientist Engineer, PG Process Metrology and Test Center, nils.pallares@mycronic.com. 

Mycronic is a global high-tech company whose innovative solutions have been advancing electronics technology for over 40 years. Today we continue to grow and serve customers in an expanding variety of industries. What we do impacts the future of technology, and in turn, the way we live our lives tomorrow.
We’re looking for people to join our talented, motivated and friendly team on the cutting-edge. Here, in an open, collaborative and flexible environment, you’ll work alongside leading industry experts and take on challenging projects that bring tomorrow’s electronics to life.