VBA Automation

Role & responsibilities

Domain knowledge

• Experienced in application development and process automation, using VBA, VB.net, C#
• Expected to have experience in min. 2 technologies/languages from below, in addition to VBA:
  a. Data Analytics & Visualization Tools
  (Power BI, Qlik Sense)
  b. JavaScript / HTML / CSS
• Python / R
• Experience with various frameworks & Agile development methodologies
• Continuously learn about and adopt new technologies in application development and process automation.
• Ability to work independently and as part of a team
• Job role based on relevant experience

Job Description

• Design & develop VBA macros and applications (via VBA, VB.net, C#) to automate various Excel tasks, including data collection, data manipulation, report generation, and other repetitive processes
• Create interactive and visually appealing dashboards using Excel (potentially incorporating Power BI or other dashboarding tools as needed)
• Work closely with stakeholders to collect detailed data for setting up dashboards, understanding their needs and translate them into functional requirements
• Conduct thorough testing and debugging of applications to ensure quality and functionality
• Excellent presentation and communication skills

Skill set: VBA, VB.Net, C#, Power BI, Interactive Dashboards