Data Analyst (R2071)

$85,000 - $130,000/Yr

Agrisompo North America - New York, NY

Full-time - Mid Level

New York, NY

Professional, Scientific, and Technical Services

About the position

The Data Analyst position at Sompo is a key role within the Ceded Reinsurance team, focusing on innovation and transformation initiatives to enhance the efficiency and productivity of the department. The analyst will be responsible for researching system solutions, evaluating their impacts, and developing tools to support the team's objectives. This role requires strong analytical skills and experience in system development, particularly using SQL and VBA, to drive process improvements and support corporate data transformation projects.

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.

Benefits

• 401(k) Retirement Savings Plan with competitive employer contributions
• Company-paid Life & AD&D benefits
• Company-paid Disability benefits
• 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
• Pharmacy benefits with mail order options
• Dental benefits including orthodontia benefits for adults and children
• Vision benefits
• Health Care & Dependent Care Flexible Spending Accounts