Job description

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 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 • 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 We do not accept unsolicited resumes from third party recruiting agencies or firms. The Company is an equal employment opportunity employer. Location and Travel: • Urbandale, IA. Sponsorship not Offered for this Role Not ready to apply? Connect with us for general consideration.

Requirements

Must-haves

ideas and opinions are considered at every level of the organization to guarantee we find the best solutions possible.
Berkley Technology Services: Right Team, Right Technology, Simple and Secure.
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
At least three years of college or university coursework completed; preference is for some coursework related to computer science or similar area of study
Understanding of RESTful API
We do not accept unsolicited resumes from third party recruiting agencies or firms.
The Company is an equal employment opportunity employer.
Urbandale, IA.
Sponsorship not Offered for this Role
Not ready to apply? Connect with us for general consideration.

Nice-to-haves

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

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

azuresqlapi

Platform: icims
Effort: medium