TTT - VBA US WHT - Staff

At EY, you’ll 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 we’re 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.

TTT – VBA-SQL -Staff   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 to join our Tax Technology practice in Bangalore, India.     The opportunity   We are seeking a UiPath and Power Automate/Platform Developer to join our innovative technology team. In this role, you will leverage the UiPath & Microsoft Power Platform 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. 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