Job Description

Position Overview: The Software Engineer will be part of our New Products & Strategies team and will work closely with team members to maintain and expand an array of existing VBA applications, Office toolbar customizations, and Ope

Position Overview: The Software Engineer will be part of our New Products & Strategies team and will work closely with team members to maintain and expand an array of existing VBA applications, Office toolbar customizations, and OpenXML document automations. The VBA code base applies across a range of products, ranging from large custom Excel VBA forecasting applications to standardized features rolled out at organization level. The technologies used include but are not limited to Excel VBA macros, functions. The candidate will start working as an Excel VBA/C# office document focused developer with opportunities to grow to be a more broadly focused application developer. The candidate must be able to work in a fast-paced environment, possess strong technical and analytical skills, excellent communication skills, have a positive attitude, and be able to efficiently organize their work. Responsibilities: Include but not limited to: Maintain existing, complex VBA applications for multiple products across New Products & Strategies team. Develop new VBA applications when necessary for new product features and/or ad hoc client requests. Troubleshoot and analyze existing VBA code to fix bugs and address performance problems while also taking a proactive approach to minimize such issues. Maintain VBA infrastructure (including but not limited to Excel VBA codebases) for multiple products across New Products & Strategies team. Constantly explore the latest technologies and make recommendations where appropriate to provide improved functionality of existing VBA applications. Use industry best practices, and appropriate code structure to develop required VBA solutions. Customize office toolbar applications using VSTO framework. Automate PPT and Excel documents using OpenXML libraries. Education: Candidate will have a minimum of bachelor's degree in Computer Science/Information Technology or related field with 3-5 years of active VBA/C# development experience. Qualifications: Solid knowledge of SQL, and connecting to relational databases via VBA (ODBC/ADODB) Knowledge of OpenXML framework and automating office document manipulation via C#/.net Knowledge of automating excel and Powerpoint updates and manipulation via VBA . Knowledge of creating and updating custom office toolbar applications using the MS VSTO toolkit Strong VBA coding ability with solid analytical, problem solving and design skills. Developing high quality and thoroughly unit tested code. Ability to debug and fix issues in existing VBA functions/macros. Ability to translate business problems into practical, scalable technical solutions with keen sense of ownership and responsibility. Experience with Windows based scripting languages like PowerShell / Batch. Professional, pro-active communication and ability to multitask in a flexible environment. Experience with C#/.NET Experience working in the MS Visual Studio IDE Knowledge of cloud native relational databases (including Azure SQL, Snowflake) (preferred) Experience working in pharmaceutical industry (preferred)