Data Engineer (Excel and VBA)

Position Overview

We are seeking a detail-oriented Excel Database Support Specialist to provide technical support and maintenance for business-critical Excel applications that interface with MS SQL databases and utilize VBA macros. This role will serve as the primary point of contact for troubleshooting, optimizing, and enhancing Excel-based business solutions.

Key Responsibilities

• Excel Application Support: Troubleshoot and resolve issues with complex Excel workbooks and templates used across the organization.
• Database Connectivity: Maintain and optimize connections between Excel applications and MS SQL databases.
• VBA Development & Maintenance: Debug, modify, and enhance existing VBA macros; develop new automation solutions as needed.
• User Support: Provide technical assistance to business users, including training and documentation.
• Performance Optimization: Identify and resolve performance bottlenecks in Excel applications and database queries.
• Documentation: Create and maintain technical documentation for Excel solutions and processes.
• Quality Assurance: Test Excel applications after updates or changes to ensure functionality and data integrity.