Clean, transform, and consolidate OSAT material inventory and liability data in Excel
Enhance the Demand vs Material Analysis tool using S&OP forecasts and claims
Design standardized reporting templates for OSAT partners
Support development of Power BI dashboards on OSAT inventory and liability status
Support root cause analysis of material variances and inventory liabilities
From the employer’s posting
Work with actual Excel datasets received from OSAT partners to understand, clean, transform, validate, and consolidate material inventory and liability data.
Enhance the current Demand vs Material Analysis tool by comparing S&OP forecasts, demand fluctuations, and subcontractor material liability claims.
Develop templates that capture ST-specific material inventory positions, aging inventory, liability status, and exposure metrics.
Support the development of Power BI dashboards that provide visibility of OSAT material inventory and liability status.
Support root cause analysis of material variances and inventory liabilities across OSATs.
Education & alternatives
Qualifications Education
* Able to commit minimum 5 months of internship * Pursuing Bachelor's degree in: * Supply Chain Management * Industrial Engineering * Data Analytics * Business Analytics * Operations Management * Information Systems * Related disciplines
Technical Skills
Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.
Excel
Power BI
Where the posting names them
Technical Skills
* Strong Microsoft Excel skills, including data transformation, formulas, Pivot Tables, and data analysis. * Experience with Power BI or other data visualization tools is preferred. * Familiarity with data cleansing, and reporting automation. * Basic knowledge of supply chain planning, inventory management, and S&OP processes is an advantage.
Soft Skills
Dashboard Development & Business Intelligence
* Support the development of Power BI dashboards that provide visibility of OSAT material inventory and liability status. * Create visualizations and performance metrics to monitor material exposure risks and inventory trends. * Assist in generating insights and recommendations to support material planning and risk-control decisions.
Qualifications Education
New Analyst postings at the employers we follow are up 24% over the last 6 weeks compared with the 6 before.
August 17Last week
Each bar is one week of new postings. The darkest bars are the last 6 weeks.
Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.
About the role
We file this job under Analyst, by the work the posting describes.
Analysts answer business questions with data. They pull numbers with SQL, build reports and dashboards, and explain what changed and why to the people making decisions.
Most postings ask for SQL, spreadsheets, a dashboard tool such as Tableau or Power BI, and clear writing.
Unlike a data scientist, an analyst mostly explains what happened rather than building models that predict what will.
OUR STORY
At STMicroelectronics, we believe in the power of technology to drive innovation and make a positive impact on people, businesses, and society. As a global semiconductor company, our advanced technologies and chips form the hidden foundation of the world we live in today.
When you join ST, you will be part of a global business with more than 115 nationalities, present in 40 countries, and comprising over 50,000 diverse and dedicated creators and makers of technology around the world.
Developing technologies takes more than talent: it takes amazing people who understand collaboration and respect. People with passion and the desire to disrupt the status quo, drive innovation, and unlock their own potential.
Embark on a journey with us, where you can innovate for a future that we want to make smarter and greener, in a responsible and sustainable way. Our technology starts with you.
Key Responsibilities Data Management & Process Improvement
* Work with actual Excel datasets received from OSAT partners to understand, clean, transform, validate, and consolidate material inventory and liability data.
* Analyze data structures and reporting methodologies from multiple subcontractors to improve data consistency and reporting accuracy.
* Identify opportunities to automate and streamline material data management processes.
Demand vs Material Analytics
* Enhance the current Demand vs Material Analysis tool by comparing S&OP forecasts, demand fluctuations, and subcontractor material liability claims.
* Improve data validation methodologies to increase analysis accuracy and provide better material exposure assessments.
* Support root cause analysis of material variances and inventory liabilities across OSATs.
Reporting Standardization
* Collaborate with internal stakeholders to design and standardize reporting templates for OSAT partners.
* Develop templates that capture ST-specific material inventory positions, aging inventory, liability status, and exposure metrics.
* Drive adoption of standardized reporting formats to improve reporting quality and consistency.
Dashboard Development & Business Intelligence
* Support the development of Power BI dashboards that provide visibility of OSAT material inventory and liability status.
* Create visualizations and performance metrics to monitor material exposure risks and inventory trends.
* Assist in generating insights and recommendations to support material planning and risk-control decisions.
Qualifications Education
* Able to commit minimum 5 months of internship
* Pursuing Bachelor's degree in:
* Supply Chain Management
* Industrial Engineering
* Data Analytics
* Business Analytics
* Operations Management
* Information Systems
* Related disciplines
Technical Skills
* Strong Microsoft Excel skills, including data transformation, formulas, Pivot Tables, and data analysis.
* Experience with Power BI or other data visualization tools is preferred.
* Familiarity with data cleansing, and reporting automation.
* Basic knowledge of supply chain planning, inventory management, and S&OP processes is an advantage.
Soft Skills
* Strong analytical and problem-solving capabilities.
* High attention to detail and data accuracy.
* Effective communication and stakeholder management skills.
* Ability to work independently and manage multiple priorities.
* Continuous improvement mindset with an interest in process optimization and digital transformation.
ST is proud to be one of the 17 companies certified as a 2025 Global Top Employer and the first and only semiconductor company to achieve this distinction. ST was recognized in this ranking thanks to its continuous improvement approach and stands out particularly in the areas of ethics & integrity, purpose & values, organization & change, business strategy, and performance.
At ST, we endeavor to foster a diverse and inclusive workplace, and we do not tolerate discrimination. We aim to recruit and retain a diverse workforce that reflects the societies around us. We strive for equity in career development, career opportunities, and equal remuneration. We encourage candidates who may not meet every single requirement to apply, as we appreciate diverse perspectives and provide opportunities for growth and learning. Diversity, equity, and inclusion (DEI) is woven into our company culture.
To discover more, visit st.com/careers.