Data Modeler II

Are you looking to make an impactful difference in your work, yourself, and your community? Why settle for just a job when you can land a career? At ICW Group, we are hiring team members who are ready to use their skills, curiosity, and drive to be part of our  journey as we strive to transform the insurance  carrier space. We're proud to be in business for over 50 years, and its change agents like yourself that will help us continue to deliver our mission to create the best insurance experience possible.

Headquartered in San Diego with regional offices located throughout the United States, ICW Group has been named for ten consecutive years as a Top 50 performing P&C organization offering the stability of a large, profitable and growing company combined with a focus on all things people. It's our team members who make us an employer of choice and the vibrant company we are today. We strive to make both our  internal and external communities better everyday! Learn more about why you want to be here!

PURPOSE OF THE JOB

The purpose of the Data Modeler II is to provide expertise in data modeling concepts and modern cloud data platforms, particularly AWS, Snowflake, and DBT. This role will be instrumental in designing and optimizing data models that support actuarial analysis, policy processing, claims processing, underwriting, compliance reporting, and overall business intelligence needs specific to the insurance industry.

ESSENTIAL DUTIES AND RESPONSIBILITIES

• Designs and implements scalable data models (conceptual, logical, and physical) tailored for Workers Compensation Insurance data such as claims, policies, premiums, exposures, and provider networks.

• Builds and maintains data pipelines using DBT to transform raw insurance-related data into structured formats within Snowflake.

• Collaborates with stakeholders to gather requirements and develops fit-for-purpose data models.

• Ensures compliance with industry regulations and internal data governance standards, particularly around personally identifiable information (PII) and claim-sensitive data.            

• Documents models and data transformations to support audit trails, lineage tracking, and regulatory reporting.

• Defines and enforces data models standard, naming conventions, and best practices to maintain data consistency and quality.

• Works closely with cross-functional teams to understand strategic objectives and translate them into data-driven solutions.

• Participates in the testing and validation of data models.

• Identifies and resolves data modeling issues and provides recommendations for improvements.

• Stays abreast of the latest data modeling techniques and technologies.

SUPERVISORY RESPONSIBILITIES

This position does not have supervisory responsibility.

EDUCATION AND EXPERIENCE

• Bachelor’s degree required in Information Systems, Computer Science, Actuarial Science or related field. Additional experience may be considered in lieu of degree.

• Minimum 3 years of experience in data modeling and architecture, ideally in the insurance or financial services industry.

• Prior experience in Agile/Scrum or SAFe Agile environments is preferred.

CERTIFICATES, LICENSES, REGISTRATIONS

• Technical certifications relevant to AWS and/or data modeling are preferred.

KNOWLEDGE AND SKILLS

• Hands-on experience with Snowflake, including schema design and performance optimization.

• Experience with AWS services and Data Modeling tools.

• Strong understanding of insurance-specific data types and regulatory considerations.

• Excellent SQL skills and knowledge of data warehousing concepts

• Excellent communication and interpersonal abilities.

• Strong attention to detail, analytical and problem-solving skills.

PHYSICAL REQUIREMENTS 

This job operates in a professional office environment.  While performing the duties of this job, the employee is regularly required to talk or hear. The employee frequently will sit, stand, walk, and bend during working hours. Requires manual and finger dexterity and eye-hand coordinati