Title:

Senior Software Engineer II

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.

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.

1-3 years of design/development experience with Coherent Spark.

A minimum of 5-10 years of experience on a software delivery team, with a focus on developing and maintaining VBA solutions, is required.

Demonstrable expertise in VBA programming and its application within Excel and other Microsoft Office products is required.

A strong understanding of Excel functions, formulas, pivot tables, charts, and data visualization techniques is required.

Proficiency in developing stored procedures within MS Excel and MS Access VBA, and SQL proficiency, is required.

Familiarity with other programming languages like Python, C# or VB.NET, and experience working with .NET platforms are a plus.

Experience in designing, developing, testing, deploying, and supporting applications within a team environment is required.

Strong analytical, problem-solving, and troubleshooting skills are required.

Excellent verbal and written communication skills and the ability to collaborate effectively with cross-functional teams and stakeholders are required.

Ability to work independently and manage multiple tasks simultaneously in a fast-paced environment is required.

Working knowledge of Actuarial algorithms.

Knowledge, Skills & Competencies:  

Experience working in an P&C Insurance environment and familiarity with Insurance concepts.

Knowledge of specific database technologies like SQL Server, or Oracle.

Certifications such as Microsoft Office Specialist (MOS) or Azure certifications (AZ-204, AZ-900).

Experience working with Coherent Spark Batch, On Demand, Subservices, XCalls and Testing Center.

For CA, NY, NJ or IL: The base salary range for this position is $116,000 - $158,750 annually. The offered rate of compensation will be based on individual education, experience, qualifications and work location. All offers include access to a variety of benefits to employees, including health insurance coverage, an employee wellness program, life and disability insurance, 401k match, retirement savings plan, paid holidays and paid time off (PTO).

What if I don’t meet every requirement? At Everest we are dedicated to building an inclusive and authentic workplace. So, if you are excited about this role but your past experience doesn’t align perfectly with every element in the job description, we still encourage you to apply. You may be just the right candidate for this or other roles. Please let us know if you need any accommodations throughout the application or interview process.

 

Our Culture

At Everest, our purpose is to provide the world with protection. We help clients and businesses thrive, fuel global economies, and create sustainable value for our colleagues, shareholders and the communities that we serve. We also pride ourselves on having a unique and inclusive culture which is driven by a unified set of values and behaviors. Click here to learn more about our culture. 

Our Values are the guiding principles that inform our decisions, actions and behaviors. They are an expression of our culture and an integral part of how we work: Talent. Thoughtful assumption of risk. Execution. Efficiency. Humility. Leadership. Collaboration. Inclusion and Belonging.Our Colleague Behaviors define how we operate and interact with each other no matter our location, level or function: Respect everyone. Pursue better. Lead by example. Own our outcomes. Win together.  

 

All colleagues are held accountable to upholding and supporting our values and behaviors across the company. This includes day to day interactions with fellow colleagues, and the global communities we serve. 

Type:

Regular

Time Type:

Full time

Primary Location:

Warren, NJ

Additional Locations:

Everest is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion or creed, sex (including pregnancy), sexual orientation, gender identity or expression, national origin or ancestry, citizenship, genetics, physical or mental disability, age, marital status, civil union status, family or parental status, veteran status, or any other characteristic protected by law. As part of this commitment, Everest will ensure that persons with disabilities are provided reasonable accommodations. If reasonable accommodation is needed to participate in the job application or interview process, to perform essential job functions, and/or to receive other benefits and privileges of employment, please contact Everest Benefits at everestbenefits@everestglobal.com.

Everest U.S. Privacy Notice | Everest (everestglobal.com)