Data Modeler

Smart IT Frame LLC; Town of Florida (NY); On-site; USD 100,000 - 140,000; Full time

Job summary

Smart IT Frame LLC is seeking an experienced Data Modeler with expertise in Enterprise Data Modelling, Databricks Lakehouse, and Azure Data Platforms. The role focuses on designing scalable conceptual, logical, and physical data models to support data modernization, analytics, reporting, and AI/ML initiatives.

Insurance domain experience is highly preferred. You will collaborate with Business Analysts and Data Architects to translate business requirements into robust data models and data

Qualifications

• Experience in conceptual, logical, and physical data modeling.
• Design models for Databricks Lakehouse Bronze, Silver, and Gold layers.
• Expertise in Dimensional Modeling, Star Schema, Snowflake Schema, and Data Vault.
• Strong knowledge of Azure Databricks, Delta Lake, and Spark.
• Experience with Source-to-Target Mapping, Data Lineage, and Data Quality.
• Advanced SQL and Data Analysis skills.
• Experience with large-scale Data Warehouse, Data Lake, and Data Modernization programs.
• Ability to translate business requirements into scalable data models while working with Business Analysts, Data Architects

Responsibilities

• Design scalable conceptual, logical, and physical data models.
• Support data modernization, analytics, reporting, and AI/ML initiatives.
• Collaborate with Business Analysts and Data Architects to translate requirements.

Job description

We are seeking an experienced Data Modeler with strong expertise in Enterprise Data Modelling, Databricks Lakehouse, and Azure Data Platforms. Insurance domain experience is highly preferred. The candidate will design scalable conceptual, logical, and physical data models supporting data modernization, analytics, reporting, and AI/ML initiatives.

Must-Have Skills

• Strong experience in Conceptual, Logical, and Physical Data Modeling.
• Experience designing models for Databricks Lakehouse Bronze, Silver, and Gold layers.
• Expertise in Dimensional Modeling, Star Schema, Snowflake Schema, and Data Vault.
• Strong knowledge of Azure Databricks, Delta Lake, and Spark.
• Experience with Source-to-Target Mapping, Data Lineage, and Data Quality.
• Advanced SQL and Data Analysis skills.
• Experience with large-scale Data Warehouse, Data Lake, and Data Modernization programs.
• Ability to translate business requirements into scalable data models while working with Business Analysts, Data Architects,