Data Warehouse Engineer Intern - ETL & Automation

Berkley Technology Services LLC; Urbandale (IA); On-site; USD 21,000 - 30,000; Full time

Job summary

Berkley Technology Services (BTS) in Urbandale, IA is seeking a Data Engineer Intern to gain hands-on data warehousing experience. You’ll work with seasoned engineers on the Berkley Data Warehouse Team and contribute to ETL development, data integration, and reporting initiatives.

This internship offers exposure to DataStage, SSIS, SQL, and UiPath tooling while collaborating with multiple operating units across the organization.

Qualifications

• Three years of college completed; CS/IS coursework preferred.
• Experience leading group projects in classroom or internship settings.
• Exposure to RDBMS (PostgreSQL, MySQL, SQL Server) is a plus.
• Understanding of RESTful API and data integration concepts.

Responsibilities

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

Skills

RESTful API

Group project leadership

Education

Three years of college completed

Tools

DataStage

SSIS

Tidal Enterprise Scheduler

MSSQL/Azure SQL

UiPath Orchestrator

Fivetran

Redgate

Job description

Berkley Technology Services (BTS) in Urbandale, IA is seeking a Data Engineer Intern to gain hands-on data warehousing experience. You’ll work with seasoned engineers on the Berkley Data Warehouse Team and contribute to ETL development, data integration, and reporting initiatives.

This internship offers exposure to DataStage, SSIS, SQL, and UiPath tooling while collaborating with multiple operating units across the organization.