Data Engineer

Company Details

Founded in 1967, W. R. Berkley Corporation has grown from a small investment management firm into one of the largest commercial lines property and casualty insurers in the United States. Along the way, we have been listed on the New York Stock Exchange, seen our revenue soar well past $7 billion, and become a well-respected Fortune 500 Company.

Today, the Berkley brand comprises 54 Berkley companies worldwide. Still managed by our founder and largest shareholder, W. R. Berkley Corporation is well-positioned to respond to opportunities for future growth.

Berkley Regional Shared Services is an innovative provider of technology and business services for the Berkley Regional Segment of companies. If you are looking to join a fast-paced, energetic and passionate team with room for professional growth and development

• Berkley may be a great fit for you.

This role will be based in our Glen Allen, VA office. We offer a hybrid work schedule with 4 days in the office; and 1 day remote where it makes sense to do so.

The company is an equal opportunity employer. #LI-AV1 #LI-HYBRID

Responsibilities

As a Data Engineer, you will be providing data development at a moderately complex level such as ETL, cube creation, adhoc and management reporting, dashboard and data extract creation. You'll work within a team environment that provides data resource development and support for several companies. You'll be responsible for analyzing, designing and coding solutions for rapidly growing companies supporting the property & casualty insurance industry.

In this role, you'll have interface with a variety of stakeholders within RSS as well as the Berkley Operating Units. Not only will you communicate and coordinate within your team but have may also influence other teams and provide mentorship to others.

What you can expect:

• Culture of innovation, teamwork, supportive colleagues and leaders willing to invest in talent

• Internal mobility opportunities

• Visibility to senior leaders and partnership with cross functional teams

• Opportunity to impact change

• Benefits - competitive compensation, paid time off, comprehensive wellness benefits and programs, employer funded health savings account, profit sharing, 401k, paid parental leave, employee stock purchase plan, tuition assistance and professional continuing education

We'll count on you to:

• Demonstrate a robust understanding of all business data processes/processing for a system, and the related data structures

• Produce significant new system functionality or defect resolution with minimal direction

• Create design specifications that demonstrate an understanding of most interfacing systems and supported business processes.

• Routinely propose improvements to a data process and/or structure to improve supportability or usability

• Perform adequate peer review on any changes in the system

• Provide recommendations to solve business issues based on experience and knowledge of current technology

• Demonstrate understanding of data processes and/or structures

• Communicate with employees primarily up to the mid-level within both company and client companies.

• May be responsible for on-call rotation

Qualifications

What you need to have:

• Bachelors degree in Computer Science or technical oriented degree

• 3-5+ yrs - reasonable single system / single technology knowledge

• 3-5+ yrs SQL, TSQL experience. (queries, stored procedures, functions)

• 2+ years working in Insurance data environment

• Excellent knowledge in designing and delivery of Reports, Dashboards, Datasets and related applications

• Advanced experience using Microsoft's SQL Server SSRS and Microsoft Sql Server Analysis Services

• Capability of meeting the key accountabilities, or have the ability to learn/perform them

• Ability to travel up to 20%

What makes you stand out:

• Experience with Python, Java, C+, or Scala

• Ability to work in a fast-paced team environment, adapt quickly to learn new technologies

• Ability to work independently

• Strong customer and business focus

• Self-motivated with a passion for success

• Excellent communication and organizational skills

Additional Company Details

We do not accept any unsolicited resumes from external recruiting agencies or firms. The company offers a competitive compensation plan and robust benefits package for full time regular employees. The actual salary for this position will be determined by a number of factors, including the scope, complexity and location of the role; the skills, education, training, credentials and experience of the candidate; and other conditions of employment.

Sponsorship Details

Sponsorship not Offered for this Role Responsibilities As a Data Engineer, you will be providing data development at a moderately complex level such as ETL, cube creation, adhoc and management reporting, dashboard and data extract creation. You'll work within a team environment that provides data resource development and support for several companies. You'll be responsible for analyzing, designing and coding solutions for rapidly growing companies supporting the property & casualty insurance industry. In this role, you'll have interface with a variety of stakeholders within RSS as well as the Berkley Operating Units. Not only will you communicate and coordinate within your team but have may also influence other teams and provide mentorship to others. What you can expect:

• Culture of innovation, teamwork, supportive colleagues and leaders willing to invest in talent

• Internal mobility opportunities

• Visibility to senior leaders and partnership with cross functional teams

• Opportunity to impact change

• Benefits - competitive compensation, paid time off, comprehensive wellness benefits and programs, employer funded health savings account, profit sharing, 401k, paid parental leave, employee stock purchase plan, tuition assistance and professional continuing education We'll count on you to:

• Demonstrate a robust understanding of all business data processes/processing for a system, and the related data structures

• Produce significant new system functionality or defect resolution with minimal direction

• Create design specifications that demonstrate an understanding of most interfacing systems and supported business processes.

• Routinely propose improvements to a data process and/or structure to improve supportability or usability

• Perform adequate peer review on any changes in the system

• Provide recommendations to solve business issues based on experience and knowledge of current technology

• Demonstrate understanding of data processes and/or structures

• Communicate with employees primarily up to the mid-level within both company and client companies.

• May be responsible for on-call rotation