Data Engineer Intern

W. R. Berkley Corporation; Urbandale (IA); On-site; USD 28,000 - 39,000; Full time

Job summary

Berkley Technology Services within W. R. Berkley Corporation is seeking a Data Engineer Intern in Urbandale, IA. You will work closely with a team of experienced data warehouse engineers on the Berkley Data Warehouse project, contributing to ETL development and data integration tasks.

Responsibilities include building ETL pipelines (DataStage/SSIS), writing MSSQL/Azure SQL queries, and gaining exposure to insurance data while collaborating with operating units across the globe.

Qualifications

• At least three years of college or university coursework completed; preference for computer science or related field.
• Prior co-op or internship experience preferred but not required.
• Experience with RESTful APIs is a plus.

Responsibilities

• Develop ETL processes using DataStage or SSIS.
• Develop MSSQL/Azure SQL statements and/or stored procedures.
• Collaborate with data warehouse engineers and operating units.
• Assist with UiPath Orchestrator, Automation Hub, and Task Mining implementations.

Job description

Company Details

Berkley Technology Services (BTS) is the dynamic technology solution for W. R. Berkley Corporation, a Fortune 500 Commercial Lines Insurance Company. With key locations in Urbandale, IA and Wilmington, DE, BTS provides innovative and customer-focused IT solutions to the majority of WRBC’s 60+ operating units across the globe. BTS’s wide reach ensures that

ideas and opinions are considered at every level of the organization to guarantee we find the best solutions possible.

Driven by a commitment to collaboration, BTS acts as consultants to our customers and Operating Units by providing comprehensive solutions that not only address the challenge at hand, but proactively plan for the “What’s Next” in our industry and beyond.

With a culture centered on innovation and entrepreneurial spirit, BTS stands as a community of technology leaders with eyes toward the future -- leaders who truly care about growing not only their team members, but themselves, and take pride in their employees who shine. BTS offers endless ways to get involved and have the chance to grow your career into a wide range of roles you’d never known existed. Come join us as we push forward into the future of industry leading technological solutions.

Berkley Technology Services: Right Team, Right Technology, Simple and Secure.

Responsibilities

As a Data Engineer Intern on the Berkley Technology Services (BTS) Berkley Data Warehouse Team, you’ll partner directly with a team of highly experienced data warehouse engineers and architects. You’ll gain hands-on experience related to the Berkley data warehouse. Key functions will include but are not limited to:

• Develop ETL processes using DataStage or SSIS
• Develop and utilize Tidal Enterprise Scheduler workflows
• Develop MSSQL/Azure SQL statements and or stored procedures
• Develop understanding of insurance, reinsurance, and financial data
• Assist with implementation and management of UiPath Orchestrator, Automation Hub, and Task Mining
• Assist with implementation and management of DataStage, SSIS, Redgate,Fivetran
• Collaborate with peer technical teams
• Collaborate with Operating Units

Qualifications

• At least three years of college or university coursework completed; preference is for some coursework related to computer science or similar area of study
• Prior related co-op, internship, and/or on or off-campus technical experience preferred but not required
• Previous exposure to RDBMS solutions (PostgreSQL, MySQL, SQL Server, etc.) is a plus
• Experience leading group projects in a classroom, internship/co-op, and/or professional setting is a plus
• Understanding of RESTful API

Additional Company Details

We do not accept unsolicited resumes from third party recruiting agencies or firms. The Company is an equal employment opportunity employer.

Additional Requirements

Location and Travel: Urbandale, IA.

Sponsorship Details

Sponsorship not Offered for this Role