Who are we?

Berxi is a fast-growing, entrepreneurial venture within Berkshire Hathaway Specialty Insurance. We set out to build a modern, customer-focused, digital platform to upend the traditional insurance market and help professionals and small businesses buy and manage insurance smarter and faster – all of which saves them time and money.

We’re building a culture that’s liberating and fast-paced. We’re purposefully non-bureaucratic and perpetually entrepreneurial, and always focused on doing what’s right for our customers, our team, and our business.  If you constantly strive for excellence, and want to work with a collaborative, fast paced and energetic team – then Berxi is for you.

Job Opportunity:

As a Data Engineer, you should have excellent problem-solving skills, strong attention to detail, and the technical know-how to independently build solutions from start to finish. We are looking for a true expert on ETL development / data modeling, who is comfortable working with datasets of varying latencies and size sourcing data from various disparate data providers and platforms.

The candidate will utilize tax acumen and skills to assess and analyze tax risks and recommend appropriate tax insurance policy terms and conditions (e.g., premium rate, coverage exclusions). Prior insurance experience is a plus but is not required.

Duties & Responsibilities:

You will be part of a cross-functional, largely autonomous data engineering team. You will collaborate closely with application engineers, data analysts, data scientists, and executive stakeholders in building and maintaining enterprise data warehouse to support the operations and analysis of a direct to consumer small commercial insurance business. This role will contribute to the development, maintenance and evolution of our platform. Daily you can expect to be deeply involved with working on SQL Server, developing Kimball dimensional modeling-based data marts & build new models or data marts and supporting data analyst teams in further assessing available data. The role will play a significant part in augmenting the data platform as we transition it to an Azure based data platform leveraging all the latest tools available anchoring on Azure resources.

Qualifications, Skills and Experience:

• 4+ years of hands-on industry experience with data modeling and working in Business Intelligence projects
• Relevant Work Experience with Microsoft SQL Server (2016+), SQL Server Integration Services (SSIS), ETL and Transact-SQL
• Relevant work experience leveraging Cloud Native technologies on MSFT Azure a strong plus
• Expertise developing with multi-stage data transformations using SQL
• Experience using sophisticated data transformation tools and cleansing methods, such as windowing functions in Transact-SQL
• Experience designing and developing data models to support Business Intelligence initiatives
• Experience with relational modeling, star schemas and Kimball Data Warehousing
• Experience defining and implementing a global data catalog / data dictionary for end user reference
• Familiarity with database CI/CD patterns and methods a plus
• Familiarity with contemporary data file formats like Apache Parquet, Avro
• Familiarity modeling for BI visualization tools such as Power BI / SSRS
• Familiarity with Spark SQL / C# / Python is a plus
• Experience with NoSQL/Non-relational databases are a plus, especially blob storage and Azure file tables

BHSI Offers:

• A competitive package and exciting growth opportunities with a growing global organization
• A liberating, fast-paced culture, centered on always doing the right thing for our customers, teammates and our business
• A purposely non-bureaucratic organization that embraces simplicity over complexity, encourages innovation, and emphasizes individual excellence in a team framework

LEARN MORE ABOUT OUR UNIQUE CULTURE AND HISTORY

NOTE: 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