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., DynamoDB, Lambda, Step Functions, SQS, S3, EventBridge) 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, EventBridge for event-driven triggers, DynamoDB 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, DynamoDB, Lambda, Step Functions, SQS, EventBridge, 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 cleansing, data verification, and data configuration fundamentals.
• Strong analytical, organizational, and attention-to-detail skills.
• Strong communication (both verbal and written) and interpersonal skills.
• Ability to troubleshoot and methodically solve technical problems with guidance.
• Working knowledge of Microsoft Office, including Excel.
• Experience or interest in an agile environment (standups, sprints, retrospectives).
• Able to lift 10–20 lbs. of computer equipment.
• Must be able to sit for long periods of time at the computer developing.
• Able to stoop, kneel, and stand while performing hardware support. Able to travel locally and nationally.

SWBC offers*:  

• Competitive overall compensation package
• Work/Life balance 
• Employee engagement activities and recognition awards 
• Years of Service awards
• Career enhancement and growth opportunities 
• Leadership Academy and Mentor Program
• Continuing education and career certifications 
• Variety of healthcare coverage options
• Traditional and Roth 401(k) retirement plans 
• Lucrative Wellness Program

*Based upon employee eligibility 

Additional Information:

SWBC is a Substance-Free Workplace and requires pre-employment drug testing.

Please note, SWBC does not hire tobacco users as allowed by law.

To learn more about SWBC, visit our website at www.SWBC.com. If interested, please click the appropriate apply button.