Job Title

Data Modeler - P&C InsuranceAbout PremiumIQPremiumIQ specializes in data analytics for the P&C insurance industry. We help our clients leverage data and advanced analytics to reduce loss ratios, increase revenue, improve claim processing efficiency, and enhance customer satisfaction. We provide technical leadership to help insurance companies develop future-proof data solutions and elevate their technology teams. Our solutions are adaptable and continuously improving, enabling self-service at scale on all types of data, whether it's big data, structured data, or unstructured data. Our singular focus on insurance data analytics enables us to bring unparalleled expertise and value to our clients.  Who You'll Work WithAs part of our team, you will lead and develop industry-leading data analytics solutions for our clients - while working closely with business users and data owners. About YouYou are a property and casualty insurance data modeler who has worked on source-to-target maps, SQL, and data modeling for property and casualty insurance companies. You enjoy working with business clients and with data engineers and analysts. You know many corners of the data analytics terrain and have core strengths in data architecture and SQL. You know how to collaborate with diverse personalities toward mutual success. You tackle new challenges proactively. Your flexibility enables you to adapt to different roles and wear many hats to get the job done. You bring a creative and innovative approach to solving problems, constantly thinking outside the box. As a team player, you enjoy working with others in a close-knit team environment.What You'll DoData Analysis and Design:Work with business users and IT professionals to understand business needs and define data requirements.Perform data discovery on insurance datasets to identify relationships, patterns, anomalies, and value ranges.Collaborate with IT and business teams to develop data solutions that meet business requirementsEnsure data accuracy and integrity by conducting thorough data validation and testing.Write SQL queries to retrieve, transform, and aggregate data from relational databases.Create source-to-target maps, including SQL and business rules.Client Engagement and Project Management:Participate in client meetings, workshops, and presentations to understand client objectives and challenges.Build strong relationships with client stakeholders by producing high-quality deliverables and exceptional client municate findings in a clear and concise manner to technical and non-technical audiences.Manage deliverables and work from a project backlog.Continuous Learning and Professional Development:Stay up to date with the latest trends and best practices in data analytics, P&C insurance, and consulting.Develop expertise in insurance data analytics.Seek out and actively participate in internal and external training programs to enhance skills and knowledge.Contribute to knowledge-sharing initiatives by sharing insights, experiences, and industry research.Qualifications3+ years property and casualty insurance experience5+ years of SQL experience with the ability to write complex queries and optimize their performance5+ years with progressive experience in data modeling5+ years of data design and developmentExperience with Data Vault 2 frameworkExperience with data modeling toolsExperience with the creation and validation of source-to-target mappingsStrong knowledge of ETL processes, data modeling, and data warehousing conceptsExperience with data modeling conceptsExperience working with Agile development methodologies3+ years as a business data analyst in the P&C Insurance domainExcellent communication and interpersonal skills to effectively collaborate with diverse teams and clientsProactive mindset with the ability to work independently and as part of a team in a fast-paced, results-oriented environmentStrong attention to detail, with a commitment to delivering high-quality work within tight deadlinesAbility to understand and develop ETL pipelines is desirablePrior experience in management consulting is desirableKnowledge of ACORD P&C Insurance industry information models is desirableFamiliarity with cloud platform Azure and Snowflake is desirableBenefitsCompetitive compensation package including base salary, incentive compensation, and equity.Health Care Plan (Medical, Dental, & Vision)Retirement Plan (401k)Unlimited PTOEqual Opportunity EmployerPremiumIQ is an Equal Opportunity Employer committed to creating an inclusive environment for all employees. We welcome and encourage diversity in the workplace regardless of race, color, religion, national origin, gender, pregnancy, sexual orientation, gender identity, age, physical or mental disability, genetic information, or veteran status.