EY Digital-Staff-Contractor 

India, Karnataka, Bengaluru 

198135768

Position Details

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.

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