Role Overview

We're seeking an Excel VBA Engineer to design, build, and optimize robust automation solutions in Excel and Office applications, enabling data processing, reporting, and workflow acceleration. The ideal candidate has hands-on expertise in VBA, advanced Excel modeling, performance optimization, and secure integration with external data sources (e.g., databases, APIs via Office objects).

---

Key Responsibilities

· Automation & Development

o Design and develop VBA macros, form-driven tools, and automation frameworks in Excel.

o Build modular, reusable procedures and class modules for maintainability.

o Create custom functions (UDFs), event-driven code, user forms, and add-ins (.xlam).

· Data & Integration

o Develop robust ETL pipelines using Excel + VBA (data ingestion, validation, transformation).

o Connect to external data sources: SQL Server, Oracle, Access, CSV, JSON, XML, using ADO/DAO and OLE DB.

o Work with Power Query, Power Pivot, and PivotTables for modeling and analytics.

· Performance & Reliability

o Optimize long-running macros (screen updating,



calculation modes, arrays vs. cell-by-cell writes).

o Handle large datasets efficiently; implement error handling, logging, and transaction-like rollbacks.

· Testing & Documentation

o Implement unit-like tests for critical functions; ensure versioning and change control.

o Write transparent technical documentation, user guides, and operational SOPs.

· Security & Compliance

o Implement secure coding practices: input validation, sanitization, macro security awareness.

o Handle PII/sensitive data appropriately; comply with org standards for data governance.

· Collaboration

o Partner with business stakeholders to translate requirements into well-structured solutions.

o Conduct demos, training, and support for deployed tools.

---

Required Technical Skills

· VBA Mastery: Procedures/functions, class modules, events, UDFs, user forms, collections, enumerations, error handling (On Error pat

📌 VBA Developer (Bengaluru)
🏢 TalentOla
📍 Bengaluru