Role: VBA Developer
Employment: Extendable contract Role
Location: KL
Payroll: Tentacle Tech Sdn Bhd
Domain: Banking
Job Overview
We are seeking a skilled VBA Developer to design, develop, and maintain VBA applications, primarily in Microsoft Excel and Access. The ideal candidate should have strong expertise in automating workflows, optimizing processes, and ensuring data accuracy through VBA scripting.
Key Responsibilities
· Develop and maintain VBA-based applications in Excel, Access, and other Microsoft Office tools.
· Automate repetitive tasks and optimize existing macro-based processes.
· Work with stakeholders to understand business requirements and translate them into efficient VBA solutions.
· Ensure data integrity and security within VBA applications.
· Debug and troubleshoot existing VBA scripts to enhance functionality and performance.
· Integrate VBA applications with external databases such as SQL Server, MySQL, or Oracle.
· Develop user-friendly forms, reports, and dashboards using Excel and Access.
· Provide documentation, training, and support to end-users.
· Stay updated on best practices and emerging technologies related to VBA and Microsoft Office automation.
Required Skills & Qualifications
· Strong expertise in VBA programming within Excel, Access, and Outlook.
· Proficiency in data manipulation, pivot tables, and advanced Excel formulas.
· Experience with database connections (ODBC, SQL queries, ADO, DAO).
· Familiarity with Microsoft Office automation and API integration.
· Ability to write clean, efficient, and well-documented code.
· Strong problem-solving and analytical skills.
· Excellent communication and stakeholder management skills.
· Bachelor's degree in Computer Science, Information Technology, or a related field (preferred).
· Preferred Qualifications
· Experience with Power BI, Power Query, or Power Automate.
· Knowledge of Python, RPA, or other scripting languages.
· Exposure to financial modeling, reporting automation, or ERP integrations.