Software Engineer - VBA Macros Job

YASH Technologies is a leading technology integrator specializing in helping clients reimagine operating models, enhance competitiveness, optimize costs, foster exceptional stakeholder experiences, and drive business transformation.

At YASH, we’re a cluster of the brightest stars working with cutting-edge technologies. Our purpose is anchored in a single truth – bringing real positive changes in an increasingly virtual world and it drives us beyond generational gaps and disruptions of the future.

We are looking forward to hire VBA Macros Professionals in the following areas :

Experience

2-4 Years

Job Description

Role: Microsoft - Software Engineer

Job Description

Experience Level: Mid-Senior Level

Job Summary:

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.

Key Responsibilities:

• 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.

Certifications

At YASH, you are empowered to create a career that will take you to where you want to go while working in an inclusive team environment. We leverage career-oriented skilling models and optimize our collective intelligence aided with technology for continuous learning, unlearning, and relearning at a rapid pace and scale.

Our Hyperlearning workplace is grounded upon four principles

• Flexible work arrangements, Free spirit, and emotional positivity
• Agile self-determination, trust, transparency, and open collaboration
• All Support needed for the realization of business goals,
• Stable employment with a great atmosphere and ethical corporate culture