Actuarial Data Engineer

Company
American Modern Insurance Group
Location
Cincinnati , United States

Title: Actuarial Data Engineer

Location: current schedule is hybrid (40-50% in the Amelia, Ohio office)

Recruiter: Sonya Fischesser

Exempt position

Posting end date: 02/14/2025

 

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.

 

 

Purpose:

Through the development and maintenance of data, systems, and tools, enable the evaluation of risk and profitability, customer experience and operational improvement for the organization.

 

Roles & Responsibilities:

• Contribute to the strategic and tactical planning, development, evaluation, and coordination of the information and technology systems for the department, division, or organization, where applicable.
• Participate in projects that support the analysis, evaluation, and modeling of potential solutions analytical methods and processes that enable meeting the experience, operational, or financial profitability and/or production goals of the company. Work with  management and corporate areas to understand and incorporate strategic direction.
• Complete and prioritize multiple activities for assigned area. Balance sometimes conflicting goals.
• Create and deliver value-added services to clients/company, integrating information from other areas into the AMIG enterprise system, databases, and models.
• Participate in the development, maintenance, and enhancement of analytics, data management, predictive modeling analyses, and ad hoc work products into system-based solutions. Translate complex business needs into system designs and specifications.
• Contribute to the evaluation, selection, implementation, and maintenance of the enterprise internal information systems by supporting the evaluation of alternatives and performing appropriate cost benefit analysis.
• Interact with internal and external contacts to improve quality and knowledge of work product. 
• Participate in the architecture/design and building of  new automated solutions and procedures for the department, division, and organization.
• Participate in various activities, client visits, or audits as needed.  Act as liaison on information technology discussions as appropriate for the functional area. Maintain current knowledge of trends and products in the system technology industries and address the need for development of new methods, products, and procedures.
• Train associates and other relevant areas regarding new and enhanced system solutions and system options, including advanced data, systems, and tools training specific to daily tasks.
• Contribute to the creation of and follow standards of documentation, quality control, data governance, and Software Development Life Cycle (SDLC) methodology, including design, peer, and code review as well as ICS and IDP policies/controls. May participate in testing of internal controls for other units within the department.
• Be a steward of data quality at AMIG; identify issues and areas for improvement. Take known issues to Data Governance and represent the department in efforts to correct data issues and promote data quality for the broader organization. 
• Create exhibits and visualizations of data that clarify and illuminate issues and insights in complex data.
• Create data sets to be used by analysts that combine multiple complex data sources into a format that is suitable for analysis.
• Explore alternative internal and external data sources. 

 

Required Technical Skills:

• Strong/In-depth knowledge of systems and data structures, with applicability towards (re)insurance operations, such as Azure SQL and Databricks.
• Strong project management skills and experience.
• Expert working knowledge of analytical tools including, MS Excel and Access, VBA, TM1, Cognos, SAS, R, Power BI, Python.
• Expert knowledge of  SQL.
• Knowledge of actuarial techniques, property/casualty (re)insurance, accounting, and finance.
• In depth analytical and mathematical skills.
• Strong knowledge of industry source of information.

 

Education, Certifications & Designations:

Graduate degree in Information Systems, Actuarial Science, Mathematics, Statistics, Economics or related field.  

OR

Equivalent experience and bachelor degree in Information Systems Actuarial Science, Mathematics, Statistics, Economics or related field. 

 

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

 

#LI-SF1