Job brief
We are looking for a Seasoned VBA Excel Macro developer to automate business process steps.
You will work independently as full stack developer creating Macros from scratch, modify existing macros to suit additional requirement or change in environment / input or output formats and provide user support.
In this role, you should be able to write functional Excel Macros with a sharp eye for spotting defects.
You should be a team player and excellent communicator.
If you are also passionate about the Macro Development with Microsoft Excel, we’d like to meet you.
Your goal will be to work with various operations teams to design, develop and maintain Excel Macros using
VBA.Responsibilities•
Participate in scoping, requirements analysis and solution design
• Collaborate with internal teams to produce software design and architecture• Write clean, scalable code using Visual Basic for Applications (VBA) languages
• Test and deploy Excel Macros. Revise, update, refactor and debug VBA code
• Develop documentation throughout the software development life cycle (SDLC)
• Update progress of assignment to all concerned stakeholders
• Highlight automation feasibility risks upfront and get buy-in from stakeholders before moving to next stepRequirements
• 3-5 years Proven experience as a Excel VBA Macro Developer
• Familiarity with the Advance Microsoft Excel Formulas
• Familiarity with the BI Tool like Power BI.
• Familiarity with Database design and development with MS Access and SQL Server
• Familiarity with SAP automation using VBA and Microsoft BI Platform would be added advantage
• Excellent troubleshooting and communication skills
• Attention to detail• BSc/BE in Computer Science, Engineering or a related field