HR Data Analyst (vba Developer)

MANDATE OF MANPOWER PTE. LTD.; Singapore; On-site; SGD 50,000 - 80,000; Full time

Job summary

MANDATE OF MANPOWER PTE. LTD. in Singapore is seeking a detail-oriented Excel and VBA specialist to develop and maintain automation tools, macros, and reporting templates.

You will automate repetitive tasks, create user-friendly dashboards, and consolidate large data sets to support operations and decision-making. Ideal candidates have strong Excel/VBA skills, experience building dashboards, and the ability to translate business needs into practical automation solutions.

Qualifications

• Proficient in VBA macros and Excel automation.
• Experience creating dashboards and reports in Excel.
• Ability to consolidate large datasets and ensure data accuracy.
• Translate business needs into automated Excel solutions.

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

Excel

VBA

Data analysis

Automation

Reporting

Tools

Microsoft Excel

VBA

Job description

Key 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.