Senior Reinsurance Business Analyst at American Agricultural Insurance Company – Schaumburg, Illinois
Explore Related Opportunities
About This 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.
The Senior Reinsurance Business Analyst will be responsible for:
- 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
What is needed for this role:
- 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
- CPCU and/or ARe designations are a plus
The expected starting salary range for this position is between $130,000 and $150,000. Applicable salary ranges may differ across markets. Actual pay will be determined based on experience and other job-related factors permitted by law. This position is also eligible for an annual productivity bonus. For information regarding our benefits, please click here.
We do not sponsor employment visas and are unable to take over an employment visa from another employer. Applicants must be authorized to work in the U.S. for ANY employer without the need for employment visa sponsorship.
Who We Are
Since 1948, AmericanAg® has provided reinsurance services that promote the financial strength and success of its clients. We are a direct provider of reinsurance to the Farm Bureau® insurance companies and also participate in assumed U.S. and international reinsurance programs through the broker marketplace. Learn more at aaic.com
Reasons to Consider AmericanAg®
At AmericanAg®, you’ll work alongside a diverse team of highly educated and experienced professionals. We foster a dynamic culture where innovative ideas are championed and brought to life and where employees are appreciated, engaged, and encouraged to reach their full potential.
AmericanAg® participates in E-Verify. Learn more about applicant rights under Federal Employment Laws.
Scan to Apply
Job Location
Job Location
This job is located in the Schaumburg, Illinois, 60173, United States region.