ETL Development Intern

SWBC is seeking a motivated student to learn and contribute to ETL (Extract/Transform/Load) integration processes for the Data Management Team. This includes assisting with data analysis, source‑to‑target mapping, job scheduling basics, and the development and testing of iWay Service Manager (iSM) process flows and Data Quality Center (DQC) plans. There will also be Python- and SQL‑based ETL programs. This individual will collaborate with data owners, external vendors, and business users, under the guidance of senior team members, to help research and resolve data questions and anomalies.

Why you'll love this role:

SWBC is heavily engaged in the development of new cloud applications. You'll apply and grow your ETL (extract, transform, load) skills to help these applications integrate seamlessly. In this role, you'll work closely with programming languages (with a strong emphasis on Python), ETL software, databases, and cloud/server infrastructure. You'll get exposure to modern AWS services (e.g., Dynamo

DB, Lambda, Step Functions, SQS, S3, Event Bridge) and practice using AI both as an inline assistant in your IDE and as a tool to automate routine developer tasks. Beyond that, you'll work on a variety of activities, tackling technical challenges, participating in code reviews, and coordinating with teams inside and outside the department.

Essential duties include the following:

* Assists in communicating with customers to gather data requirements and performs guided data analysis on provided datasets.

* Helps design and implement data integration modules for ETL functions using Python, SQL, iWay Service Manager (iSM), and Data Quality Center (DQC) under mentorship.

* Builds small utilities and scripts in Python to support data ingestion, transformation, validation, and operational monitoring.

* Contributes to aggregation, monitoring, and alerting tools/modules; assists in setting up basic dashboards and run-time checks.

* Participates in the development process through code reviews, unit testing, documentation, and adherence to coding standards.

* Assists in designing, implementing, and maintaining reporting, monitoring, and dashboard frameworks that provide pipeline observability.

* Learns and applies AWS services relevant to integration patterns (e.g., S3 for data landing, Lambda for serverless transforms, Step Functions for orchestration, SQS for decoupled messaging, Event Bridge for event-driven triggers, Dynamo

DB for key-value access).

* Uses AI tools responsibly, as an inline IDE assistant for code suggestions/tests/docs and to prototype simple agentic workflows that automate routine validation or runbook steps.

* Investigates new technologies and advances, especially in the areas of ETL, Python engineering practices, and Cloud.

* Performs all other duties as assigned.

Serious candidates will possess the minimum qualifications:

* Actively pursuing a Bachelor's or Master's degree in Computer Science, Information Technology, Data Engineering, or a related field from an accredited college or university.

* Expected graduation of December 2026 or later.

* Foundational experience (coursework, projects, or prior internship) with ETL concepts and database development using Microsoft SQL Server or similar RDBMS.

* Working proficiency in Python for data processing (e.g., file I/O, JSON/XML parsing, data validation) and familiarity with SQL for querying and transformation.

* Knowledge of common data languages, formats, and syntax, including SQL, JavaScript Object Notation (JSON), and Extensible Markup Language (XML).

* Working knowledge of relational database systems such as Microsoft SQL Server or IBM DB2 (Microsoft SQL Server preferred).

* Familiarity with cloud concepts; exposure to AWS services such as S3, Dynamo

DB, Lambda, Step Functions, SQS, Event Bridge, Aurora/RDS, and EC2 is a plus.

* Experience with iWay Service Manager (iSM) and Data Quality Center (DQC) is a plus (training/mentorship provided).

* Experience using AI in development workflows (e.g., an inline IDE assistant for code/test/doc generation) and interest in agentic AI tools that automate multi‑step tasks is a plus.

* Understanding of data…