remote
Pricing Sheet Developer - Trantor Software Pvt. Ltd
Software Engineer
Pricing Sheet Developer responsible for building, maintaining, and validating complex pricing models in Excel, using VBA and SQL to ensure accurate premium calculations for travel insurance products.
About the role
Key Responsibilities
- Design, develop, and maintain dynamic pricing sheets in Excel, incorporating advanced formulas and VBA macros to automate calculations.
- Collaborate with Product, QA, and IT teams to translate pricing logic into robust spreadsheet solutions and validate outputs against business requirements.
- Implement data validation, error handling, and version control to ensure sheet integrity and traceability across releases.
- Analyze and optimize existing pricing models for performance, scalability, and maintainability.
- Document processes, create user guides, and provide training to stakeholders on sheet usage and best practices.
Requirements
- 3+ years of experience developing complex Excel-based pricing solutions in a regulated industry.
- Proficiency in VBA programming, advanced Excel functions, and SQL for data extraction.
- Strong analytical skills with a keen eye for detail and accuracy.
- Excellent communication and collaboration abilities in a remote, cross-functional environment.
- Experience with version control systems (e.g., Git) and documentation tools is a plus.