Senior Reinsurance Business Analyst
AmericanAg®, Schaumburg, IL, United States
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.
Responsibilities The Senior Reinsurance Business Analyst will be responsible for:
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:
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.
#J-18808-Ljbffr
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.
Responsibilities The Senior Reinsurance Business Analyst will be responsible for:
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:
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.
#J-18808-Ljbffr