Macro Developer

PT ELISTEC INFORMATIKA UTAMA; Kebayoran Baru; On-site; IDR 133,920,000 - 200,880,000; Full time

Job summary

PT ELISTEC INFORMATIKA UTAMA in Jakarta seeks a skilled VBA developer to design automated solutions within Microsoft Excel. You will automate repetitive tasks, extract, transform, and validate data, and build dynamic reports and dashboards to meet business needs.

The role requires a minimum Bachelor's in IT or CS, at least 3 years of experience, advanced Excel skills, and strong analytical thinking. You will document macro logic and provide user guidance, collaborating effectively in a team.

Qualifications

• Bachelor's degree in IT, Information Systems, CS or related field.
• 3+ years of experience in VBA/Excel automation.
• Strong proficiency with Excel formulas, PivotTables, and dashboards.
• Data cleansing, wrangling, and data validation skills.
• Excellent written and verbal communication; able to work in a team.

Responsibilities

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

Skills

Advanced Excel

VBA

Data processing

Analytical thinking

Teamwork

Interpersonal communication

Education

Bachelor's degree in IT / CS

Tools

Microsoft Excel

VBA (Visual Basic for Applications)

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 macro logic and provide user guidance for system usage

About you

Minimum Bachelor Degree (S1) in Information Technology, System Information, Computer Science, or related field

Minimum 3 years experience

Proficient in Microsoft Excel (advanced functions, Pivot Tables)

Strong knowledge of VBA (Visual Basic for Applications)

Skilled in data processing (data cleansing & wrangling)

Strong analytical thinking and problem-solving skills

Ability to automate and optimize business processes

Excellent interpersonal (verbal and written) communication skills

Strong analytical and critical thinking skill

Able to work effectively in a team environment

Unlock job insights

Hirer responsiveness Salary match Number of applicants