Senior Data Engineer, Berxi Boston, MA

Salary Range: $ To $ Annually

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.

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?

Berxi has an exciting opportunity for a Senior Data Engineer to join its Platform Engineering team in Boston, MA, driving the design, automation, and scaling of our cloud-native data platform. As a Senior Data Engineer, you’ll work closely with engineering and business leaders to design and build data integration solutions that drive enterprise analytics and decision-making. You’ll leverage cloud technologies, CI/CD pipelines, and Power BI to deliver scalable, high-performance data solutions.

The ideal candidate excels in ETL programming, data integration, and data modeling, enabling self-service analytics and ensuring data accessibility, governance, and integrity. You’ll be part of an agile team, participating in Scrumceremonies and deliver continuous value to stakeholders.

Duties and Responsibilities:

• As a senior member, collaborate with a small team of data engineers, driving excellence in data platform evolution. Promote a culture of innovation, accountability, and continuous improvement.
• Design, develop, and maintain scalable data pipelines using Azure Data Factory, Databricks, and SQL Server (T-SQL).
• Implement configuration-driven ingestion processes for batch and near real-time data.
• Ingest, transform, and integrate data from diverse sources (APIs, JSON, CSV, XLS, etc.) using industry best practices.
• Analyze, design, and document data models (ERDs), create data dictionaries and data flow diagrams as part of pipeline development.
• Design and implement Lakehouse solutions leveraging Medallion architecture.
• Develop and maintain SSRS and Power BI datasets and reports.
• Oversee the health, scalability, and security of the Azure-based data platform.
• Support and enhance data governance, cataloging, and MDM initiatives.
• Ensure data security, privacy, and compliance best practices are followed.
• Manage access controls, data lineage, and metadata to support data discoverability and compliance.
• Continuously evaluate and improve data engineering processes for efficiency, automation, and reliability.
• Develop and maintain CI/CD pipelines using Git Hub Actions or Circle
  
  CI.
• Implement and refine monitoring, alerting, and observability for data pipelines and platform health.
• Collaborate with cross-functional teams to identify and eliminate process bottlenecks.
• Optimize data pipelines and platform components for performance, scalability, and cost-effectiveness.
• Evaluate and implement data quality and observability tools to ensure data reliability and accessibility.
• Work closely with the data product manager, program manager, engineering manager, and scrum master to define and deliver data products based on priorities.
• Participate in sprint planning, backlog refinement,…