Senior Excel and VBA Developer

Technical Specialist-VBA Developer

Area(s) of responsibility

Title:  Senior Excel/VBA Developer with SQL Server

Job Summary:
We are seeking an experienced and highly skilled Developer with advanced expertise in Excel and VBA to manage, troubleshoot, and enhance our CPQ application. The ideal candidate will have strong technical skills in VBA programming, SQL, MS Access, and integrating Microsoft Office applications such as Word, Outlook, and PDF automation through VBA. This role demands proficiency in developing complex VBA code, working with SQL Server stored procedures to support pricing strategies and business operations.

Responsibilities
•    Develop, enhance and support Pricing tools built in MS Excel with VBA and SQL Server.
•    Troubleshoot and debug complex VBA code to ensure optimal tool performance and reliability.
•    Design and implement new VBA modules and components to meet business needs.
•    Write and optimize SQL queries and stored procedures to interact with SQL Server databases.
•    Provide technical leadership and guide the application design.
•    Employ technology and software development best practices.
•    Perform regular testing, validation, and performance tuning of the pricing tool.
•    Work with the product owner to understand, estimate and refine the product backlog.
•    Provide assistance with user support issues and queries.
•    Be active in the continuous development of the tool in order to improve performance and stability.
•    Engagement with business stakeholders and program management to guide them into translating a business problem into a technical solution.

Experience Level

Mid Level