Specialty Clients Functional Analyst



The Functional Analyst will be responsible for creating and maintaining internal documentation related to system changes, requirement updates, and data quality and consistency. Acts as the Specialty Clients technical liaison with other internal business units as it relates to data and external partner systems. Responsible for creating and communicating requirements to external partners and coordinating, and participating in, UAT efforts. The functional analyst will create new Cognos, Power BI reports, and SQL queries to be used within department.

Roles & Responsibilities:
  • Work in partnership with Product Analysts to identify system changes needed as a result of product development
  • Facilitate meetings within Specialty Clients, other internal business groups and external partners. Meetings will include fact gathering, communication of defects, testing needs and results, and potential solutioning
  • Participate in due diligence efforts with respect to new program opportunities
  • Responsible for research, requirements, root cause analysis, and coordinating implementation plan
  • Create business requirements to be distributed to Specialty Clients external partners
  • Provide system expertise involving the off-system processing application
  • Maintain product model and coverage matrix updates for Specialty Clients products
  • Ensure all documentation owned by other areas of the organization is updated appropriately, including but not limited to, technical file requirements
  • Accountable for assigning and monitoring ticketing process to ensure completion.
  • Create Cognos and Power BI reports.
  • Responsible for creating new SQL queries and training Product Analysts on use.
  • Create process documentation and SOP’s for all processes.
  • Represent specialty clients in any corporate data projects.


  • Proficient use of SQL, Cognos, Power BI, Excel
  • Strong understanding of OSPA and AMSuite and how they impact each department
  • Strong written and oral communication skills
  • Understanding of how to create and execute a test plan
  • Understanding of how to create and track tickets using VSTS
  • Critical thinking, problem solving and deep dive analysis
  • Ability to express complex technical concepts

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.

American Modern is a widely recognized, national leader in the specialty insurance business. With close to 50 years of experience in the manufactured housing insurance sector, the company delivers specialized products and services for residential property and the recreational market. One of our newest lines is pet health insurance. The company is headquartered in suburban Cincinnati, Ohio.

American Modern is licensed in all 50 states and offers insurance products through a number of property and casualty companies which serve more than 1.7 million policyholders. As part of its parent company, American Modern’s companies are rated A+ (Superior) by the A.M. Best Company an independent analyst of the insurance industry, and is also a Ward’s 50® Top Performer another well-regarded industry standard of stability and excellence.

American Modern joined Munich Re as a key part of the world reinsurance leader’s North American insurance operations in April 2008. Munich Re has approximately 47,000 employees in over 50 locations throughout the world and operates in all lines of insurance. It is among the top 100 companies on the Forbes Global 500 list.