Data Product Architect - P&C Insurance Experience

GUARD Insurance Group•New York, NY

54d•Hybrid

About The Position

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! The Data Product Architect plays a critical role in our Data and Analytics (DnA) Operating Model, contributing to the development of a Data Marketplace that provides valuable, reusable data products for various business domains within the federated guild. In collaboration with Data Product Managers, this role defines and implements solution architectures for data products that align with business objectives, value hypotheses, and analytical use cases. The Data Product Architect is the custodian of technical assets, including: Detailed design diagrams Data contracts Domain resources (e.g., infrastructure, compute capacity, storage) Additionally, this role administers the CI/CD DevOps process, ensuring seamless deployment and compliance with both domain-specific and platform-wide guardrails. Primary Objectives: Build data products that support descriptive, diagnostic, predictive, and prescriptive analytics. Utilize the DnA Platform's services while allowing custom development within prescribed guardrails. Drive business transformation by helping domains predict and optimize outcomes at scale.

Requirements

Bachelor's or master's degree in computer science, Information Science, or related field.
6 to 8 years of hands-on experience in Data Product Architecture, with expertise in Data Mesh, Marketplace, and Product methodologies.
Microsoft Azure
Microsoft Fabric
OneLake/Delta Lake - Optimized storage for structured and unstructured data.
Apache Spark - Scalable framework for large-scale data processing.
SQL & T-SQL - Essential for data querying and transformations.
PySpark & Scala - Critical for big data processing and machine learning workflows.
Fabric Notebooks - Python, SQL, and Spark development environment.
Data Factory - ETL/ELT tool for data pipeline orchestration.
GraphQL API - Efficient querying and data integration across domains.
CI/CD Pipelines - Automating data workflows and deployments.
Livy API - Used for managing Apache Spark jobs.
Monitoring & Logging - Tools to track pipeline performance and health.
Fabric Advisor - Optimization tool for performance tuning.
Power BI - Advanced analytics and visualization.
VS Code Integration - Enables development and debugging of Fabric notebooks.
Expertise in Agile software development methodologies.
Strong understanding of Data Product Management principles.
Ability to identify dependencies and solve complex challenges creatively.
Excellent communication and stakeholder management skills.
Experience in P&C Insurance industry required
Applicants must be authorized to work in the U.S. without current or future sponsorship

Nice To Haves

Microsoft Certified: Fabric Data Engineer Associate certification strong preferred

Responsibilities

Serve as a technical consultant for business owners and SMEs during the pre-data product development phase.
Lead the design and implementation of scalable data product architectures.
Ensure consistency between functional, service quality, and system management requirements.
Represent the data product solution design within the Federated Governance Guild.
Follow the DnA target architecture, leveraging and reusing existing patterns to align with core principles.
Create, iterate, and maintain technical documentation and data product architecture.
Optimize performance, cost-efficiency, and future scalability of data systems.
Act as a Microsoft Fabric expert, ensuring scalability, security, and governance of data solutions.
Conduct data value chain analysis and assumption management.
Define solution requirements and establish high-level designs.
Develop detailed architectural designs.
Manage infrastructure, compute capacity, and storage.
Oversee CI/CD pipelines for data ingestion, transformation, and visualization.
Serve as an equal stakeholder alongside the Data Product Manager during user acceptance testing.
Mentor domain data engineers in best practices.
Drive data product development and delivery to achieve business goals.
Continuously assess data product usage and recommend enhancements.
Collaborate with the DnA Platform team to integrate new innovations.

Benefits

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!