Excel/VBA Developer – Spreadsheet Automation & Optimization

Location:

Type:

Role Summary:

We are seeking an experienced Excel/VBA Developer to support a spreadsheet enhancement and optimization project. The role involves analyzing an existing Excel-based workbook, improving usability, and converting or minimizing VBA usage while maintaining essential business logic and reporting functionality.

Key Responsibilities:

● Review and refactor complex Excel workbooks with formulas, macros, and data processing logic.

● Design intuitive, efficient spreadsheet solutions using Excel-native features such as:

○ Tables

○ Structured formulas (SUMIFS, COUNTIFS, IF, etc.)

○ Data validation

○ Conditional formatting

○ Named ranges

● Minimize or eliminate the use of macros/ActiveX to improve cross-platform compatibility.

● Where applicable, optimize existing VBA code and integrate it cleanly with formula-driven logic.

● Create modular, protected templates that allow for secure data entry and reporting.

● Work closely with project leads to clarify requirements and deliver structured, error-free Excel files.

● Deliver clear technical documentation and user guidance.

Required Skills & Experience:

● 4+ years of advanced Microsoft Excel development experience.

● Proficiency in VBA (Visual Basic for Applications).

● Experience designing macro-free or low-code spreadsheet tools using native Excel capabilities.

● Solid grasp of spreadsheet logic, performance optimization, and UI/UX within Excel.

● Familiarity with cross-platform Excel compatibility (Windows vs. macOS).

● Strong problem-solving and debugging skills with attention to detail.

● Ability to work independently, meet deadlines, and communicate effectively.

Preferred Qualifications:

● Experience in building spreadsheets for reporting, data collection, or compliance use cases.

● Familiarity with Excel versions across environments (Excel 2016, 2019, Office 365).

● Ability to document your process and train users on updates and features.

Timeline:

● Start Date: Within 3 weeks

● Estimated Duration: 3-4 weeks (project-based)

How to Apply:

Submit your resume, portfolio of past Excel/VBA projects, and hourly or project-based rates to contact@zamorinstech.com/info@zamorinstech.com.