HR Data Analyst (vba Developer)

FOCUS MANPOWER PTE. LTD.; Singapore; On-site; SGD 52,000 - 82,000; Full time

Job summary

FOCUS MANPOWER PTE. LTD. seeks a skilled Excel/VBA automation specialist in Singapore to develop macros, dashboards, and reporting templates. You will automate repetitive tasks, consolidate large data sets, and ensure accuracy and access controls. Strong communication with users to translate requirements into practical solutions is essential.

The role involves maintaining documentation, providing basic training, and supporting various data-related projects across departments.

Qualifications

• Experience automating data and reporting in Excel using VBA.
• Ability to design user-friendly dashboards and data tools in Excel.
• Strong data analysis skills to consolidate and derive insights.

Responsibilities

• Develop and maintain VBA macros, Excel automation tools, and reporting templates.
• Automate repetitive 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 issues.
• Improve existing spreadsheets, formulas, macros and workflows.
• Translate business requirements into practical automation solutions.
• Integrate data from multiple Excel files and sources.
• Maintain documentation for VBA codes and automated tools.
• Ensure data accuracy and appropriate access controls.
• Provide user support and basic training for Excel/VBA tools.
• Identify opportunities for process improvement and digitalisation.
• Assist with other reporting, administrative, and data-related projects.

Skills

Automation

Excel proficiency

Dashboard design

Data analysis

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.