Data Engineer Intern: ETL & Data Warehouse

Berkley Small Business Solutions (a Berkley Company)

Urbandale (IA)

On-site

USD 25,000 - 39,000

Full time

14 days+

Application generator

Get a reply from this employer — a resume and cover letter tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Berkley Technology Services in Urbandale, IA seeks a Data Engineer Intern to support the Berkley Data Warehouse team with hands-on ETL and data integration work. You will learn from experienced engineers, contribute to DataStage/SSIS pipelines, and gain exposure to insurance data, Azure SQL, and automation tools in a collaborative, growth-focused environment.

This internship offers real project involvement, mentorship, and opportunities to convert to a full-time role, with a culture that values

Qualifications

Three years of college coursework completed; CS-related preferred.
Prior co-op or internship or related technical experience preferred but not required
Exposure to RDBMS solutions (PostgreSQL, MySQL, SQL Server) is a plus
Experience leading group projects in academic, internship/co-op, or professional settings is a plus
Understanding of RESTful API

Responsibilities

Develop ETL processes using DataStage or SSIS
Develop and utilize Tidal Enterprise Scheduler workflows
Develop MSSQL/Azure SQL statements and 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