The Frankenmuth Insurance Company logo: Circular emblem with bold

Business Systems Analyst- Data Warehouse

Virtual Req #80
Monday, January 8, 2024

Summary:  Under moderate supervision and following standard procedures with some independent judgment, analyzes, designs, and coordinates the implementation of business applications and systems or enhancements by performing the following duties.


Essential Duties and Responsibilities:


  1. Analyzes, develops and leads the execution of efficient and cost effective project plans for system design within limited area of responsibility. Lead intermediate level projects established as corporate priorities.  
    1. Prepares project plan by gathering, analyzing and making recommendations based on client input. Coordinate with client throughout project lifecycle.
    2. Acts as the subject matter expert.
    3. Maintains a mutual understanding of project direction with programming staff.
    4. Balances project priorities and ensures deadlines are met through effective management of scope creep.


  1. Designs business application solutions by interfacing with the client and internal resources within limited area of responsibility.
    1. Creates supporting documentation for new application features and functions.
    2. Designs and develops high-level functional requirements for new development and enhancements of applications, products, and services.
    3. Transforms functional requirements into system specifications by writing clear and concise application requirements documents.


  1. Tests and implements the application, product, and/or service and provides the programmer/developer with feedback throughout project lifecycle.
    1. Defines detailed test plan and acceptance criteria.
    2. Participates in problem definition, analysis, and develops creative and cost effective solutions.
    3. May be required to participate in an on-call program during non-business hours on a rotating or periodic basis.


  1. May effectively coordinate and execute end user training.


  1. May effectively facilitate successful moderate problem resolution along with system enhancement and provide support within multiple areas of responsibility.


  1. Performs other duties as assigned





To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.



Level 5:   Bachelor’s degree (B.A.) from four-year college or university; or four to six years related experience and/or training; or equivalent combination of education and experience.

A minimum requirement for this position is the ability to work legally in the United States. No visa sponsorship/support is available for this position, including for any type of U.S. permanent residency (green card) process.

Other details

  • Pay Type Salary
This posting is inactive.