EY Macro/ VBA Developer 

India, West Bengal, Kolkata 

482743456

Position Name - Macro/ VBA Developer

Position Level - Staff

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.

GDS Assurance Digital provides solution architecture, application development, testing and maintenance support to the global Assurance service line both on a pro-active basis and in response to specific requests.

Requirements (including experience, skills and additional qualifications)

• A Bachelor's degree (BE/BTech/MCA & MBA) in Computer Science, Engineering, Information Systems Management, Accounting, Finance or a related field with adequate industry experience.
• 2-4 years of experience as developer in Core MS Excel, VBA, MS Access

Responsibilities:

Develop Macro Based solutions

Technical skills requirements:

• Use Connection String function to connect with data source in SQL, Spreadsheet or another Data source.
• Use Advanced Excel capabilities, including pivot tables, lookups, complex formulas and graphing to streamline business processes.
• Strong experience in developing Macro using Email Objects
• Develop, maintain, and support existing MS Excel VBA applications, and analyse and convert business requirements as needed.
• Good Understanding of SQL basic queries

Nice to have skill

• Experience in RPA
• Experience in .NET
• Experience in running project in SCRUM framework

Analytical/Decision Making Responsibilities:

• An ability to quickly understand complex concepts and use technology to support data modeling, analysis, visualization or process automation
• Selects appropriately from applicable standards, methods, tools and applications and uses accordingly
• Ability to work within a multi-disciplinary team structure, but also independently
• Demonstrates analytical and systematic approach to problem solving
• Communicates fluently orally and in writing and can present complex technical information to both technical and non-technical audiences
• Able to plan, schedule and monitor work activities in to meet time and quality targets
• Able to absorb rapidly new technical information, business acumen, and apply it effectively
• Ability to work in a team environment with strong customer focus, good listening, negotiation and problem-resolution skills

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 provides equal employment opportunities to applicants and employees without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, or disability status.

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.