Macro Developer

TOG Indonesia; Jakarta Pusat; On-site; IDR 111,600,000 - 279,000,000; Full time

Job summary

TOG Indonesia is seeking a skilled VBA Excel Developer to automate processes and deliver dynamic reports. The role is based in Jakarta and focuses on creating robust automated solutions in Excel using VBA to streamline business reporting.

Key duties include developing VBA-based automation, advanced Excel reporting, data extraction/transformation/validation, and documenting macros for user guidance to ensure smooth system usage and clear audit trails.

Qualifications

• Bachelor's degree in IT/IS/CS or related field.
• At least 3 years of relevant experience.
• Proficient in Microsoft Excel with advanced functions and Pivot Tables.
• Strong knowledge of VBA (Visual Basic for Applications).
• Experience with data processing, including data cleansing and data wrangling.
• Strong analytical thinking and problem-solving skills.
• Ability to automate and optimize business processes.

Responsibilities

• Develop and maintain automated solutions using VBA (Visual Basic for Applications).
• Automate repetitive tasks and reporting processes in Microsoft Excel.
• Perform data processing, including data extraction, transformation, and validation.
• Design and generate dynamic reports and dashboards based on business requirements.
• Document VBA macro logic and provide user guidance for system usage.

Skills

VBA

Data cleansing

Data wrangling

Pivot Tables

Analytical thinking

Automation

Education

Bachelor's degree in IT/IS/CS or related field

Tools

Microsoft Excel

Job description

• Develop and maintain automated solutions using VBA (Visual Basic for Applications).
• Automate repetitive tasks and reporting processes in Microsoft Excel.
• Perform data processing, including data extraction, transformation, and validation.
• Design and generate dynamic reports and dashboards based on business requirements.
• Document VBA macro logic and provide user guidance for system usage.

Qualifications

• Education: Minimum Bachelor’s Degree (S1) in Information Technology, Information Systems, Computer Science, or a related field.
• Experience: Minimum 3 years of relevant experience.
• Technical Skills:Proficient in Microsoft Excel, including advanced functions and Pivot Tables.
• Strong knowledge of VBA (Visual Basic for Applications).
• Skilled in data processing, including data cleansing and data wrangling.
• Strong analytical thinking and problem-solving skills.
• Ability to automate and optimize business processes.

Interpersonal & Communication Skills

• Excellent verbal and written communication skills, with the ability to work effectively in project environments involving internal teams and users.
• Strong analytical and critical thinking skills.
• Ability to work effectively both independently and as part of a team.