This position performs as the data subject matter expert in the development and deployment of new TPA (Third Party Administrators) and Direct client programs to the AIM business system, and the migration of clients from the Legacy AIZ business system to AIM. Responsible for the review and deployment of client data during scheduled AIZ and AIM month end completions. Compiles and/or executes database queries and performs Quality Assurance testing on system modifications/enhancements and conversions/migrations of client business to the database application. Identifies client data rejects and reasons. Works with client and internal staff in Underwriting, Marketing, and Actuarial to resolve the issues timely and accurately.
Compiles client specific detailed Data Change Request (DCR) documents and works with IT development to ensure and test the successful deployment of the DCR's requested. Compiles and maintains documentation pertinent to monthend processes and control procedures and develops data flow diagrams. Provides support for financial results and satisfies audit requests relative to assigned clients. Supports process improvement projects and provides feedback on suggested changes in processes to improve controls and efficiencies. Focuses on Direct and TPA clients and programs. Typically works independently under limited supervision.
Participate as the TPA data subject matter expert in the development and deployment of new client programs being on-boarded to the AIM business system and historical client program migrations from the Legacy AIZ business system to the AIM business system. Review and/or compile system requirements/enhancements for handling client data in an efficient and standardized manner. (60%)
Processes third party batch data for month end execution on the AIM databases, testing for data integrity and results of data validation edits. Reconciles client data to control totals and client remittances and analyzes variances from expected results. (10%)
Identifies data reject reasons and works with the client and internal staff in Underwriting, Marketing, and Actuarial to mitigate data and/or table issues in a timely and accurate manner. Facilitates sessions to review rejects and develop the appropriate course of action required to mitigate same. (10%)
Compiles and/or executes database queries and performs Quality Assurance testing to validate system modifications/enhancements and conversions/migrations of client business to AIM. (10%)
Works with clients and AIZ departments, including IT, Finance, Underwriting, Actuary, and Marketing, to ensure business processing requests are fulfilled timely and accurately. (5%)
Compiles and maintains TPA process and procedure documentation and data flow diagrams. Recommend and propose to management changes and improvements to existing procedures and processes. (5%)
B.S. in Accounting, Information Technology, or Finance
3 - 6 years technology, accounting or finance experience
Organization skills and attention to detail
Ability to multitask and prioritize assignments
Time management skills to stay focused and meet deadlines
Effectively manage changing priorities
Querying of relational databases (SQL preferred)
Proficiency in Microsoft Excel, Outlook, Visio, Access.
Strong problem solving abilities
Analytical mind set and desire to determine root causes for data anomalies
Excellent verbal and written communication skills
Minor in Information Technology, Accounting, or Finance (depending on degree)
2-3 years of experience in IT, Data Analysis, or Project Management
Familiarity with Insurance terminology
Insurance accounting experience a plus
Understanding of database theory and experience working with databases is preferred.
Experience with SharePoint and Microsoft PowerPoint a plus
Experience with business systems and/or PeopleSoft or other Enterprise Resource Management system a plus
Muestra tus habilidades a la empresa, rellenar el formulario y deja un toque personal en la carta, ayudará el reclutador en la elección del candidato.
- • Coordina, controla, evalúa y supervisa las actividades del personal a su cargo. • Diseña, elabora y aplica sistemas de control de asistencia del personal a su cargo. • Verifica pedid [...]
Bucaramanga, Santander Por contrato Médico general, con 2 años de experiencia a partir de su grado. Con respeto hacia las directrices propias de sus funciones y compromiso hacia su profesión. Ti [...]
Bogotá, Cundinamarca Tiempo completo, Indefinido $943.302 - $1.200.000 al mes Reconocida Cadena de comidas rápidas se encuentra en la búsqueda de personas comprometidas, honestas, colaboradoras [...]
Bello, Antioquia Tiempo completo, Indefinido $877.803 al mes Se requiere personal para laboral en servicio al cliente, para realizar las siguientes funciones: toma de pedidos, facturación,atenció [...]