Overview***This position is available as a hybrid position in Sioux Falls, SD office.***
Designs, develops, and implements data integration packages for the organization. Performs a wide variety of database programming assignments and research/troubleshooting in T-SQL. Troubleshoots and maintains existing ETL packages. Become a subject matter expert in the organization27s SSIS packages.
Key Responsibilities
- Creates new Extraction, Transformation, and Loading (ETL) packages to achieve data integration between various source and destination systems including the Anti Money Laundering system Actimize.
- Tests and debugs code using departmental standards and protocols prior to elevation.
- Acts as a subject matter expert in the existing ETL packages used to load Actimize. Makes recommendations and implement improvements to the packages.
- Reviews database design and code written by other database and application developers, identifies issues, and discusses efficiencies to improve data integration code and/or controls.
- Troubleshoots ETL issues as they arise by evaluating the ETL packages, source data, and destination systems.
- Develops, updates, and maintains ETL specifications and documentation used to develop data migration mappings and transformations.
- Performs other duties as assigned.
Qualification Requirements
- Undergraduate degree in a related field or an equivalent combination of training and experience.
- A minimum of 3 years T-SQL and SQL Server Integration Services (SSIS) development experience.
- Excellent analytical ability, judgement, and problem analysis techniques.
- Ability to write and understand complex SQL queries.
- Ability to take ownership of projects and be self-directed.
- Ability to work effectively in a team fostered, multi-tasking environment.
- Experience with or exposure to data tools such as data catalogs (e.g., Atlan), data warehouses (e.g., Snowflake), transformation tools (e.g., dbt), or reporting platforms.
- Familiarity with or interest in data automation, AI/ML concepts, and AI-assisted analytics tools, with the ability to apply them in a governed environment.
- Effective communication and collaboration skills, with experience working across technical and business teams in a regulated environment.
- Banking or financial services experience.
Additional Information
This job will be open and accepting applications for a minimum of five days from the date it was posted.
Working at The Bancorp Bank, N.A. and Benefits Information:https://thebancorp.com/company/join-our-team/
