Berkley One exists to insure and protect the lifestyles of a modern generation of affluence. We seek clients that are sophisticated individuals and families who require world-class risk and claims management customized to their needs, a team of select expert independent agents and innovative digital tools to keep it simple and easy. We’ll blend our partners, products and capabilities with all that is Berkley, generating a modern solution for the customers we serve.

Our culture is one of innovation, creativity and teamwork. Our team is highly motivated, passionate about our business, and deeply experienced in developing and delivering product and service solutions in the personal insurance marketplace.

We have an exciting opportunity for a Data Engineer to join our team! Reporting to our Chief Analytics Officer, you will support multiple aspects of our business including, analytics, business intelligence, and enterprise reporting.  You will bring strong analytical abilities and an inquisitive mind that can translate the stories found in the data. 

We have a welcoming culture valuing our employees – we actually trademarked the phrase Everything Counts, Everyone Matters® to describe the Berkley commitment to our people and how we do business. We believe that every person in the organization is important and every accomplishment makes a difference in our results. Come join us!

This position can be located in: Morristown, NJ; Boston, MA; or New York, NY

What you'll do:

• Responsible for the day-to-day hands on development and maintenance of our data warehouse environment, integrated business intelligence & visualization tools, and batch data extraction processes
• Support and educate user population on the use of BI and visualization tools
• Partner with leadership, engineers, program managers and analytics to understand data needs then design and develop appropriate data solutions
• Partner with core system vendor and application development team to ensure a clear and consistent data model is maintained along with an associated data dictionary
• Perform data and system analysis for defects and incidents, articulate root causes, and implement solutions
• Support areas include inconsistencies/inaccuracies in the data warehouse, batch data extracts for 3rd party integrations, financial & statistical reporting, and enterprise data feeds

What we're looking for:

• BS or MS degree in Computer Science/Engineering or a related quantitative field
• 2+ years SQL knowledge and experience working with relational databases, query authoring, and a working familiarity with a variety of databases
• 2+ years experience with Data Modeling – designing and building models for relational and semi structured data
• Strong ETL/ELT knowledge
• Experience with data visualization tools such as Power BI or Looker
• Programming experience (Python/R) preferred
• Experience with data pipelines preferred
• Experience with Azure Cloud Data Solution preferred
• Exceptional oral and written communication skills, a communication style flexible to the situation, and able to communicate clearly and with a purpose
• Calm under pressure, possessing excellent organizational skills, integrity, and follow-through on tasks, able to challenge the norms while working collaboratively with colleagues at all levels of the organization
• Natural curiosity, a love of learning how things work and always on the lookout for innovative improvements