Macro/ VBA Developer

At EY youll 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 were 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 - Macro/ VBA Developer

Position Level - Staff

Position Details

EYs GDS Assurance Digital teams mission is to develop implement and integrate technology solutions that better serve our audit clients and engagement teams. As a member of EYs core Assurance practice youll 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.

EYs GDS Assurance Digital team members work side-by-side with the firms 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.

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