Automation Analyst

Company
American Modern Insurance Group
Location
Cincinnati , United States

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 $1.9 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.

 

Financial Compliance is a division in the Finance / Accounting department of American Modern that performs testing to validate compliance with various Financial and Accounting compliance requirements and standards, specifically Model Audit Rule (MAR) and Sarbanes Oxley (SOX). Initiatives are underway to automate this testing using Python, and additional technologies including, but not limited to structured query language (SQL), application program interfaces (APIs), and PowerBI. To further support this initiative, we are looking for a motivated and enthusiastic individual with experience in Python programming and other technologies. Employees are typically in the office 40-50% of the time to allow for face to face collaboration.  Candidates must be located near our corporate office (Amelia, OH).  

 

Responsibilities:

• Develop, test, and maintain complex Python scripts to automate testing in various areas of Insurance.
• Derive and determine technical and functional specifications from previous documented testing.
• Meet with internal clients to understand and document business processes to translate into technical and functional requirements.
• Develop SQL queries to extract, filter, and manipulate data from source systems and data warehouses to support testing requirements.
• Develop integrations between American Modern and vendor systems using REST API integrations using and Python.
• Develop PowerBI dashboards for result, summary, and trend reporting.
• Document code, processes, and procedures for internal audit and external regulatory requirements.
• Maintain relationships with stakeholders and communicate results on a regular basis.
• Communicate status and progress of current progress to manager and internal team on a regular basis.

 

Qualifications:

• Bachelor’s Degree in Computer Science, Information Systems, Engineering, or related fields.
• Proficient in Python programming, including, but not limited to libraries, such as Pandas, SQLAlchemy, Requests, OracleDB / cx_Oracle. Three or more years of experience in Python development is preferred.
• Experience in managing a Python environment via Pip.
• Experience with Git and GitHub for version control of code.
• Proficient in SQL and experience with both Oracle and MS SQL Server database syntaxes.
• Experience configuring and calling REST APIs is a plus.
• Experience with Azure DevOps and Service Now is a plus.
• Proficient in Microsoft Office Suite and experience with PowerBI. Additional experience with Power Automate is a plus.
• Strong analytical and communication skills.
• Ability to work effectively with internal clients and as a team, documenting processes, and translating them into technical and functional requirements.
• Knowledge of software development (SDLC) methodologies.

 

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.
• Additional insurance coverages provided at no cost to you, such as basic life insurance equal to 1x annual salary (up to $500k) and AD&D coverage that is equal to 1x annual salary (up to $500k).
• 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.
• 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.