• Job Description

  Req#: 6012

  Overview

  Work Arrangement:

  ***After the initial training period, this is a hybrid role, working onsite in our Sioux Falls, SD office.***

  Provides support for and assists in the design, management, and maintenance of company database management systems. 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. Is a subject matter expert in the organization’s SSIS packages.

  Responsibilities

  Essential Functions

  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.

  Qualifications

  Education/Experience 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.

  Preferred Requirements

  • Banking or financial services experience.
  • Working knowledge of Anti Money Laundering platforms and technologies such as Actimize.
  • Excellent verbal, written, and interpersonal communication skills.
  • 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.

  Background & EEO Statement

  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: click here

  Diversity & Background Screening

  Diversity & Inclusion at The Bancorp Bank: click here

  The Bancorp Bank, N.A. is an EQUAL OPPORTUNITY EMPLOYER and will not discriminate on the basis of race, color, religion, gender, gender identity, sexual orientation, pregnancy, citizenship, national origin, age, disability, genetic information, veteran status or other protected category with respect to recruitment, hiring, training, promotion, and other terms and conditions of employment.

  Employment with The Bancorp Bank, N.A. includes successfully passing a background check including credit, criminal, education, employment, OFAC, and social media background history.

  #LI-CB1

  #LI-Hybrid

• About the company

  For over 20 years, The Bancorp has been providing nonbank companies with the people, processes and banking technology that are essential in meeting their individual needs

Notice