Data Modeler II
About the position 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. 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. Requirements • 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. • 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. Nice-to-haves • Technical certifications relevant to AWS and/or data modeling are preferred. Benefits • Competitive benefits package, with generous medical, dental, and vision plans. • 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. • Support for continued learning. Apply tot his job