Purpose of the Position
The successful candidate will be responsible for collecting, integrating, transforming and leveraging data from company systems (MES, ERP, quality and production systems), building reliable and scalable data pipelines to support decision-making and improve operational performance. The primary objective of the role is to ensure data availability, quality and standardization, while developing automation and integration solutions to support client companies.
Main Responsibilities:
- Design, develop and maintain ETL/ELT pipelines for acquiring and transforming data from MES, SQL databases and company APIs.
- Collaborate with the MES application development team to define metrics, structure data flows and translate operational requirements into robust and reusable data models.
- Ensure data quality, consistency and traceability throughout the entire pipeline by defining controls and validation processes.
- Manage data refresh, orchestration and scheduling processes, ensuring reliability, security and performance.
- Develop supporting reports and dashboards (using Power BI where necessary) to monitor KPIs related to production, quality, efficiency and operational performance.
- Design and develop integrations between company data systems and artificial intelligence tools (e.g., MCP servers, AI agents and LLMs) to enable automation and natural language access to data.
- Monitor data loading processes and data platform services, independently identifying and resolving anomalies.
- Prepare technical and functional documentation and provide training support to end users.
Required Technical Skills
Data Engineering and Integration (Core of the Role)
- Solid experience in developing ETL/ELT processes and designing data pipelines.
- Knowledge of Apache NiFi or equivalent data integration and orchestration tools.
- Excellent knowledge of SQL Server and SQL, with the ability to design and optimize relational data models.
- Experience integrating data from different sources (e.g., REST APIs, CSV, XML).
- Familiarity with scripting languages for data automation and transformation (e.g., Python, JavaScript).
- Familiarity with monitoring tools for automated process control.
AI and Automation
- Interest or experience in integrating generative AI tools into company data flows (LLMs, AI agents).
- Knowledge of or interest in the MCP (Model Context Protocol) and in developing MCP connectors/servers that expose company data to AI tools.
- Familiarity with automation and scheduling processes (workflow automation).
Business Intelligence and Reporting
- Basic to intermediate knowledge of Power BI.
- Knowledge of DAX and data modeling (star schema, dimensions, facts) is considered an advantage.
Preferred Requirements:
- Experience in manufacturing or industrial environments.
- Good command of English.
Soft Skills:
- Analytical thinking and problem-solving orientation.
- Ability to communicate and collaborate with technical and business stakeholders.
- Ability to organize work independently.
- Structured approach to documentation and standardization.
- Curiosity about new technologies, particularly AI.
Education:
Degree in Computer Science, Computer Engineering, Management Engineering, Statistics, Mathematics or related disciplines.
Employment Conditions and Benefits:
- National Collective Bargaining Agreement (CCNL) for the Commerce and Tertiary sector.
- Meal vouchers.
- Indicative annual gross salary: €35,000–€40,000 (determined based on objective and gender-neutral criteria).
