HR DATA ANALYST (VBA DEVELOPER)
Summary
The HR Data Analyst (VBA Developer) is responsible for automating manual processes and creating reporting tools using Microsoft Excel and VBA. The role involves consolidating large datasets, building dashboards, and providing technical support to improve operational efficiency.
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.