Job Title: VBA Developer Location: Westlake TX or Merrimack NH (Hybrid) Department: Infrastructure / Application Support About the Team The Defined Contributions Record Keeping Support team ensures stability and availability of the record-keeping application used by internal users and clients. The team collaborates closely with relationship managers and product teams to resolve issues and enhance user experience. We're looking for a skilled VBA Developer who can support and enhance business-critical tools and processes. Key Responsibilities • Develop, maintain, and troubleshoot Excel VBA macros and automation tools. • Enhance existing macros for improved functionality and performance. • Use macros to interact with: • Mainframe systems (e.g., via Rumba or other 3270 emulators) • Databases such as MS Access, DB2, or SQL Server • Microsoft Outlook for sending automated emails • Word/Excel for generating output files • Windows API for screen control and automation tasks (e.g., taking screenshots) • Work with APIs using XML or JSON to connect Excel with external tools or web services. • Use Strike or equivalent tools for macro versioning and production releases. • Debug, test, and deploy solutions with minimal supervision. • Communicate effectively with business users to understand requirements and provide solutions. Required Skills & Experience • Strong hands-on experience in VBA (Visual Basic for Applications), especially in Excel. • Ability to work with complex and nested macros. • Experience with mainframe terminal emulators such as Rumba (3270 interface). • Strong knowledge of MS Access, DB2, and SQL Server. • Familiarity with APIs, including sending/receiving data using JSON and XML. • Experience with Strike or similar macro version control tools. • Strong debugging, testing, and troubleshooting skills. • Knowledge of Outlook automation and Windows API interactions. Preferred Qualifications • Bachelor’s degree in Computer Science, Engineering, Information Technology, or a related field. • 6+ years of experience in VBA development and automation scripting. • Ability to manage multiple priorities and deliver solutions under pressure. • Excellent communication skills to bridge the gap between technical and non-technical stakeholders.