Job Summary

We are seeking an experienced Data Modeler with strong expertise in enterprise data modeling, Databricks Lakehouse architecture, and Azure Data Platform technologies, along with Insurance domain experience. The ideal candidate will have hands-on experience developing conceptual, logical, and physical data models, designing Bronze, Silver, and Gold layer structures, and supporting large-scale data warehouse, data lake, and data modernization programs. The candidate will collaborate closely with Business Analysts, Data Architects, and Engineering teams to translate business requirements into scalable, governed, and high-quality data models.

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.
• Design data models supporting Databricks Lakehouse Architecture across Bronze, Silver, and Gold layers.
• Apply dimensional modeling concepts, including Star Schema, Snowflake Schema, and Data Vault.
• Develop Source-to-Target Mapping documents and support data migration activities.
• Collaborate with Data Architects and Engineering teams to design curated Silver and Gold layer data structures.
• Support data lineage, data quality, governance, and consistency across enterprise data platforms.
• Ensure data models are scalable and aligned with enterprise data architecture standards.
• Support large-scale Data Warehouse, Data Lake, data modernization, and cloud transformation initiatives.
• Participate in data model reviews, architecture discussions, and data governance processes.
• Perform advanced SQL development and data analysis to support modeling and data requirements.
• Collaborate with Business Analysts, Data Architects, Engineering teams, and business stakeholders to understand requirements and develop effective data solutions.
• Participate in data discovery workshops and translate business requirements into technical data models.
• Support data modernization and migration initiatives through data analysis, mapping, and model redesign.

Required Qualifications
• Strong experience in Enterprise Data Modeling, including Conceptual, Logical, and Physical Data Models.
• Experience designing data models for Databricks Lakehouse Architecture across Bronze, Silver, and Gold layers.
• Expertise in Dimensional Modeling, including Star Schema, Snowflake Schema, and Data Vault concepts.
• Strong knowledge of Azure Databricks, Delta Lake, and Spark-based data platforms.
• Experience with Source-to-Target Mapping, Data Lineage, and Data Quality Frameworks.
• Advanced SQL and Data Analysis skills.
• Experience working with large-scale Data Warehouse, Data Lake, and Data Modernization programs.
• Ability to collaborate with Business Analysts, Data Architects, and Engineering teams to translate business requirements into scalable data models.
• Strong Insurance domain experience.

Preferred Qualifications
• Experience with Azure Data Factory (ADF).
• Experience with Microsoft Purview.
• Experience with Unity Catalog and Data Governance Frameworks.
• Experience with Snowflake Data Platform.
• Experience with Power BI and Semantic Modeling.
• Experience with Python and PySpark.
• Knowledge of Data Mesh and Data Product Architecture.
• Experience with Insurance, Financial Services, or Data Modernization projects.

Soft Skills
• Strong stakeholder communication and requirement gathering skills.
• Ability to conduct data discovery workshops with business users.
• Excellent analytical and problem-solving capabilities.
• Strong documentation and presentation skills.
• Ability to work effectively in Agile/Scrum teams.
• Self-driven with a strong ownership mindset and attention to detail.
• Strong collaboration and mentoring abilities across cross-functional teams.

Primary Skills
• Data Modeling
• Databricks Lakehouse
• Azure Data Platform
• Insurance Domain Experience

Secondary Skills
• Azure Data Factory
• Microsoft Purview
• Unity Catalog
• Data Governance
• Snowflake
• Power BI
• Semantic Modeling
• Python
• PySpark
• Data Mesh
• Data Product Architecture