Sr. Business Intelligence Analyst

Munich RE; Amelia (OH); Hybrid; USD 90,000 - 120,000; Full time

Benefits offered by this job

Health insurance

401k with employer match

Hybrid work environment

Paid time off 24 days/year

On-site cafeteria

Job summary

American Modern Insurance Group, Inc., a Munich Re company, is a recognized leader in specialty insurance, offering products for residential properties, boats, classic cars and more. Headquartered in Amelia, Ohio, we seek a Senior Business Analyst to deliver data-driven insights and visuals to support Sales, Marketing and Customer Experience teams.

You will develop robust data models using Power BI, DAX, and SQL, collaborate with cross-functional teams, and drive analytics initiatives across

Qualifications

• Bachelor's degree or equivalent in Finance, Mathematics or Statistics.
• AINS 21 & 22 completed or in progress.
• Microsoft PL-300 certification preferred at time of hire; must be completed within 3 months if not yet earned.

Responsibilities

• Facilitate meetings, gather requirements, and communicate project status clearly.
• Build shared understanding of problems and outline project parameters.
• Leverage data from multiple sources for analytics and visualization projects.
• Develop and maintain dashboards and visuals to enable stakeholder insights.
• Automate data processes to improve reporting efficiency.
• Apply advanced analytics techniques to enhance reports and decision-making.

Skills

Power BI

DAX

SQL

Python

Analytics

MS Office

Education

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

AINS 21 & 22

Microsoft PL-300: Power BI Data Analyst Associate

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