The RPA Engineer is responsible for developing and maintaining digital automation solutions that support factory operations, administrative processes, and data flow across the organization. The role focuses on hands-on implementation: building integrations, small automation scripts, data pipelines, internal databases, BI dashboards, and equipment data collectors. This position forms the technical foundation for future MES integration and overall digitalization of the plant.

Key Responsibilities

1. Business Process Automation (RPA)

• Develop small automation tools and robots to streamline repetitive tasks (invoice processing, HR workflows, financial reporting, recruitment dashboards, etc.).
• Maintain and update RPA workflows as processes evolve.
• Ensure reliability and error-free execution of automation scripts.

2. Data Integration & ETL (SAP → Internal Database)

• Retrieve data from SAP (via APIs, OData, table access or connectors) and build automated extraction flows.
• Design, build, and maintain a structured SQL database (hundreds of tables, relationships, keys).
• Set up nightly ETL (Extract–Transform–Load) cycles, monitoring data quality and consistency.
• Establish a unified data architecture for production, HR, finance, logistics, and other functions.

3. BI Development

• Build and maintain BI dashboards for Production, Finance, HR, and other teams.
• Execute ad-hoc reporting requests quickly and accurately.
• Ensure data availability, correctness, and automated refresh processes.

4. Equipment Integration & Data Collection

• Work with equipment manufacturers to obtain communication protocols and integration specifications.
• Develop data-collection drivers that capture parameters from furnaces, mixers, and radiography units (temperature, cycles, polymerization parameters, etc.).
• Stream real-time or high-frequency data (1 second or faster) into SQL tables.
• Implement alerting logic for deviations from acceptable ranges.

5. Systems Integration & Digital Factory Enablement

• Set up connections and data flows across PLC (Programmable Logic Controller)  → PC (Industrial PC / Gateway) → SQL (Database) → BI.
• Support pre-MES (Manufacturing Execution System) integration work and ensure data readiness for future MES deployment.
• Assist in validating that equipment signals and data interfaces work as expected.

6. Internal Support and Collaboration

• Provide simple training and user instructions for internal staff using automation tools, dashboards, and digital workflows.
• Support business teams (Finance, HR, SCM, Production) with data-driven and automation solutions.
• Serve as the technical point-of-contact for small automation tasks, while coordinating external experts only for large development projects.

Required Competencies and Skills

• Strong SQL skills (database design, indexing, relationships, optimization).
• Experience with scripting or RPA technologies (Power Automate, UiPath, Python or similar).
• Experience building integrations via APIs, OData, file processing, or other interfaces.
• Experience designing and maintaining ETL pipelines.
• Experience with BI platforms (Power BI, Tableau, Looker, Metabase).
• Basic understanding of PLC protocols (OPC UA, Modbus, or similar) is an advantage.
• Familiarity with industrial equipment integrations is a strong plus.
• High responsibility, accuracy, and ability to manage technically detailed tasks independently.