VBA Developer

Job Title: VBA Developer

Location: Boston, MA
Experience: 8+ Years
Job Type: Contract

Job Description

We are seeking an experienced VBA Developer with strong expertise in Microsoft Access and SQL Server to maintain, troubleshoot, and enhance legacy business applications. The ideal candidate will have hands-on experience developing Microsoft Access applications, writing and optimizing VBA code, supporting SQL Server database objects, and automating reports and document-generation processes.

Key Responsibilities

• Develop, maintain, and enhance Microsoft Access applications, including forms, reports, and VBA modules.

• Write, debug, and optimize VBA code for business process automation, reporting, and data management.

• Create and maintain reports, letters, and document-generation processes using Microsoft Word templates and bookmarks.

• Develop, modify, and support SQL Server stored procedures, views, queries, and database objects.

• Troubleshoot application issues across the user interface, VBA code, and SQL Server backend.

• Analyze existing workflows and implement business requirements and application enhancements.

• Integrate Microsoft Access front-end applications with SQL Server backend processes.

• Support scheduled jobs, data updates, and automated batch processes.

• Maintain and enhance legacy applications while ensuring data accuracy and system reliability.

Required Skills

• 8+ years of experience in VBA development and application support.

• Strong hands-on experience with Microsoft Access development.

• Excellent knowledge of VBA (Visual Basic for Applications).

• Proficiency in Microsoft SQL Server, including stored procedures, views, queries, and database design.

• Experience with Microsoft Word automation, templates, bookmarks, and document generation.

• Experience in reporting, data management, and business process automation.

• Strong debugging, troubleshooting, analytical, and problem-solving skills.

• Ability to understand and maintain complex legacy applications.

Preferred Skills

• Experience supporting long-established business applications.

• Knowledge of task scheduling and automated batch processing.

• Experience integrating Microsoft Office applications with SQL Server.

• Ability to work independently and collaborate with business stakeholders.