Information Technology Analyst

Position: VBA Macro Developer Experience: 2 to 4 years Job Description: 1. ROLE SUMMARY The VBA Macro Developer is responsible for designing, engineering, optimizing, deploying, and maintaining enterprise-grade Excel automation solutions. The role involves integrating Excel with APIs, SAP, SQL, Outlook, SharePoint, and complex data pipelines, while ensuring governance, audit compliance, quality improvement, and measurable FTE reduction. The developer must collaborate with Business, IT, CoE, QSC, Audit, and Operations teams to deliver stable, scalable, and compliant automation ecosystems. 2. DETAILED RESPONSIBILITIES A. Advanced Requirement Gathering & Process Assessment • Conduct deep-dive sessions with SMEs, BAs, IT, and compliance teams. • Improve PDD documentation by identifying missing rules, exceptions, and decision paths. • Assess automation feasibility based on workflow complexity, system dependencies, and compliance needs. • Recommend automation-first redesigns for inefficient manual processes. • Produce detailed workflow maps, impact analysis, and automation scope documents. B. VBA Macro Development – Advanced Engineering • Develop modular, reusable, scalable automation frameworks in VBA. • Build end‑to‑end automation for data extraction, transformation, validation, reporting, and distribution. • Implement configuration-driven automation with advanced error handling and audit logs. • Create automated dashboards, BI-ready datasets, and workflow engines. • Optimize macros for execution speed, low memory usage, and low I/O overhead. C. Integration with Enterprise Systems • Integrate Excel with REST/SOAP APIs including authentication, JSON/XML parsing. • Automate SAP GUI scripting for report extraction and transaction processing. • Build SQL/Oracle database integration for bulk data handling. • Automate Outlook email operations including filtering, auto-replies, and attachment processing. • Integrate Excel with SharePoint, OneDrive, and cloud storage for document automation. • Handle system interruptions, API timeouts, SAP session resets, and file lock issues gracefully. D. FTE Reduction, Quality Improvement & Compliance Control • Design automation with measurable FTE savings and cycle-time reductions. • Embed preventive quality controls, validation rules, and automated error checks. • Build compliance-ready features such as timestamps, audit trails, exception logs, and user-level controls. • Demonstrate past experience delivering quantifiable business outcomes. • Support risk mitigation through controlled automation and standardization. E. Process Optimization & Engineering Mindset • Redesign legacy Excel models to reduce redundancy and improve performance. • Optimize formulas, reduce file size, and improve workbook structure. • Convert manually driven processes into stable, automated workflows. • Improve execution efficiency by 30–60% through advanced optimization techniques. F. Testing, Validation & Assurance Excellence • Prepare rigorous unit test cases and validation scripts. • Conduct performance testing under multiple data volumes. • Support UAT with business users and resolve defects. • Ensure automation meets SLA accuracy, speed, and stability expectations. G. Deployment, Maintenance & Production Support • Prepare deployment packs, migration documents, and rollback plans. • Provide training and knowledge transfer sessions. • Troubleshoot Excel crashes, system integration issues, and process failures. • Perform RCA and implement permanent fixes. • Maintain version logs and controlled updates. H. Governance, Audit, Compliance & CoE Alignment • Ensure automation adheres to QSCs. • Implement controls for data protection, access policies, and audit compliance. • Align development with Automation CoE coding standards and best practices. • Support internal/external audit cycles with evidence and documentation. 3. ADVANCED TECHNICAL SKILLS • Expert VBA programming including classes, arrays, dictionaries, error handling etc; • Advanced Excel: Power Query, Power Pivot, data models, pivot automation. • API integration (REST/SOAP) with JSON/XML. • SAP GUI scripting automation. • SQL integration via ADO for large datasets. • Outlook and SharePoint automation. • Strong debugging and performance optimization skills. 4. ADVANCED BEHAVIORAL & LEADERSHIP EXPECTATIONS • High accountability and strong ownership attitude. • Strong process-thinking and analytical mindset. • Ability to influence stakeholders for process redesign. • Clear communication to technical and non‑technical teams. • Ability to work with cross-functional business, IT, QA, CoE, and audit teams. 5. ADVANCED KPIs & SUCCESS MEASURES • FTE savings delivered per automation. • SLA improvements: turnaround, accuracy, reliability. • Zero major audit observations. • Reduction in error rates (TARGET ≥95%). • Execution speed improvement (TARGET 30%+). • Number of reusable components created. • User satisfaction and adoption metrics. 6. EXPERIENCE EXPECTATIONS • 2–6 years total experience in IT, automation. • 15+ automations or advanced Excel-based solutions developed. • Experience handling complex, multi‑system integrations. • Demonstrated history of delivering measurable business improvements. • Experience working with high-volume data (50K–2M+ rows). • Experience collaborating with enterprise stakeholders (IT, Risk, Compliance, Ops).