HR Data Automation Specialist (VBA & Excel)

OCD HANDS PTE. LTD.; Singapore; On-site; SGD 55,000 - 90,000; Full time

Job summary

OCD HANDS PTE. LTD. in Singapore is seeking a skilled VBA/Excel automation specialist to design, develop, and maintain automation solutions. You will build macros, dashboards, and reporting templates to streamline operations.

You will consolidate large data sets, troubleshoot issues, document code, and provide user support and basic training to colleagues. This role focuses on improving spreadsheets, workflows, and digital processes across the company.

Qualifications

• Experience with VBA and Excel automation.
• Ability to process large data volumes.
• Familiarity with dashboards and reporting templates.
• Documentation of VBA codes and processes.
• Provide user support and basic training.

Responsibilities

• Develop and maintain VBA macros and Excel automation tools.
• Automate repetitive processes using Excel and VBA.
• Create dashboards, reports, and data analysis tools.
• Consolidate and process large volumes of data.
• Troubleshoot VBA and automation issues.
• Improve spreadsheets, formulas, macros, workflows.
• Translate business requirements into automation solutions.
• Integrate data from multiple Excel files.
• Maintain documentation for VBA codes and tools.
• Ensure data accuracy and access controls.
• Provide user support and basic training.
• Identify opportunities for process improvement and digitalisation.
• Assist with other reporting and data-related projects.

Skills

VBA

Excel automation

Data analysis

Documentation

User support

Problem solving

Tools

Excel

VBA

Job description

OCD HANDS PTE. LTD. in Singapore is seeking a skilled VBA/Excel automation specialist to design, develop, and maintain automation solutions. You will build macros, dashboards, and reporting templates to streamline operations.

You will consolidate large data sets, troubleshoot issues, document code, and provide user support and basic training to colleagues. This role focuses on improving spreadsheets, workflows, and digital processes across the company.