Insurance Data Modeler / Business Analyst / Data Analyst - Atomic Data Vault

Title: Insurance Data Modeler / Business Analyst / Data Analyst Atomic Data Vault

Location: 100% Remote Milwaukee, WI based

Duration: Long Term Contract

Work Hours: U.S. Core Business Hours

Role Summary

We are seeking an Insurance Data Modeler / Business Analyst with strong Property & Casualty (P&C) Insurance functional experience, hands-on Atomic Data Vault (ADV / Data Vault 2.0) modeling, and Source-to-Target Mapping (STM) expertise. The role will analyze insurance source systems, translate business requirements into data models, and design Hubs, Links, and Satellites for an enterprise data transformation initiative. This is not a pure Data Engineering role; strong insurance domain and data modeling experience are essential.

Responsibilities

• Design and develop Atomic Data Vault (ADV) models including Hubs, Links, and Satellites.
• Perform Source-to-Target Mapping (STM) across insurance source systems.
• Analyze and document Property & Casualty 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 with business stakeholders, data architects, and engineering teams.
• Maintain data dictionaries, lineage, mapping documents, and modeling artifacts.
• Support data migration, validation, reconciliation, and data quality activities.

Must-Have Skills (Priority Order)

Priority Skill

1

Property & Casualty (P&C) Insurance Domain Experience

2

Atomic Data Vault (ADV) / Data Vault 2.0 Modeling

3

Source-to-Target Mapping (STM)

4

Data Modeling Logical & Physical

5

Insurance Data Analysis / Functional Experience

6

Hubs, Links & Satellites Classification

7

Strong SQL & Data Profiling

8

Erwin Data Modeler

Founded in 2014, ConglomerateIT is a global leader in delivering innovative IT solutions and services. Headquartered in the USA with a presence in the UK, Canada, and India, we specialize in offering industry-leading expertise and cutting-edge products that help our clients maximize their technological investments. Our focus on best-in-class solutions, a highly knowledgeable team, and proactive talent mapping ensure we remain at the forefront of the IT industry.

ConglomerateIT is driven by our Center for Excellence and Innovation, an initiative dedicated to keeping us ahead in a rapidly evolving technology landscape. We understand that building strong relationships is key to our success, and this commitment has enabled us to partner with Fortune 500 companies and leading system integrators worldwide. Our ability to provide local talent on a global scale ensures that we can meet the contingent project requirements of our clients efficiently and effectively.