Data Analyst

$85,000 - $130,000/Yr

Sompo International - New York, NY

Full-time - Mid Level

New York, NY

Insurance Carriers and Related Activities

About the position

The Data Analyst position on the Ceded Reinsurance team at Sompo International is a pivotal role focused on enhancing the efficiency and productivity of the Ceded Reinsurance Department. This position involves researching and implementing system solutions, guiding the organization through data transformation projects, and developing tools to support catastrophe processing and reporting. The ideal candidate will leverage their analytical skills and system development experience to drive innovation and process improvements within the team.

Responsibilities

• Operational ownership, design, and development for reinsurance tools and applications.
• Collaborate in the design and development of new tools and applications for catastrophe processing and reporting.
• Support corporate data transformation projects from inception to implementation, including reinsurance impact analysis and testing.
• Design process enhancements, research and document business issues, develop business requirements, create test case documentation, and training/procedural materials.
• Determine and develop user requirements for systems in production to ensure maximum usability.
• Conduct thorough data analysis, reconciliations, and validations to support system enhancement and process improvements.
• Develop test scenarios, execute test cases, document outcomes, and manage defect resolution.
• Create and maintain plans for every project, ensuring transparent communication at all levels.
• Partner with stakeholders across business units to develop analyses and documentation in a collaborative way, communicating effectively with operational and managerial teams.
• Design and implement process controls that meet IAD and SOX control standards.

Requirements

• Minimum 5 years of experience with business analysis and controls & compliance in Financial services, accounting, treasury, insurance, or reinsurance industry.
• Strong data analysis and reconciliation skills along with strong problem-solving abilities and critical thinking skills.
• Proficiency in SQL, VBA, and other programming languages as well as expertise in Microsoft Office applications, including Access, Excel, and Visio.
• Ability to produce comprehensive process documentation and reports.
• Demonstrated success in detailed analysis, user testing, and process improvement initiatives with a strong track record in requirement gathering, documentation, and test case development.
• Excellent communication skills and experience collaborating with IT departments in large corporate environments.
• Proven experience in managing change for enterprise-wide systems.
• Flexibility and adeptness at balancing multiple priorities in a dynamic setting.

Nice-to-haves

• Experience in the insurance or reinsurance industry is preferred.
• Familiarity with catastrophe modeling tools and applications.

Benefits

• Two medical plans to choose from, including a Traditional PPO & a Consumer Driven Health Plan with a Health Savings account providing a competitive employer contribution.
• Pharmacy benefits with mail order options.
• Dental benefits including orthodontia benefits for adults and children.
• Vision benefits.
• Health Care & Dependent Care Flexible Spending Accounts.
• Company-paid Life & AD&D benefits, including the option to purchase Supplemental life coverage for employee, spouse & children.
• Company-paid Disability benefits with very competitive salary continuation payments.
• 401(k) Retirement Savings Plan with competitive employer contributions.
• Competitive paid-time-off programs, including company-paid holidays.
• Competitive Parental Leave Benefits & Adoption Assistance program.
• Employee Assistance Program.
• Tax-Free Commuter Benefit.
• Tuition Reimbursement & Professional Qualification benefits.