Sr. Business Intelligence Analyst

Munich Reinsurance America, Inc; Amelia (OH); Hybrid; USD 95,000 - 125,000; Full time

Benefits offered by this job

Health insurance

401k

Paid time off

Hybrid schedule

On-site fitness center

Job summary

American Modern Insurance Group, Inc., a Munich Re company, seeks a Senior Business Analyst to drive analytics across sales, marketing and customer experience. You will build insightful dashboards in Power BI, model data from multiple sources, and automate reporting while guiding cross‑functional teams.

Strong insurance data expertise is required; AINS and PL-300 certifications are highly valued, with a hybrid work environment and opportunities for professional growth.

Qualifications

• Bachelor's degree or equivalent in Finance, Mathematics, Statistics or related field.
• Complete AINS 21 and 22 (First and Second in AINS Designation).
• Microsoft PL-300: Power BI Data Analyst Associate certification preferred at hire; must complete within 3 months if not earned.

Responsibilities

• Facilitate work meetings, ask the right questions, and communicate requirements and testing results clearly.
• Build a shared understanding of problems, outline project parameters, and determine solutions.
• Proven experience as a Senior Business Analyst in insurance data and operations.
• Act as intermediary among clients, developers, users, management, and IT.
• Assess multiple options before guiding the team toward a solution with data-driven judgment.
• Develop and maintain dynamic visualizations and dashboards using Power BI for stakeholders.
• Work with multi-source databases to deliver data and analytics for visualization projects.
• Automate data processes to improve reporting efficiency.
• Utilize DAX and other advanced analytical techniques to build robust data models and calculations.
• Support the transition to an analytics-driven organization as a change agent.

Skills

Power BI

SQL

Python

DAX

Dashboard development

Data visualization

Education

Bachelor's degree or equivalent in Finance/Math/Statistics

AINS 21 & 22

PL-300: Power BI Data Analyst Associate

Tools

Power BI

SQL

Python

Job description

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. We write admitted products in all 50 states and have a premium volume of $2.2 billion.

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.

Purpose

The senior business analyst will provide insights through data analytics that drive strategic business decisions. The senior business analyst does this by providing internal and external customers with the analysis to make informed strategic decisions. Analysts primarily support the sales, marketing and customer experience departments, serving as the central point for analytical themed projects.

Roles & Responsibilities

• Analysts will be expected to facilitate work meetings, ask the right questions, and actively listen to colleagues to take in new information and build relationships. A project's success may revolve around the analyst's ability to communicate things like project requirements, changes, and testing results.
• Business analysts work to build a shared understanding of problems, outline the parameters of the project, and determine potential solutions for their customers.
• Must have proven experience as a Senior Business Analyst or in a similar analytical role, with a strong understanding of insurance data and its impact on business operations.
• Act as an intermediary between a variety of people with various types of personalities: clients, developers, users, management, and information technology (IT).
• Assess multiple choices before leading the team toward a solution. Effectively doing so requires a critical review of data, documentation, and any other element required to deliver the project.
• Developing and maintaining dynamic, insightful visualizations and dashboards using tools like Power BI, enabling stakeholders to easily interpret complex data.
• Work with databases containing data from multiple sources, at various granular levels, to deliver data and analysis for use in analytics and visualization projects.
• Strive to automate existing data processes to improve reporting efficiency.
• Utilize DAX and other advanced analytical techniques to build robust data models and calculations that enhance the quality and depth of reports.
• Act as a change agent during the transition to an analytics-driven organization.

Required Technical Skills

• Strong problem solving, diagnostic, and analytical skills
• Ability to relate numbers and calculations to ideas and business questions
• Proficient in the use of Microsoft Office Suite of tools
• Proficient with SQL
• Experience with Python and distributed big-data processing platforms
• Expertise in Microsoft Power BI, DAX and report/dashboard development

Education, Certifications & Designations

Required

• Bachelor's degree or equivalent experience in Finance, Mathematics, Statistics,
• Introduction to Insurance or equivalent knowledge and skillset covered in the course.
• Complete AINS 21 and 22 (First and Second in AINS Designation)
• Successful completion of the Microsoft PL-300: Power BI Data Analyst Associate certification is preferred at the time of hire
  • Employees who have not earned the certification must successfully complete it within 3 months of employment

Preferred

• CPCU, Master's Degree

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)
• 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)
• Prescription drug coverage (included in your health insurance plan)
• Short and Long Term Disability coverage
• Vision and dental insurance plans

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
• Free parking
• 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.

Sometimes we are fortunate enough to receive a high volume of applications. After reviewing all applications, we will contact only the selected candidates to schedule an interview. We are grateful for all candidates and their interest.

Applicants requiring employer sponsorship of a visa will not be considered for this position.

For the hybrid schedule: Please submit a cover letter with additional information if you're not currently local but intend to relocate for the hybrid schedule.

#LI-SF1