Senior Reinsurance Business Analyst

American Agricultural • Schaumburg, IL

2d • $130,000 - $150,000 • Hybrid

About The Position

AmericanAg®, global provider of diversified reinsurance services, is looking for a Senior Reinsurance Business Analyst to work out of our office in Schaumburg, Illinois. This is a hybrid position working in the office a minimum three days a week.

The Information Systems (IS) team at AmericanAg® plays a critical role in leading the development of business intelligence solutions, including managing and providing corporate data, and is responsible for the reinsurance processing system. If you have information systems experience, along with reinsurance, database, and programming expertise, this might be a great opportunity to consider.

Requirements

• Bachelor’s degree or equivalent experience
• 6+ years of experience working in information systems, preferably insurance or reinsurance information systems. Experience working in SICS is a plus.
• A good understanding of property/casualty insurance and reinsurance
• Strong SQL skills and experience working with relational databases
• A comprehensive understanding of data modeling and data warehouse concepts
• Strong experience with Power BI (reports, data modeling, DAX); BusinessObjects (reports, queries); Microsoft Excel (DAX, Power Query, VBA); and Microsoft Access (forms, queries, modules)
• Strong communication skills, with the ability to work with both technical and non-technical users
• Strong ability to manage multiple tasks and support cross-department initiatives

Nice To Haves

• CPCU and/or ARe designations are a plus

Responsibilities

• Serving as the primary system administrator for the SICS reinsurance processing system:
• Interpreting changing business requirements and determining how they should be implemented within SICS
• Setting up and maintaining assumed and ceded contracts and related processing rules
• Performing batch processing and overseeing workflows critical to operational and financial reporting
• Leading key components of the financial quarter close process, ensuring SICS outputs are accurate and aligned with accounting timelines
• Providing users with data that is easy to access, analyze, and understand through well-designed reporting solutions including:
• Designing, building, and maintaining BusinessObjects reports, universes, and ad hoc data sources
• Designing and building Power BI reports, datasets, and applications that support self-service reporting
• Leading design and development of the corporate data warehouse, including data modeling, ETL/ELT processes, and performance optimization
• Training employees on how to effectively use BusinessObjects, Power BI, SICS, and data warehouse tools:
• Providing ongoing support for reporting tools, dashboards, and data access
• Creating and maintaining user documentation, training guides, and best-practice standards
• Promoting data literacy across the organization through training sessions, workshops, and one-on-one guidance
• Designing and building additional applications and utilities as needed to support business operations and reporting:
• Leading or managing IS projects, including requirements gathering, system design, testing, and deployment
• Collaborating with business units to understand operational needs and delivering solutions that enhance efficiency and data visibility
• Developing a thorough understanding of the company’s business model, reinsurance operations, financial processes, and strategic priorities:
• Serving as a liaison between departments to ensure smooth communication and coordination for data- and system-related initiatives
• Supporting ad hoc data and reporting needs

Benefits

• This position is also eligible for an annual productivity bonus.
• For information regarding our benefits, please click here [https://www.aaic.com/about-us/careers/employee-benefits/].

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level