job description
Join PERSOL as an Administrative Assistant in Bali and leverage your expertise in Excel automation and VBA macros to streamline operations for a dynamic team. This contract role offers a unique opportunity to work in a vibrant, international environment while applying advanced analytical skills to enhance business efficiency.
As a key support figure, you will develop and maintain automated reporting systems, analyze complex datasets, and ensure seamless administrative workflows. Your proficiency in Excel formulas, pivot tables, and macro scripting will be instrumental in driving data-driven decisions. Ideal for detail-oriented professionals who thrive in fast-paced settings, this position combines technical precision with organizational excellence.
Based in Bali, this role provides a perfect blend of professional growth and work-life balance in one of the world’s most sought-after destinations. Whether you're optimizing spreadsheets or coordinating cross-functional projects, your contributions will directly impact operational success.
Responsibility
- Develop and maintain VBA macros to automate repetitive Excel tasks, improving efficiency and accuracy.
- Design and generate advanced Excel reports (pivot tables, dashboards) for management review.
- Perform data analysis to identify trends, anomalies, and actionable insights for business decisions.
- Manage and organize administrative documents, ensuring version control and accessibility.
- Collaborate with cross-functional teams to gather data requirements and deliver tailored analytical solutions.
- Troubleshoot and resolve issues in existing Excel templates and automation scripts.
- Assist in preparing presentations and summaries for stakeholders using analyzed data.
- Maintain confidentiality and integrity of sensitive business information.
Qualifications
- Proven experience as an Administrative Assistant or similar role with a focus on Excel automation.
- Advanced proficiency in Microsoft Excel (formulas, VLOOKUP, INDEX-MATCH, pivot tables).
- Strong VBA scripting skills to create and modify macros for process automation.
- Experience in data analysis and interpretation, with the ability to present findings clearly.
- Excellent organizational and time-management skills to handle multiple priorities.
- Strong attention to detail and problem-solving abilities.
- Fluent in English (written and verbal) for effective communication.
- Ability to work independently and collaboratively in a contract-based environment.