Senior Excel/VBA Developer with SQL Server

About Hpe

Hewlett Packard Enterprise is the global edge-to-cloud company advancing the way people live and work. We help companies connect, protect, analyze, and act on their data and applications wherever they live, from edge to cloud, so they can turn insights into outcomes at the speed required to thrive in today’s complex world. Our culture thrives on finding new and better ways to accelerate what’s next. We know varied backgrounds are valued and succeed here. We have the flexibility to manage our work and personal needs. We make bold moves, together, and are a force for good. If you are looking to stretch and grow your career our culture will embrace you. Open up opportunities with HPE.

Job Summary

This role has been designed as ‘Hybrid’ with an expectation that you will work on average 2 days per week from an HPE office.

Key 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.

Requirements

• Excellent understanding and experience in all aspects of MS Excel tool development including VBA and advanced formulae.
• Ability to develop complex models in Excel including workflows, UI elements, embedded calculations in VBA, security.
• Experience with relational databases such as SQL Server including DML, DDL and stored procedures.
• Experience with MS Access database design and VBA integration.
• Skilled in automating Microsoft Office applications (Word, Outlook) through VBA.
• Strong analytical and problem-solving skills, attention to detail, ability to show initiative when developing specified requirements.