Imerys is the world’s leading supplier of mineral-based specialty solutions for the industry, and they are seeking an intern for the S&T Data Solidation & AI Analysis role. The intern will modernize the Science & Technology data architecture by developing an automated ETL pipeline and applying data engineering best practices to create an AI-ready master database.
Build and optimize Python scripts to automate data extraction, transformation, and formatting across multiple network directories and cloud drives
Utilize Retrieval-Augmented Generation (RAG) tools like NotebookLM to analyze compiled datasets, audit historical reports against Imerys SOPs, and identify multi-variable trends
Implement robust code safeguards (e.g., handling missing data, creating tracking columns for Source Files/Tabs) to guarantee data traceability and integrity
Analyze combined metadata to spot geographical or locational trends, profile edge-cases, and compile findings into technical reports
Qualification
Required
Experience with Python programming, particularly with libraries such as pandas and openpyxl
Knowledge of data engineering best practices, including ETL (Extract, Transform, Load) processes
Ability to design and execute scripts for data extraction, cleaning, and merging of complex Excel workbooks
Familiarity with AI tools, specifically Retrieval-Augmented Generation (RAG) tools like NotebookLM
Understanding of data quality assurance practices, including handling missing data and ensuring data traceability
Ability to analyze metadata for trends and compile findings into technical reports
Strong communication skills to translate complex data architectures into clear visual presentations
Ability to build professional relationships with cross-functional teams
Preferred
Experience with data architecture and automated Python pipelines
Familiarity with version control systems
Experience in qualitative data analysis and compliance auditing
Benefits
The world leader in mineral-based specialty solutions for industry, Imerys transforms a unique range of minerals to deliver essential