Data Engineer Intern

Saved 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