Data Modeler - P&C Experience Required

Overview

Data Modeler - P&C Experience Required

About us:

Good things are happening at Berkshire Hathaway GUARD Insurance Companies. We provide Property & Casualty insurance products and services through a nationwide network of independent agents and brokers. Our companies are all rated A+ “Superior” by AM Best (the leading independent insurance rating organization) and ultimately owned by Warren Buffett’s Berkshire Hathaway group – one of the financially strongest organizations in the world! Headquartered in Wilkes-Barre, PA, we employ over 1,000 individuals (and growing) and have offices across the country. Our vision is to be a leading small business insurance provider nationwide.

Founded upon an exceptional culture and led by a collaborative and inclusive management team, our company’s success is grounded in our core values:  accountability, service, integrity, empowerment, and diversity. We are always in search of talented individuals to join our team and embark on an exciting career path!

Benefits:

We are an equal opportunity employer that strives to maintain a work environment that is welcoming and enriching for all. You’ll be surprised by all we have to offer!

• Competitive compensation
• Healthcare benefits package that begins on first day of employment
• 401K retirement plan with company match
• Enjoy generous paid time off to support your work-life balance plus 9 ½ paid holidays
• Up to 6 weeks of parental and bonding leave
• Hybrid work schedule (3 days in the office, 2 days from home)
• Longevity awards (every 5 years of employment, receive a generous monetary award to be used toward a vacation)
• Tuition reimbursement after 6 months of employment
• Numerous opportunities for continued training and career advancement
• And much more!

Responsibilities

Are you passionate about turning business strategy into scalable data solutions? At Berkshire Hathaway GUARD Insurance Companies, we’re looking for a Data Modeler with a strong business modeling focus to help shape the future of our data architecture and drive innovation in the property and casualty insurance industry.

In this role, you’ll work closely with domain owners and data product managers to understand business goals, value hypotheses, and use cases. Your work will directly support the development of effective and efficient data models that power our data products and enable strategic decision-making.

Key Responsibilities:

• • Analyze business use cases to understand goals and value drivers.
  • Create conceptual models using Meta Models, Ontologies, and Knowledge Graphs to represent domain structures.
  • Develop logical and physical data models that support KPIs and product requirements.
  • Ensure models meet output needs including SQL endpoints, dashboards, reports, and APIs.
  • Support data cataloging, source-to-target mapping, and data quality rule setup for critical data elements.
  • Optimize cloud databases (e.g., Delta Lake, OneLake) for performance and scalability.
  • Collaborate with governance teams to define global modeling standards and best practices.
  • Work cross-functionally with data engineers, analysts, and other teams to implement and maintain robust data models.

Qualifications

• Bachelor’s degree in Computer Science, Data Science, Statistics, Mathematics, or a related field.
• At least 6 years of experience in data modeling within the property and casualty insurance industry required
• Hands-on experience with Kimbal Dimensional modeling techniques is required
• Proficiency in SQL, Python, UML, and modern data modeling tools.
• Strong analytical skills and a track record of building scalable, efficient data models.
• Experience with Agile methodologies and cloud-based data platforms.
• Familiarity with data modeling concepts, database technologies, and insurance industry data systems.
• Ability to clearly convey technical concepts to non-technical stakeholders and lead cross-functional collaboration.
• Strong problem-solving skills and the ability to work in a dynamic, fast-paced environment.

Salary Range

$110,000.00 - $160,000.00 USD per year

The annual base salary range posted represents a broad range of salaries around the U.S. and is subject to many factors including but not limited to credentials, education, experience, geographic location, job responsibilities, performance, skills and/or training.

The successful candidate is expected to work in one of our offices 3 days per week and also be available for travel as required.