Senior Software Engineer III

Title:

Senior Software Engineer III

Company:

Everest Global Services, Inc.

Job Category:

Technology

Job Description:

About Everest:
Everest Group, Ltd. (Everest), is a leading global reinsurance and insurance provider, operating for nearly 50 years through subsidiaries in North America, Latin America, the UK & Ireland, Continental Europe and Asia Pacific regions. Throughout our history, Everest has maintained its discipline and focuses on creating long-term value through underwriting excellence and strong risk and capital management. Our strengths include extensive product and distribution capabilities, a strong balance sheet, and an innovative culture. Our most critical asset is our people. We offer dynamic training & professional development to our employees. We also offer generous tuition/continuing education reimbursement programs, mentoring opportunities, flexible work arrangements, and Colleague Resource Groups.

About the Role: An experienced Coherent Designer/ Excel VBA Senior Developer is sought to join the team. A Coherent Designer/ Excel VBA Senior Developer is a skilled and versatile individual who ensures that all design elements, from overall aesthetics to functionality, work together to create a unified and effective product or experience. Responsibilities include designing, developing, and implementing robust and efficient automation solutions using VBA within Microsoft Excel, Coherent Spark and other Office applications. The ideal candidate should possess deep expertise in VBA, Excel functions, data modeling, and best coding practices. This role requires collaborating closely with business stakeholders to translate their needs into customized and scalable solutions. This role requires a blend of technical prowess, strong analytical and problem-solving skills, and a commitment to optimizing processes and enhancing user productivity. 

Role & Responsibilities (include but not limited to

• Design and Development:

  • Develop and maintain advanced custom business applications and solutions using Coherent Spark, VBA in Excel and MS Access.

  • Translate complex business requirements into technical specifications and viable solutions.

  • Develop and maintain Coherent, VBA applications and macros to automate tasks and streamline business processes.

  • Develop complex Spark workbooks able to handle Rating, Rules and Modeling needs of business and actuarial teams.

  • Create user-friendly interfaces and dashboards using VBA, including features like Pivot Tables, charts, and data visualization.

  • Enhance existing applications and build new solutions based on business needs.

  • Integrate Spark, Excel and VBA solutions with other applications and external data sources (e.g., SQL databases) via APIs, REST services, etc.

• Optimization and Maintenance:

  • Optimize existing Coherent Spark, macros and scripts for improved performance and functionality, adhering to best coding practices.

  • Debug and troubleshoot Spark, VBA code and existing software to ensure optimal performance and resolve defects.

  • Reverse engineer and support legacy applications.

  • Perform database structure analysis (SQL Server and Oracle) and manipulate SQL for data and analytics needs.

• Collaboration and Documentation:

  • Collaborate with Product Owners, Business Analysts, and End Users to gather requirements, understand their needs, and define project scope.

  • Provide technical advice/support, mentoring, and direction to junior developers.

  • Develop test plans and software documentation to support code modifications and additions.

  • Create technical documentation for assigned deliverables and development processes to ensure maintainability.

  • Provide support and troubleshooting for existing solutions and train end-users on new applications and enhancements.

  • Actively participate in Agile project teams and methodologies (Scrum/Kanban).

Qualifications:

• A Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent practical experience) is required.

• 2-5 years of design/development experience with Coherent Spark.

• A minimum of 10-15 years of experience on a software delivery team, with a focus on devel