Data Modeler

1 week ago

Los Angeles, CA, United States Purple Drive Full time
Job Title: Data Modeler

Location: Onsite - Woodland Hills or Los Angeles, CA

Experience: 10+ Years

Job Description

We are seeking a highly skilled Data Modeler with extensive experience in the Property & Casualty (P&C) Insurance domain. The ideal candidate will design scalable and high-performance data models, working closely with business and technical teams to support enterprise data initiatives across Snowflake, Guidewire, and legacy platforms.

Technical Skills Required

  • Snowflake
  • DBT
  • Erwin (or equivalent data modeling tools)
  • Strong SQL skills
  • Deep understanding of relational & dimensional modeling
Key Responsibilities

  • Design and develop logical and physical data models supporting P&C insurance business processes.
  • Collaborate with Business Analysts to define and document data mapping rules from Guidewire and legacy systems.
  • Optimize physical models for performance, scalability, and cost-efficiency within Snowflake.
  • Ensure adherence to business requirements, technical standards, and data governance guidelines.
  • Work closely with developers to validate that integration and transformations align with approved models.
  • Maintain version-controlled documentation for data models, mappings, and transformation logic.
  • Provide support for model implementation, troubleshooting, and continuous enhancement.
  • Participate in data quality assessments, model validation, and performance tuning.
  • Offer guidance and training to cross-functional teams on data model interpretation and usage.
Required Experience & Skills

  • 10+ years of experience in data modeling and data architecture roles.
  • Strong background in the P&C Insurance domain with hands-on experience designing data models for systems like Guidewire.
  • Expertise using tools such as Erwin for modeling.
  • Strong understanding of relational, dimensional, and canonical modeling concepts.
  • Proficiency in SQL and data validation techniques.
  • Excellent analytical, communication, and stakeholder collaboration skills.
Nice to Have

  • Experience with Snowflake cloud data platform.
  • Exposure to Guidewire and Legacy/Mainframe systems.
  • Familiarity with ETL/ELT processes, metadata management, and general data governance practices.

  • Senior Data Modeler

    7 days ago

    Los Angeles, CA, United States Purple Drive Full time

    Job Summary We are seeking an experienced Data Modeler to design and maintain robust, scalable, and efficient data models that enable seamless data flow across transactional, analytical, and lake house systems. The ideal candidate will have strong expertise in SQL, data modeling tools (Erwin/ER Studio), and experience with cloud data platforms and Master...

  • Data Modeler-Snowflake

    7 days ago

    Los Angeles, CA, United States Artech Full time

    Location: Los Angeles, CA Required Skills & Qualifications Applicants must be able to work directly for Artech on W2 Proven experience working on data models in the P&C Insurance domain Hands-on experience with data modeling tools (e.g., Erwin) Strong understanding of relational and dimensional modeling concepts Proficient in SQL and data validation...

  • Senior Data Scientist, Advanced Risk Modeling

    6 days ago

    Los Angeles, CA, United States Oscar Health Full time

    Hi, we're Oscar. We're hiring a Senior Data Scientist to join our Data Team. Oscar is the first health insurance company built around a full stack technology platform and a relentless focus on serving our members. We started Oscar in 2012 to create the kind of health insurance company we would want for ourselves-one that behaves like a doctor in the family....

  • Senior Data Scientist, Advanced Risk Modeling

    10 hours ago

    Los Angeles, CA, United States Oscar Health Full time

    Hi, we're Oscar. We're hiring a Senior Data Scientist to join our Data Team. Oscar is the first health insurance company built around a full stack technology platform and a relentless focus on serving our members. We started Oscar in 2012 to create the kind of health insurance company we would want for ourselves-one that behaves like a doctor in the family....

  • Lead Data Modeler

    7 days ago

    Los Angeles, CA, United States Right Skale, Inc. Full time

    Lead Data Modeler - Contract - South Bay area - On-site As a Lead Data Modeler/ Data Solutions architect, you will architect, build, and maintain a data warehouse and analytics infrastructure in support of our business analytics and data reporting. The infrastructure created by this team is critical in the team's mission to support and provide insights to...

  • Lead Data Modeler

    17 hours ago

    Los Angeles, CA, United States Right Skale, Inc. Full time

    Lead Data Modeler - Contract - South Bay area - On-site As a Lead Data Modeler/ Data Solutions architect, you will architect, build, and maintain a data warehouse and analytics infrastructure in support of our business analytics and data reporting. The infrastructure created by this team is critical in the team's mission to support and provide insights to...

  • Data & Dashboards Specialist (Data Centers)

    7 days ago

    Los Angeles, CA, United States Jacobs , LLP Full time

    This job opportunity is available at ANY location in the United States. Ideally, selected candidates will be near a JACOBS U.S. based office, but we intend to hire the "best" candidates. We are looking for a Data & Dashboards Specialist (Power BI) to transform design, construction, and model data into clear, action-oriented insights for our data center...

  • Data & Dashboards Specialist (Data Centers)

    1 week ago

    Los Angeles, CA, United States Jacobs , LLP Full time

    This job opportunity is available at ANY location in the United States. Ideally, selected candidates will be near a JACOBS U.S. based office, but we intend to hire the "best" candidates. We are looking for a Data & Dashboards Specialist (Power BI) to transform design, construction, and model data into clear, action-oriented insights for our data center...

  • Data Engineer

    2 weeks ago

    Los Angeles, CA, United States Diverse Lynx Full time

    ROLE: DBT LeadDescription: Snowflake, DBT, ETL, ELT "We are seeking a highly skilled DBT Data Engineer / Developer to design, develop, and optimize scalable ELT pipelines and data models using DBT and Snowflake. You will play a key role in ensuring data quality, driving architectural decisions, and enabling analytics across the organization through...

  • Data Scientist

    7 days ago

    Los Angeles, CA, United States RAPP Full time

    RAPP Los Angeles is looking for a Data Scientist to join our award-winning Marketing Sciences team.WHO WE ARE: We are RAPP - world leaders in activating growth with precision and empathy at scale. As a global, next-generation precision marketing agency we leverage data, creativity, technology, and empathy to foster client growth. We champion individuality in...