ScaleneWorks INC

Data Modeler Lead

⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for a Data Modeler Lead in San Diego, CA, on a contract basis. Requires 12+ years in Data Modeling, expertise in the Insurance domain, and proficiency with Snowflake, Erwin Data Modeler, and SQL.
🌎 - Country
United States
💱 - Currency
$ USD
-
💰 - Day rate
Unknown
-
🗓️ - Date
March 17, 2026
🕒 - Duration
Unknown
-
🏝️ - Location
On-site
-
📄 - Contract
Unknown
-
🔒 - Security
Unknown
-
📍 - Location detailed
San Diego, CA
-
🧠 - Skills detailed
#dbt (data build tool) #ERWin #Physical Data Model #XML (eXtensible Markup Language) #Data Modeling #Microsoft Power BI #Data Mart #Data Warehouse #BI (Business Intelligence) #Snowflake #SQL (Structured Query Language) #Data Analysis #JSON (JavaScript Object Notation)
Role description
Job Title :: Data Modeler Lead Location :: San Diego, CA (Onsite) Job Type: Contract JD: • Experience Required: 12+ years hands-on in Data Modeling with Insurance domain background. Responsibilities & Skills • Data Modeling: Logical and Physical Data Models for Snowflake Data Warehouse/Data Mart layers. • Tools: Strong experience with Erwin Data Modeler. • SCD Types: Developing SCD1, SCD2, and SCD3 dimension models. • Technical Stack: Snowflake, DBT pipelines, Power BI, and SQL. • Data Analysis: Handling JSON/XML structures, schema interpretation, and source payload analysis. • Domain Expertise: Workers Compensation (WC), Commercial Multi-Peril (CMP), Excess Surplus (ES), and Excess Casualty. Regards,