Sr. Software Engineer - VBA Macros Job

2-4 Years

Experience Level: Mid-Senior Level

We are seeking a skilled VBA/MS Excel Developer with 3 years of experience to join our dynamic team. The ideal candidate will have a deep understanding of VBA programming and advanced Excel functionalities. You will be responsible for developing and maintaining complex Excel models, automating repetitive tasks, and creating efficient solutions to enhance our data processing capabilities.

• Analyze and Maintain pre-existing VBA macros and complex Excel spreadsheets.
• Create the Technical Flow Diagram.
• Help in Migrating the Macros to ETL logic(SQL, PySpark).
• Basic understanding of Data and SQL.
• Collaborate with cross-functional teams to understand their requirements and provide tailored solutions.
• Debug and troubleshoot existing VBA code and Excel models.
• Ensure the accuracy and integrity of data within Excel models.
• Provide training and support to end-users on VBA and Excel functionalities.
• Document processes and maintain version control of Excel tools and VBA code.
• Required Skills and Qualifications:
• Bachelor s degree in Computer Science, Information Technology, Finance, or a related field.
• 3+ years of experience in VBA programming and advanced Excel with MS Access Database
• Proficiency in creating and optimizing complex Excel formulas and functions.
• Strong understanding of Excel features such as PivotTables, Charts, and Data Validation.
• Experience with integrating Excel with other applications and databases.
• Ability to write clean, efficient, and well-documented code.
• Excellent problem-solving skills and attention to detail.
• Strong communication and interpersonal skills.
• Ability to work independently and as part of a team.