Job Description

Roles & Responsibilities

Mission 1. Scoping and Needs Analysis (the request): Managing change requests: Gathering, analyzing, and translating the technical and functional requirements expressed directly by clients, the Procurement department, or the Methods department. Operational flexibility: Designing customized automation solutions adapted to the specific problems of each requester. 2. Data Extraction and Integration (Input): Multi-source connection: Extraction and centralization of raw data from the SAP ERP system, shared file servers, or local files, depending on the scope of the request. Securing data flows: Automating data retrieval to guarantee the freshness and reliability of information. 3. Processing, Modeling, and Requencing: Data Cleaning: Sorting, filtering, and restructuring complex input data to eliminate anomalies. Advanced Querying: Using Power Query and writing SQL queries to merge, cross-reference, and model large volumes of data. Logical Preprocessing: Transforming raw data into actionable business indicators. 4. Automation and Development (VBA): Developing complex macros: Designing VBA algorithms to automate all repetitive and time-consuming tasks. Reliability: Standardizing business rules in the code to eliminate the risk of human error. 5. Output and Delivery: Generating results: Designing final reports, precise deliverables, and dynamic dashboards that meet the client's requirements. Sharing and Traceability: Automated deployment of results to the shared server for seamless and secure access by the Methods teams and internal partners. 6. Technical Environment & Skills: Languages ​​& Tools: VBA, SQL, Power Query, Advanced Excel (PivotTables, complex formulas). Systems: SAP, File Server Management. Cross-functional Skills: Customer focus, priority management (on-demand project mode), cross-functional communication with Methods and Procurement departments.

Desired Candidate Profile

Are you proficient in Excel/VBA and enjoy developing tools that simplify users' daily lives? This position is for you. We are looking for a VBA Developer Technician for our Segula Agadir site. You will be able to design, maintain, and develop applications and automation tools using Excel/VBA. VBA proficiency is essential: your expertise will make the difference. Whether you have a background in computer science or a technical environment (industry, mechanics, methods, production), we are primarily looking for someone who can understand business needs and transform them into reliable, efficient, and user-friendly solutions. You are known for your rigor, analytical skills, autonomy, and problem-solving abilities. Experience: A two-year post-secondary degree (Bac+2/Bac+3) is required. Prior experience of less than one year in VBA development is preferred.