EY TTT-VBA-SQL Developer-Advanced Analyst 

India, Karnataka, Bengaluru 

613399025

TTT – VBA-SQL -Staff

Ever-increasing regulations require tax 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.

Your key responsibilities

• Design, develop, and maintain automated solutions using VBA for Excel and other Microsoft Office applications.
• Collaborate with business stakeholders to gather requirements and translate them into effective VBA solutions with SQL.
• Estimate technical effort, work breakdown structure, risks, and solutions at a solution level
• Create and maintain SQL queries and scripts to extract, manipulate, and analyze data from various databases, including Microsoft Access and SQL
• Conduct testing and debugging of VBA, SQL and Power Query solutions to ensure high-quality deliverables.
• Proactive approach to identifying issues and presenting solutions and options, and where appropriate, leading to resolution
• Document technical specifications, design patterns, and user guides to support application scalability and knowledge transfer.
• Collaborate with various data sources, including MS Access, SQL Server and other relational databases, to ensure data integrity and accessibility.
• Stay updated with the latest trends and advancements in VBA, SQL and Power query technologies.

Skills and attributes for success

• Strong experience in developing automated solutions using VBA for Excel and other Microsoft Office applications.
• Proficiency in writing complex SQL queries for data extraction, transformation, and analysis particularly with MS Access.
• Understanding of relational database concepts and experience with database management systems such as MS Access and SQL Server.
• Ability to create and maintain user-friendly documentation for VBA applications and SQL queries to facilitate knowledge sharing.
• Strong analytical, problem-solving, and communication skills, with the ability to articulate technical concepts to non-technical stakeholders.
• Ability to work independently and collaboratively in a team environment, contributing to a positive team culture.
• Knowledge of Agile development methodologies, including participation in sprint planning, daily stand-ups, and retrospectives.

To qualify for the role, you must have

• Bachelor’s / master’s degree in software engineering / information technology / MBA / MCA.
• An overall 2 – 3 years of experience.

Ideally, you’ll also have

• Thorough knowledge Tax or Finance Domain.
• Strong analytical skills and attention to detail.
• Knowledge of Python and Power Query.
• Familiarity with Copilots (M365) and Gen AI concepts.

What we look for

• A Team of people with commercial acumen, technical experience and enthusiasm to learn new things in this fast-moving environment
• Excellent learning ability.
• Strong communication skill.
• Flexibility to work both independently and as part of a larger team.
• Strong analytical skills and attention to detail.

What we offer

EY Global Delivery Services (GDS) is a dynamic and truly global delivery network. We work across six locations – Argentina, China, India, the Philippines, Poland and the UK – and with teams from all EY service lines, geographies and sectors, playing a vital role in the delivery of the EY growth strategy. From accountants to coders to advisory consultants, we offer a wide variety of fulfilling career opportunities that span all business disciplines. In GDS, you will collaborate with EY teams on exciting projects and work with well-known brands from across the globe. We’ll introduce you to an ever-expanding ecosystem of people, learning, skills and insights that will stay with you throughout your career.

• Continuous learning: You’ll develop the mindset and skills to navigate whatever comes next.
• Success, as defined by you: We’ll provide the tools and flexibility, so you can make a meaningful impact, your way.
• Transformative leadership : We’ll give you the insights, coaching and confidence to be the leader the world needs.
• Diverse and inclusive culture : You’ll be embraced for who you are and empowered to use your voice to help others find theirs.

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.