At EY, you’ll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture and technology to become the best version of you. And we’re counting on your unique voice and perspective to help EY become even better, too. Join us and build an exceptional experience for yourself, and a better working world for all. 

 
Position Name-VBA/Macros

Position Details

EY’s GDS Assurance Digital team’s mission is to develop, implement and integrate technology solutions that better serve our audit clients and engagement teams. As a member of EY’s core Assurance practice, you’ll develop a deep Audit related technical knowledge and outstanding database, data analytics and programming skills.

Ever-increasing regulations require audit departments to gather, organize and analyse more data than ever before. Often the data necessary to satisfy these ever-increasing and complex regulations must be collected from a variety of systems and departments throughout an organization. Effectively and efficiently handling the variety and volume of data is often extremely challenging and time consuming for a company.

EY’s GDS Assurance Digital team members work side-by-side with the firm’s partners, clients and audit technical subject matter experts to develop and incorporate technology solutions that enhance value-add, improve efficiencies and enable our clients with disruptive and market leading tools supporting Assurance.

Requirements (including experience, skills and additional qualifications)

A Bachelor’s degree (BE/BTech/MCA & MBA) in Computer Science, Engineering, Information Systems Management.

Responsibilities:

Design, develop, and maintain VBA scripts, macros, and functions to automate repetitive tasks and processes within Microsoft Office applications, primarily Excel, Word, and Outlook.
Ensure that all VBA applications are user-friendly and meet business requirements.

Technical skills requirements:

Solid understanding of VBA programming fundamentals to create macros and automate tasks in Excel, Access, and other Office applications.
Familiarity with the Microsoft Office object model and its components.
Knowledge of programming concepts such as loops, conditionals, variables, arrays, and functions.

Nice to have skill

Experience of solving issues of existing Macros.
Experience on working on Enhancements.
Experience in running project in SCRUM framework.

Analytical/Decision Making Responsibilities:

Analyze complex data sets to identify trends, patterns, and insights that can inform business decisions.
Use VBA to automate data collection, cleaning, and processing to ensure accuracy and efficiency in analysis.
Identify issues within business processes and develop VBA-based solutions to address them.
Make decisions on the best methods and approaches for automating tasks and improving workflows
Evaluate and decide on the appropriate use of VBA versus other technologies or programming languages based on the project requirements
Determine the most efficient algorithms and data structures for VBA applications to optimize performance
Continuously assess and improve existing VBA applications and macros for better performance and usability.
Make decisions on refactoring and updating legacy code to align with current best practices and business needs

Additional skills requirements:

The expectations are that a Senior will be able to maintain long-term client relationships and network and cultivate business development opportunities
Provide high quality client services by directing daily progress of engagement work, informing engagement manager of engagement status, and managing staff performance.
Must have presentation skills ‘ ability to create PowerPoint deck to communicate solution architecture to various stakeholders.
Should have understanding and experience of software development best practices
Excellent business communication, Consulting, Quality process skills
Must be a team player

EY | Building a better working world 

 
EY exists to build a better working world, helping to create long-term value for clients, people and society and build trust in the capital markets.  

 
Enabled by data and technology, diverse EY teams in over 150 countries provide trust through assurance and help clients grow, transform and operate.  

 
Working across assurance, consulting, law, strategy, tax and transactions, EY teams ask better questions to find new answers for the complex issues facing our world today.