Data Engineer, Berxi - Boston, United States - Berkshire Hathaway Specialty Insurance

Description

Job 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. As a 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.

Berxi is the Small Commercial team within BHSI. We're all about driving digital innovation in the Small Commercial Insurance space and are focused on leveraging technology to make insurance simple and affordable for professionals and small businesses. If you constantly strive for excellence, and want to work with a collaborative, fast paced and energetic team – then Berxi is for you.

We are a values-based organization where respect, integrity, excellence, collaboration, and passion define who we are and how we do business. We value diversity 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?

Job Opportunity:

As a Data Engineer, you will be part of a cross-functional, largely autonomous data engineering team. 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.

Duties & Responsibilities:

• Collaborate closely with application engineers, data analysts, data engineers, and stakeholders in building and maintaining Berxi data warehouse to support the operations and analysis of a direct-to-consumer small commercial insurance business.
• Contribute to the development, maintenance, and evolution of our platform.
• 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.
• Play a significant part in augmenting the data platform as we implement a new policy administration system data into Azure cloud-based data platform leveraging all the latest tools available anchoring on Azure resources.

Qualifications, Skills, and Experience:

• 2+ years of hands-on data engineering experience with ETL processing, data modeling and Business Intelligence.
• Relevant Work Experience with Microsoft SQL Server , SQL Server Integration Services (SSIS), ETL and Transact-SQL.
• Experience with Microsoft Azure cloud platform and Azure resources.
• Familiarity with data engineering concepts, languages, and tools; ability to develop on multiple platforms.
• Experience using sophisticated data transformation tools and cleansing methods, such as windowing functions in Transact-SQL.
• Experience with relational modeling, star schemas and Kimball Data Warehousing.
• Experience with contemporary data file formats such as JSON and unstructured data.
• 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.
• Experience with Agile data engineering concepts and processes, such as CICD, pipelines, backlog tracking, burndown metrics, and incremental delivery a plus
• Solid collaboration, prioritization, and adaptability skills required.
• Excellent interpersonal and communication skills.
• Proactive and self-driven, demonstrated initiative and be a logical thinker.

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