VBA Developer

Role Overview

Were 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 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.

---