Sr. Business Intelligence Analyst

American Modern Insurance Group; Cincinnati (OH); Hybrid; USD 85,000 - 120,000; Full time

Benefits offered by this job

Health insurance options (PPO/HDHP)

401k with employer match

Paid time off 24 days + milestones

Hybrid work model

Tuition assistance

Job summary

American Modern Insurance Group, Inc., a Munich Re company, seeks a Senior Business Analyst to drive data-informed decisions across sales, marketing, and customer experience. You will deliver analytics, build dashboards, and collaborate with cross-functional teams to translate complex data into actionable insights.

The position emphasizes Power BI/DAX, SQL, and advanced analytics in a hybrid environment across the United States, with opportunities to influence analytics-driven changes in the

Qualifications

• Bachelor’s degree or equivalent in Finance, Mathematics, or Statistics.
• Complete AINS 21 and 22.
• Microsoft PL-300 certification preferred; must be completed within 3 months if not held at hire.

Responsibilities

• Facilitate meetings, gather requirements, and communicate project changes clearly.
• Build shared understanding of problems and outline project parameters.
• Deliver analytics for sales, marketing, and customer experience using data.
• Develop and maintain dashboards and visualizations with Power BI/DAX.
• Work with multi-source data and automate reporting processes.

Skills

Analytical thinking

Business acumen

Microsoft Office

SQL

Python

Power BI & DAX

Education

Bachelor’s degree in Finance/Math/Statistics

Intro to Insurance knowledge

AINS 21 & 22

PL-300 Power BI certification (preferred)

CPCU/Master’s (preferred)

Tools

Power BI

Excel

SQL

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

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

Additional Benefits

• 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

About Our Culture and Inclusion

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.

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.