Data Modeler

Berkshire Hathaway GUARD Insurance Companies provide Property & Casualty insurance products and services through a nationwide network of independent agents/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 the 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 and profit sharing
  • Generous paid vacation and sick time
  • Hybrid work schedule (three days in the office, two days from home)
  • Work/life balance schedule – no nights or weekends/closed for all major holidays
  • Longevity awards (every 5 years of employment receive a generous monetary award to be used toward a vacation)
  • Tuition reimbursement after six months of employment
  • Numerous opportunities for continued training and career advancement
  • And much more!

As a business modeling focused data modeler, your role involves creating and maintaining various levels of data models that align with Sub domain/Super Domain goals. You will closely work with the sub domain owners and sub domain Data product managers to understand business goals, value hypothesis and use cases to help build Data products that are well supported by effective and efficient data models. In this role you will be responsible to closely collaborate with other personas in the domain driven architecture/operating model to drive the growth of your business domains.

Key Responsibilities:

• Business Analysis and strategic planning: Analyze business use cases to understand the goal and value hypothesis that the domain owners are driving towards
• Model Design and Build: Create data models that will support the data product vision of the Data product manager. Develop conceptual models representing the sub/super domain business model. Ensure the conceptual model is created with Meta Model/Ontology and/or Knowledge Graph utilization. Develop logical and physical data models to meet the Data product requirements through the means of business use cases and the KPIs. During the Physical data modeling process of the data product, ensure all the various output requirements are fully satisfied. E.g. – SQL endpoints, Dashboard/Reports and API consumption.
• Data Mapping and Quality: Ensure the data catalog activities for the data product are carried out. Help the domain data analysts to complete the source to target mapping, data quality rule setup for the target data model’s critical data elements (CDE).
• Database Optimization: Optimize Cloud databases such as Delta lake or OneLake for efficiency, scalability, and faster access using techniques like indexing and partitioning.

• Data Governance: Work with Federated Governance guild to define global policies that define and govern data modeling practices, design standards, best practices across the data marketplace.
• Collaboration: Work closely with data engineers, analysts, and other teams to implement and maintain effective data models.

• Bachelor’s degree in Computer Science, Data Science, Statistics, Mathematics, or a related field.
• Minimum of 6 years of experience in data modeling in the property and casualty insurance industry.
• Proficiency in SQL, data modeling tools and languages such as Python and UML
• Strong analytical thinking is essential for creating efficient and scalable data models that meet business needs.
• Proven experience as a Data Modeler preferably in the property and casualty insurance industry. Familiarity with property and casualty insurance industry data, systems, and processes. Ability to understand business needs, revenue drivers and stakeholder requirements.
• Take ownership of the product’s success and advocate for its value.
• Experience with Agile methodologies and data modeling tools.
• Familiarity with data modeling concepts and database technologies.
• Excellent communication and leadership skills, with the ability to bridge the gap between technical teams and business stakeholders.
• Strong problem-solving skills and the ability to work in a dynamic, fast-paced environment.