Data Engineer (Excel and VBA)
Summary
Maintains and enhances Excel-based business solutions that connect to MS SQL databases using VBA macros, troubleshooting issues and optimizing performance for end users.
About the job 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.