Senior Data Engineer, Actuarial

Berkshire Hathaway - Boston, MA

Full-time - Mid Level

Boston, MA

Insurance Carriers and Related Activities

About the position

The Senior Data Engineer at Berkshire Hathaway Specialty Insurance (BHSI) is a key role within the Actuarial team, responsible for designing, developing, and maintaining the actuarial data warehouse and analytics architecture. This position focuses on creating data storage, automation, and integration solutions to support actuarial and underwriting analysis, ensuring data accessibility, efficiency, governance, performance, and integrity. The ideal candidate will possess strong problem-solving skills, attention to detail, and a collaborative spirit, contributing to the team's goal of enabling self-service data analysis and effective reporting.

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 APIs, 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
• Augment the data platform as the team transitions to an Azure based data platform leveraging all the latest tools available anchoring on Azure resources

Requirements

• 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 preferred
• Advanced proficiency of SQL required, SQL database management preferred
• Experience with Microsoft Azure with a concentration in ETL processing via Data Factory required
• Experience with PowerBI, Python, R programming preferred
• 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

Nice-to-haves

• Experience with PowerBI
• Experience with Python
• Experience with R programming

Benefits

• 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