HR DATA ANALYST (VBA DEVELOPER)
Posted Updated 4
views
Summary
An HR data analyst role centered on building and maintaining VBA macros, Excel automation tools, dashboards, and reporting templates. Day to day the person automates manual processes, consolidates large volumes of business data, troubleshoots Excel/VBA issues, documents solutions, and trains users. Core stack: Microsoft Excel and VBA.
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.