Excel Automation & Data Insights Specialist (VBA)

TOTAL MANPOWER PTE. LTD.; Singapore; On-site; SGD 54,000 - 84,000; Full time

Job summary

Total Manpower Pte. Ltd. is seeking an Excel/VBA Automation Specialist in Singapore to streamline data processes across departments. You will develop macros, automate repetitive tasks, build dashboards, and ensure data accuracy while providing user support and training.

The role focuses on turning complex data into practical automation solutions, maintaining documentation, and collaborating with business users to deliver tangible efficiency gains.

Qualifications

• Experience with VBA and Excel automation is required.
• Ability to create dashboards and data reports.
• Strong data analysis skills.

Responsibilities

• Develop and maintain VBA macros, Excel automation tools, and reporting templates.
• Automate repetitive and manual processes using Microsoft Excel and VBA.
• Create user-friendly Excel dashboards, reports, and data analysis tools.
• Consolidate and process large volumes of operational and business data.
• Troubleshoot and resolve VBA, Excel, and automation-related issues.
• Improve existing spreadsheets, formulas, macros, and workflows to enhance efficiency.
• Work with users and department heads to understand business requirements and translate them into practical automation solutions.
• Integrate and manipulate data from multiple Excel files and other sources.
• Maintain proper documentation for VBA codes, processes, and automated tools.
• Ensure data accuracy, integrity, and appropriate access controls.
• Provide user support and basic training for Excel and VBA-related tools.
• Identify opportunities for process improvement and digitalisation.
• Assist with other reporting, administrative, and data-related projects as required.

Skills

VBA

Excel automation

Dashboard design

Data analysis

Automation tools

Reporting templates

Data consolidation

Data integrity

User training

Tools

Excel

VBA

Macros

Data visualization tools

Job description

Total Manpower Pte. Ltd. is seeking an Excel/VBA Automation Specialist in Singapore to streamline data processes across departments. You will develop macros, automate repetitive tasks, build dashboards, and ensure data accuracy while providing user support and training.

The role focuses on turning complex data into practical automation solutions, maintaining documentation, and collaborating with business users to deliver tangible efficiency gains.