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.