Note: The job is a remote job and is open to candidates in USA. ConglomerateIT provides global workforce solutions and IT services to clients across various domains. The company is seeking an experienced Insurance Data Modeler / Business Analyst to analyze insurance source systems, translate business requirements into data models, and design Atomic Data Vault structures for an enterprise data transformation initiative.
Responsibilities
- Design and develop Atomic Data Vault (ADV) / Data Vault 2.0 models, including Hubs, Links, and Satellites
- Perform Source-to-Target Mapping (STM) across multiple insurance source systems
- Analyze and document P&C insurance data, including policies, claims, billing, underwriting, and financial data
- Translate business requirements into logical and physical data models
- Profile source data and identify business keys, relationships, attributes, and transformation rules
- Collaborate closely with business stakeholders, data architects, and engineering teams
- Maintain data dictionaries, data lineage, mapping documents, and data modeling artifacts
- Support data migration, validation, reconciliation, and data quality activities
- Participate in enterprise data transformation initiatives and ensure data models align with business and technical requirements
Skills
- We are seeking an experienced Insurance Data Modeler / Business Analyst with strong P&C Insurance functional experience, hands-on expertise in Atomic Data Vault (ADV) / Data Vault 2.0 modeling, and Source-to-Target Mapping (STM)
Benefits
- Remote work arrangement
Company Overview
Company H1B Sponsorship