Data Modeler C2C jobs with Insurance domain experience

Data Modeler Primary Skill Data Modeling Databricks Lakehouse Azure Data Platform with Insurance domain experience

Location Dayton FL Onsite

 

Must Have Skills

1   Strong experience in Enterprise Data Modeling including Conceptual Logical and Physical Data Models

2   Experience designing data models for Databricks Lakehouse Architecture Bronze Silver Gold layers

3   Expertise in Dimensional Modeling Star Schema Snowflake Schema and Data Vault concepts

4   Strong knowledge of Azure Databricks Delta Lake and Sparkbased data platforms

5   Experience in SourcetoTarget Mapping Data Lineage and Data Quality Frameworks

6   Advanced SQL and Data Analysis skills

7   Experience working with largescale Data Warehouse Data Lake and Data Modernization programs

8   Ability to collaborate with Business Analysts Data Architects and Engineering teams to translate business requirements into scalable data models

Secondary Nice To Have Skills Not Mandatory

1  Azure Data Factory ADF

2  Microsoft Purview

3  Unity Catalog and Data Governance Frameworks

4  Snowflake Data Platform

5 Power BI and Semantic Modeling

6  Python  PySpark

7 Data Mesh and Data Product Architecture

8 Insurance Financial Services or Data Modernization project experience

Soft Skills

1Strong stakeholder communication and requirement gathering skills

2  Ability to conduct data discovery workshops with business users

3  Excellent analytical and problemsolving capabilities

4 Strong documentation and presentation skills

5 Ability to work in AgileScrum teams

6 Selfdriven with ownership mindset and attention to detail

7 Collaboration and mentoring abilities across crossfunctional teams

 

Key Responsibilities

Design and maintain conceptual logical and physical data models for enterprise data platforms

Define data entities attributes relationships and business rules for Lakehouse implementations

Develop SourcetoTarget Mapping documents and support data migration activities

Collaborate with Data Architects and Engineering teams to design curated Silver and Gold layer data structures

Ensure data governance quality consistency and scalability across the platform

Support data modernization and cloud transformation initiatives

Participate in data model reviews architecture discussions and governance processes

3 Qualifying Questions

1  Can you explain a Databricks Lakehouse data model that you designed and how it supported Bronze Silver and Gold layer data curation

2  Describe a data modernization or migration project where you created sourcetotarget mappings and redesigned the target data model What challenges did you encounter

3 How would you model customer policy or transaction data to support both reporting and future AIML use cases while maintaining scalability and governance.

 

 

 

Neha Chaudhary Team Lead – Recruitment e: neha.chaudhary@compunnel.com  o: (+1) 609-606-9010 ext.2469 m: (+1) 732-743-9949  HQ: 4390 Route 1 North, Suite 302, Princeton, NJ 08540, USA.