We are looking for a Senior Excel Planning & Automation Consultant to optimize an existing Excel-based tool used for project scheduling, worksite planning, and resource allocation.
The current solution requires numerous manual operations and frequent adjustments to accommodate scheduling changes, project durations, resource availability, and other operational activities.
The objective is to deliver a more efficient, user-friendly, and maintainable Excel solution, reducing repetitive tasks while improving planning visibility and collaboration.
The assignment is divided into two phases:
2026: 15 working days, full-time, with 100% on-site presence required, during the period from November 30 to December 15, 2026.
From 2027 onwards: On-call availability for maintenance and continuous improvement, with guaranteed intervention timelines.
Analyze the existing Excel planning solution and gather functional requirements from business users.
Identify and implement pragmatic improvements to simplify planning activities and reduce manual operations.
Optimize scheduling processes, including project rescheduling, duration adjustments, and weekly planning updates.
Improve the visual representation of schedules, resource assignments, and operational information.
Automate repetitive Excel processes and facilitate weekly planning generation and distribution.
Structure project information, including SAP references, locations, priorities, estimated durations, and preparation status.
Develop efficient resource allocation features incorporating skills, availability, assignments, and absences.
Facilitate timesheet tracking and reporting of external resource activities.
Implement links to relevant project documents and information.
Improve collaborative access to Excel files while managing user permissions.
Ensure the solution remains intuitive, maintainable, and adaptable to evolving business requirements.
Provide ongoing maintenance and enhancements when requested.
Minimum 5 years of proven experience developing, improving, or maintaining Microsoft Excel solutions.
At least 5 years of demonstrable experience with the relevant technology or a comparable technology.
Proven participation in at least 2 projects improving existing Excel tools.
Proven participation in at least 2 projects developing Excel-based planning, resource management, or work management tools.
Proven participation in at least 3 Excel automation projects.
Demonstrated experience gathering and analyzing functional requirements from business users.
Strong communication, synthesis, documentation, and reporting skills.
Fluent French or Dutch (C2), with a good command of the other language (B2).
Full-time availability for 15 working days during the specified period in 2026, with 100% on-site presence.
Guaranteed availability from 2027 onwards for maintenance interventions within 10 working days of a request.
Guaranteed availability from 2027 onwards for enhancement requests within 6 weeks.
Ability to provide a completed experience template.
Proven experience with Power Query.
Experience developing and using Excel macros or VBA.
Experience configuring collaborative Excel environments using SharePoint.
N/A