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.  

As an 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.

In this role, you’ll:

• 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

• Registered student or recent graduate pursuing a major in an IT-related degree
• 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