Job Description

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 clear 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 patterns), and decoupled architectures.
Advanced Excel: PivotTables, Power Query (M basics), Power Pivot/Model, array formulas, dynamic arrays, named ranges, structured references, data validation, conditional formatting.
Data Access: ADO/DAO, Connection/Recordset objects, parameterized queries, connection strings, bulk read/write via arrays.
Performance Optimization: Bulk operations, Application.ScreenUpdating, Application.Calculation, WorksheetFunction usage vs. native VBA, avoiding Select/Activate, binary file I/O when needed.
File & API Handling: Parsing CSV/TSV, XML/JSON parsing (via dictionary or references), interacting with Office objects (Outlook, Word), generating automated reports.
Version Control: Export/import modules; familiarity with Git workflows for VBA (using text exports).
Debugging Tools: Immediate Window, Watches, Call Stack, instrumentation logs.
---

Skills Required