TTT-VBA-automation skillset-Contractor

TTT – VBA-SQL- Python - Staff-Contractor

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

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.

EY's GDS Tax Technology team members work side-by-side with the firm's partners, clients and tax 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 Tax.

GDS Tax Technology works closely with clients and professionals in the following areas: Federal Business Tax Services, Partnership Compliance, Corporate Compliance, Indirect Tax Services, Human Capital, and Internal Tax Services. GDS Tax Technology provides solution architecture, application development, testing and maintenance support to the global TAX service line both on a pro-active basis and in response to specific requests.

EY is currently seeking a VBA– SQL-Python to join our Tax Technology practice 

The opportunity

We are seeking a Automation developer to join our innovative technology team. In this role, you will leverage the VBA, SQL, Python, Power Query, Power Platform etc to craft cutting-edge solutions that address our clients' most pressing business challenges. With a focus on development, integration, and deployment, you will play a pivotal role in enhancing business processes and improving user experiences.

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.
• Knowledge on Python programming
• Knowledge on reporting using excel/Power BI
• 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. Python 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 0 – 2 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.