Data Mapping/Business Analyst (ALIP, ACORD, Life Insurance)

Intellibus; New York (NY); On-site; USD 90,000 - 120,000; Part time

Job summary

A data solutions company seeks a skilled Data Mapping/Business Analyst in New York to lead data migration and integration projects. The ideal candidate will have over 10 years of experience in the Life and Annuity Insurance industry, with expertise in the ALIP platform and ACORD standards. Responsibilities include managing data mapping requirements, defining transformation rules, and collaborating with various departments. This is a contract position at the mid-senior level offering the opportunity to play a critical role in modernization initiatives.

Qualifications

• 10-12+ years of experience as a Data Analyst, Business Analyst, or similar role in the Life and Annuity Insurance industry.
• Mandatory hands-on experience with the ALIP platform data structures and functionality.
• Proven expertise in ACORD standards and models, specifically for Life Insurance and Annuities.
• Proficiency in data mapping and data transformation logic across XML, JSON, and flat files.
• Strong SQL skills for data querying, analysis, and validation.
• Solid understanding of the end-to-end life insurance business lifecycle.

Responsibilities

• Analyze and manage data mapping requirements for system conversions and integrations involving the ALIP platform.
• Develop data transformation rules and document source-to-target data mappings.
• Elicit and document business requirements from stakeholders for life insurance modernization.

Job description

Data Mapping/Business Analyst (ALIP, ACORD, Life Insurance)

We are seeking a highly skilled and experienced Data Mapping/Business Analyst to join our team. The successful candidate will play a critical role in major data migration, conversion, and integration projects, leveraging deep knowledge of ALIP (Admin Server, Life Insurance Platform), ACORD standards, and the Life Insurance domain. This role requires exceptional analytical skills, proficiency in data modeling and mapping, and the ability to translate complex business requirements into detailed technical specifications.

Responsibilities

• Analyze, document, and manage data mapping requirements for system conversions, integrations, and upgrades involving the ALIP platform.
• Analyze and map ACORD XMLs, JSON, flat files, and legacy data into target logical models.
• Define and document source-to-target data mappings for various data elements, including policy, product, party, claims, and financial data.
• Develop data transformation rules and logic for complex data elements.
• Demonstrate strong working knowledge of the ALIP platform's data model and functionality for various life and annuity products.
• Apply expertise in ACORD standards (e.g., ACORD XML, ACORD Life standards) to facilitate effective data exchange and interoperability.
• Conduct gap analysis between ACORD standards, source data, and target BRx models (Business Rules/Requirements models).
• Ensure all data mapping and integration solutions adhere to industry best practices and ACORD messaging specifications.
• Elicit, analyze, and document business requirements from stakeholders across various departments (Actuarial, Operations, IT, etc.) for life insurance modernization initiatives.
• Translate high-level business needs into detailed functional and non-functional specifications, including use cases and process flows.
• Serve as the subject matter expert (SME) for life insurance products, business processes, and related data structures.
• Validate that implemented solutions meet the original business requirements through rigorous testing and review.
• Collaborate with data architects, developers, and testers to ensure the accuracy and integrity of data transformations.
• Facilitate meetings and workshops with technical and business teams to resolve data and business process conflicts.
• Create and maintain essential project documentation, including Business Requirements Documents (BRD), Functional Specifications Documents (FSD), and Data Dictionaries.

Required Qualifications

• 10-12+ years of experience as a Data Analyst, Business Analyst, or similar role, preferably within the Life and Annuity Insurance industry.
• Mandatory hands-on experience with the ALIP platform data structures and functionality.
• Proven expertise in ACORD standards and models, specifically related to Life Insurance and Annuities.
• Demonstrated proficiency in data mapping and developing detailed transformation logic across various data formats ( XML, JSON, flat files ).
• Strong SQL skills for data querying, analysis, and validation.
• Solid understanding of the end-to-end life insurance business lifecycle, including new business, underwriting, policy administration, billing, and claims.
• Excellent communication, presentation, and interpersonal skills.

Our Process

• Schedule a 15 min Video Call with someone from our Team.
• 1 Proctored GQ Test (<2 hours).
• Slideware (Presentation Deck).
• Receive Job Offer.

If you are interested in reaching out to us, please apply and our team will contact you within the hour.

Seniority level

Mid-Senior level

Employment type

Contract

Job function

Research, Analyst, and Information Technology

Industries

IT Services and IT Consulting