Job
Description
You are a proactive and technically sound VBA Developer with experience in Office Script, SharePoint Online, and automation scripting. Your role involves enhancing and supporting business automation solutions across Excel, Office 365, and related platforms. You will design, develop, and maintain Excel-based tools using VBA and Office Script, automate tasks involving Word, PDF handling, and Web-based tools, and modernize legacy Excel VBA tools into Office Scripts. Interacting with SharePoint Online using REST API calls from VBA and collaborating with teams to implement scalable solutions are key aspects of your responsibilities. Additionally, you will provide ongoing support and optimization for VBA and Office Script-based tools and utilize Python scripts for supplementary automation tasks. Key Responsibilities: - Design, develop, and maintain Excel-based tools using VBA and Office Script (TypeScript). - Automate tasks involving Word, PDF handling and Web-based tools using scripting. - Modernize legacy Excel VBA tools into Office Scripts and integrate them with Power Automate Cloud Flows. - Interact with SharePoint Online using REST API calls from VBA for data retrieval and updates. - Collaborate with teams to understand automation requirements and implement scalable, reusable solutions. - Provide ongoing support and optimization for VBA and Office Script-based tools. - Use Python scripts (intermediate level) for supplementary automation, data processing, or integration tasks. Required Skills & Qualifications: - Strong experience in Excel VBA (looping, conditions, modular programming, error handling). - Proficiency in Office Script and TypeScript. - Hands-on experience with REST API calls from VBA (e.g., SharePoint, Outlook, Microsoft Graph). - Good working knowledge of SharePoint Online lists, libraries, and integration via VBA and Office 365 tools. - Intermediate Python scripting skills for automation and data transformation. - Familiarity with Power Automate (Cloud Flows) for end-to-end business process automation. Nice to Have: - Experience with Office JS APIs or Microsoft Graph API. - Familiarity with Power Apps and Dataverse. - Exposure to Agile or DevOps work models. At EY, you will be part of a team that is dedicated to building a better working world by creating new value for clients, people, society, and the planet. Working across assurance, consulting, tax, strategy, and transactions services, you will help shape the future with confidence and address pressing issues with data, AI, and advanced technology. EY teams operate globally, providing services in more than 150 countries and territories.,
