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 coordination. May be required to lift light objects. Requires normal or corrected vision and hearing corrected to a normal range.

WORK ENVIRONMENT 

This position operates in an office environment and requires the frequent use of a computer, telephone, copier, and other standard office equipment.

We are currently not offering employment sponsorship for this opportunity.

#LI-TM1

#LI-HYBRID

The current range for this position is

This range is exclusive of fringe benefits and potential bonuses.  If hired at ICW Group, your final base salary compensation will be determined by factors unique to each candidate, including experience, education and the location of the role and considers employees performing substantially similar work.

WHY JOIN ICW GROUP?
•    Challenging work and the ability to make a difference
•    You will have a voice and feel a sense of belonging
•    We offer a competitive benefits package, with generous medical, dental, and vision plans as well as 401K retirement plans and company match
•    Bonus potential for all positions
•    Paid Time Off with an accrual rate of 5.23 hours per pay period (equal to 17 days per year)
•    11 paid holidays throughout the calendar year
•    Want to continue learning? We’ll support you 100%

ICW Group is committed to creating a diverse environment and is proud to be an Equal Opportunity Employer. ICW Group will not discriminate against an applicant or employee on the basis of race, color, religion, national origin, ancestry, sex/gender, age, physical or mental disability, military or veteran status, genetic information, sexual orientation, gender identity, gender expression, marital status, or any other characteristic protected by applicable federal, state or local law.

___________________

Job Category