Business Intelligence Analyst

American Modern Insurance Group, Inc., a Munich Re company, is a widely recognized specialty insurance leader that delivers products and services for residential property – such as manufactured homes and specialty dwellings – and the recreational market, including boats, personal watercraft, classic cars, and more. We provide specialty product solutions that cover what the competition often can’t. Headquartered in Amelia, Ohio, and with associates located across the United States, we are part of Munich Re’s Global Specialty Insurance division. Our employees receive boundless opportunity to grow their careers and make a difference every day - all in a flexible environment that helps them succeed both at work and at home.

American Modern Insurance Group is seeking a Business Intelligence Analyst to support our Claims Division. In this role, you will support teams by transforming data into actionable insights that improve operational performance, claim outcomes, and strategic decision‑making. This role partners closely with Claims leadership and business stakeholders to design, develop, and maintain reports, dashboards, and analytics solutions using modern BI tools and cloud data platforms.

Responsibilities:

• Partner with Claims leadership and business users to gather reporting and analytical requirements, translating business needs into effective BI solutions.
• Design, build, and maintain Power BI reports and dashboards that provide visibility into Claims performance, trends, and key metrics.
• Leverage cloud-based data processing and data vizualation platforms to support scalable data processing, analytics, and reporting solutions.
• Develop and optimize SQL queries to extract, transform, and analyze data from enterprise data warehouses and operational systems.
• Perform data analysis to identify trends, outliers, and opportunities related to claims severity, frequency, cycle time, leakage, and catastrophe impacts.
• Support regulatory and compliance reporting (e.g., DOI and other required submissions) in collaboration with Compliance and Claims leadership.
• Ensure data accuracy, consistency, and integrity across reports and dashboards through validation and quality checks.
• Present insights and findings to Claims leaders and business partners in a clear, concise, and actionable manner.
• Serve as a subject matter expert for Claims reporting and analytics, providing guidance and support to business partners and other analysts.

Required Qualifications:

• Bachelor’s degree in Information Systems, Data Analytics, Business, or a related field (or equivalent experience)
• 3+ years of experience in a Business Intelligence, Data Analyst, or similar analytics role
• Demonstrated experience building production-ready reports and dashboards for business users
• SQL (advanced querying, joins, performance optimization)
• Big-data processing platforms or similar cloud-based analytics platforms certificaton is required.  If candidate does not have the certification upon hire, must obtain certification within 6 months of employment
• Experience building and maintaining enterprise reports and dashboards
• Strong understanding of relational databases and data warehouses
• Proficiency with Excel for analysis and validation
• Familiarity with claims data concepts such as loss trending, catastrophes, severity, frequency, and cycle time
• Experience working with large, complex datasets in a regulated environment
• Exposure to data governance, data quality, or regulatory reporting
• This position is not eligible for visa sponsorship now or in the future.

We are proud to offer our employees, their domestic partners, and their children, a wide range of insurance benefits:

• Two options for your health insurance plan (PPO or High Deductible)
• Prescription drug coverage (included in your health insurance plan)
• Vision and dental insurance plans
• Short and Long Term Disability coverage
• Supplemental Life and AD&D plans that you can purchase for yourself and dependents (includes spouse/domestic partner and children)
• Voluntary Benefit plans that supplement your health and life insurance plans (Accident, Critical Illness and Hospital Indemnity)

In addition to the above insurance offerings, our employees also enjoy:

• A robust 401k plan with up to a 5% employer match
• A retirement savings plan that is 100% company funded
• Paid time off that begins with 24 days each year, with more days added when you celebrate milestone service anniversaries
• Eligibility to receive a yearly bonus as a Munich Re employee
• A variety of health and wellness programs provided at no cost
• A hybrid environment that gives you a choice in where and how you get work done
• A corporately subsidized on-site cafeteria as well as a We Proudly Serve coffee shop
• An on-site complimentary workout facility as well as walking trails on campus grounds
• On-site wellness center complete with nurse practitioner
• Financial assistance for adoptions and infertility treatment
• Paid time off for eligible family care needs
• Tuition assistance and educational achievement bonuses
• A corporate matching gifts program that further enhances your charitable donation
• Paid time off to volunteer in your community

At American Modern, a subsidiary of Munich Re, we see Diversity and Inclusion as a solution to the challenges and opportunities all around us. Our goal is to foster an inclusive culture and build a workforce that reflects the customers we serve and the communities in which we live and work. We strive to provide a workplace where all of our colleagues feel respected, valued and empowered to achieve their very best every day. We recruit and develop talent with a focus on providing our customers the most innovative products and services.  

We are an equal opportunity employer. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.