Senior Data Engineer, Actuarial

3 weeks ago


Boston, United States ZipRecruiter Full time

Job DescriptionJob Description

Who are we?
A strategic and trusted insurance partner, Berkshire Hathaway Specialty Insurance (BHSI), provides a broad range of commercial property, casualty and specialty insurance coverages and outstanding service to customers and brokers around the world. Part of Berkshire Hathaway’s insurance operations, we bring our solutions to market with our stellar brand name, top-rated balance sheet, and the expertise of our global team of professionals, who exude excellent capabilities and strong character.

We are a values-based organization where respect, integrity, excellence, collaboration, and passion define who we are and how we do business. We value of backgrounds, experience, and perspectives and strive to foster an inclusive environment that enables all our team members to bring their best selves to work. We are one team committed to building a culture where every teammate has the opportunity to contribute and be recognized. Want to be part of the team building the finest property, casualty and specialty lines insurance company in the world?

Learn more about our unique culture and history.

Job Opportunity:

Berkshire Hathaway Specialty Insurance (BHSI) has an exciting opportunity for an experienced Senior Data Engineer to join our globally focused Actuarial team. We are looking for an individual with excellent problem-solving skills, strong attention to detail, and the technical know-how to design, develop, and implement the necessary data storage, automation, and integration solutions to support actuarial and underwriting analysis. This position will be the perfect fit for an individual who is intellectually curious, self-motivated and a collaborative team member.

The Senior Data Engineer is responsible for designing, developing, maintaining, monitoring, and extending our actuarial data warehouse and analytics architecture to meet the team’s business analysis and reporting needs. The design and development focus includes but is not limited to Extraction Transformation Layer (ETL) frameworks, metadata management, data integration, master data definition and data quality, data auditing and profiling, and business intelligence reporting solutions. Additionally, this role will serve as both the architect and administrator of our actuarial data infrastructure, inclusive of all actuarial servers and database developments.

We are focused on enabling self-service data analysis for ease of reporting and analytics visualization while focusing on data accessibility, efficiency, governance, performance, and integrity. This team member will work with various business partners to map the technical vision for data in the actuarial data warehouse employing Azure, APIs, and SQL server. Additionally, they will be responsible for reviewing, analyzing, modifying, and creating ETLs, utilizing SQL, CD/CI pipelines, DevOps, testing, debugging, integration, and implementation processes.

Duties & Responsibilities:

  • In-depth analysis of existing data load, analytics, and visualization code to ensure accuracy of data flow and resolution of anomalies
  • Provisioning workflows, data pipelines, extracts, ETL and integrations using API’s, JSON, XLS and other sources to integrate with internal data stores and systems.
  • Coordinate and implement the integration of various data sources to a central repository through sound testing, documentation, and execution of strategy 
  • Perform data validations and reconciliations between various sources and reports with precision and attention to detail to ensure deliverables are accurate and effective 
  • Debug and troubleshoot data quality problems using SQL tools.
  • Provide technical support to actuaries and underwriters using the combination of tools needed to best complete each task (e.g. SQL, Excel, VBA) 
  • Oversight and administration of actuarial data infrastructure including server performance and database monitoring
  • The role will play a significant part in augmenting the data platform as we transition to an Azure based data platform leveraging all the latest tools available anchoring on Azure resources

Qualifications, Skills and Experience:

  • Bachelor’s degree in Business, Analytics, Computer Science or related field 
  • 5+ years of demonstrated professional data engineering experience with specialization in data modeling and business intelligence, insurance industry
  • Advanced proficiency of SQL required, SQL database management
  • Experience with Microsoft Azure with a concentration in ETL processing via Data Factory required
  • Experience with PowerBI, Python, R programming  
  • Proficient in TSQL procedural coding, analysis, DML and DDL scripting
  • Proficient in data transformation, ETL methodology, and data warehousing
  • Demonstrated understanding of API development as it pertains to data integration efforts
  • Familiarity with data modelling and experience working within complex data environments
  • Experience defining and implementing a global data catalog / data dictionary for end user reference
  • Proven track record of collaboration across functions delivering quality results in an efficient manner
  • Solid oral and written communication skills 
  • Strong interpersonal skills and the ability to work both independently and on teams 
  • Strong desire to learn from and share knowledge with teammates. 
  • Effective time management, with the ability to juggle multiple projects at the same time 

BHSI Offers:
• A competitive package and exciting growth opportunities for career-oriented teammates
• A dynamic, action oriented, and thoughtful environment centered on always doing the right thing for our customers, teammates and our other stakeholders
• A purposely non-bureaucratic organization that embraces simplicity over complexity and emphasizes individual excellence in a team framework

NOTE: Compensation will be commensurate with experience. This job description is not intended to be all-inclusive. Team Member may perform other related duties as negotiated to meet the ongoing needs of the organization

#LI-ON-SITE



  • Boston, United States Berkshire Hathaway Specialty Insurance Full time

    Job DescriptionJob DescriptionWho are we? A strategic and trusted insurance partner, Berkshire Hathaway Specialty Insurance (BHSI), provides a broad range of commercial property, casualty and specialty insurance coverages and outstanding service to customers and brokers around the world. Part of Berkshire Hathaway’s insurance operations, we bring our...


  • Boston, United States Berkshire Hathaway Specialty Insurance Full time

    Who are we? A strategic and trusted insurance partner, Berkshire Hathaway Specialty Insurance (BHSI), provides a broad range of commercial property, casualty and specialty insurance coverages and outstanding service to customers and brokers around the world. Part of Berkshire Hathaway's insurance operations, we bring our solutions to market with our stellar...

  • Senior Actuary

    23 hours ago


    Boston, United States Homesite Full time

    Position Compensation Range:$111,000.00 - $190,000.00Pay Rate Type:SalaryCompensation may vary based on the job level and your geographic work location. Relocation support is offered for eligible candidates.Certain geographic locations may qualify for a salary range of $123,000 to $209,000 Yearly.As a Senior Actuary, you will lead complex actuarial projects...

  • Senior Actuary

    1 month ago


    Boston, MA, United States Karen Clark & Company Full time

    KCC seeks a fulltime Actuary in our Boston office to partner with clients to leverage catastrophe model output in underwriting, ratemaking, and risk transfer initiatives. Your responsibilities will also include fostering relationships with insurance regulators and rating agencies. In this position, you will work with KCC's interdisciplinary Client Services,...


  • Boston, United States Plymouth Rock Assurance Full time

    The Boston-based Home Product team is seeking a self-motivated and creative Senior Actuarial Analyst. This is a unique hybrid role where the analyst will work under a credentialed product manager to leverage their analytical skills to help solve practical business problems.Here is what you will do:Utilize core actuarial skillsets including ratemaking,...


  • boston, United States Plymouth Rock Assurance Full time

    The Boston-based Home Product team is seeking a self-motivated and creative Senior Actuarial Analyst. This is a unique hybrid role where the analyst will work under a credentialed product manager to leverage their analytical skills to help solve practical business problems.Here is what you will do:Utilize core actuarial skillsets including ratemaking,...


  • Boston, United States Plymouth Rock Assurance Full time

    The Boston-based Home Product team is seeking a self-motivated and creative Senior Actuarial Analyst. This is a unique hybrid role where the analyst will work under a credentialed product manager to leverage their analytical skills to help solve practical business problems.Here is what you will do:Utilize core actuarial skillsets including ratemaking,...

  • Sr. Associate Actuary

    1 month ago


    Boston, United States Selby Jennings Full time

    A leading insurance company is looking for a Senior Associate, Actuarial, to make a significant impact in advancing innovative insurance solutions. This role offers a unique opportunity for individuals with strong technical expertise and a drive for innovation who are actively pursuing their ASA designation. Key Responsibilities: Support the development,...


  • Boston, United States Selby Jennings Full time

    A leading insurance company is looking for a Senior Associate, Actuarial, to make a significant impact in advancing innovative insurance solutions. This role offers a unique opportunity for individuals with strong technical expertise and a drive for innovation who are actively pursuing their ASA designation.Key Responsibilities:Support the development,...


  • Boston, United States Selby Jennings Full time

    Company Overview:My client, a dynamic and industry-leading insurance organization is currently seeking a talented and experienced actuary to join their pricing team and drive strategic pricing initiatives that support profitable growth and sustainability. This role offers the chance to impact business strategy, collaborate across functions, and advance your...


  • Boston, United States Selby Jennings Full time

    Company Overview:My client, a dynamic and industry-leading insurance organization is currently seeking a talented and experienced actuary to join their pricing team and drive strategic pricing initiatives that support profitable growth and sustainability. This role offers the chance to impact business strategy, collaborate across functions, and advance your...


  • Boston, United States Plymouth Rock Assurance Full time

    Are you looking for a chance to be part of a high performing team that is passionate about profitable growth? Does the thought of building a team from ground up excite you? If yes, then join us and be part of a team that's forging the path to data-driven success.We are seeking a highly skilled Sr. Actuarial Manager to join our dynamic team. As a Sr....


  • boston, United States Plymouth Rock Assurance Full time

    Are you looking for a chance to be part of a high performing team that is passionate about profitable growth? Does the thought of building a team from ground up excite you? If yes, then join us and be part of a team that's forging the path to data-driven success.We are seeking a highly skilled Sr. Actuarial Manager to join our dynamic team. As a Sr....


  • Boston, United States TRUE Property Insurance Full time

    About TRUE: Trusted Resource Underwriters Exchange (“TRUE”) is a reciprocal insurer established in 2020 to serve homeowners in storm-prone regions of Florida and other parts of the country. At the end of 2023, Gallatin Point Capital acquired a majority stake in the attorney-in-fact for TRUE and raised over $1.25 billion of committed capital, enabling...


  • Boston, MA, United States Ameriprise Financial Full time

    Ameriprise Financial has an exciting opportunity for Director of Actuarial Model Validation to join the team! The Director of Actuarial Model Validation will report directly to VP – Quantitative Model Validation and manages a team of quantitative model validators to test and evaluate the conceptual soundness of actuarial models and assess limitations and...

  • Senior Data Analyst

    23 hours ago


    Boston, United States Karen Clark & CO Full time

    Karen Clark & Company seeks a Senior Data Analyst to join our consulting team in our Downtown Boston office. Senior Data Analysts support complex consulting projects and partake in the extensive validation and finalization process of KCC's catastrophe computer models, as well as developing internal tools and automations. As a Senior Data Analyst, you will...

  • Senior Data Engineer

    23 hours ago


    Boston, United States NTT DATA, Inc. Full time

    Senior Data Engineer & Data Analytic Consulting Manager (Life and Annuity)Company: NTT DATA ServicesWho We Are:NTT DATA America’s strive to hire exceptional, innovative and passionate individuals who want to grow with us. Launch by NTT DATA is the culmination of the company’s strategy to acquire and integrate the skills, experience, and technology of...

  • Sr. Associate Actuary

    1 month ago


    Boston, United States Selby Jennings Full time

    Job DescriptionJob DescriptionA leading insurance company is looking for a Senior Associate, Actuarial, to make a significant impact in advancing innovative insurance solutions. This role offers a unique opportunity for individuals with strong technical expertise and a drive for innovation who are actively pursuing their ASA designation.Key...


  • Boston, United States ICS Global Soft INC Full time

    Job DescriptionJob DescriptionRequirement:Role: Data Engineer & Senior Data EngineerLocation: Remote or Boston, MA & San Mateo, CADuration: FTE Job Description:Candidates need to be able to manage data modeling and themovement of data from any disparate system to a repository/database/datalakeusing SQL and Python to created a streaming or continuous data...

  • Senior Data Engineer

    23 hours ago


    Boston, United States ICS Global Soft INC Full time

    Job DescriptionJob DescriptionRequirement:Role: Data Engineer & Senior Data EngineerLocation: Remote or Boston, MA & San Mateo, CADuration: FTE Job Description:Candidates need to be able to manage data modeling and themovement of data from any disparate system to a repository/database/datalakeusing SQL and Python to created a streaming or continuous data...