You are not logged in. Create an Account to take advantage of all our features.
 Home/Search  >  Previous Page The Bancorp Bank   > Database and ETL Developer
Database and ETL Developer Print
Employer: The Bancorp Bank
Location: Sioux Falls, SD 57108
Employment Type: Full Time

Position Summary

Design, develop, and implement data integration packages for the organization. Perform a wide variety of database programming assignments and research/troubleshooting in T-SQL. Troubleshoot and maintain existing ETL packages. Become a subject matter expert in the organization’s SSIS packages.


Duties and Responsibilities:

  1. Create new Extraction, Transformation, and Loading (ETL) packages to achieve data integration between various source and destination systems including the Anti Money Laundering system Actimize.

  2. Test and debug code using departmental standards and protocols prior to elevation.

  3. Act as a subject matter expert in the existing ETL packages used to load Actimize. Make recommendations and implement improvements to the packages.

  4. Review database design and code written by other database and application developers, identify issues and discuss efficiencies to improve data integration code and/or controls.

  5. Troubleshoot ETL issues as they arise by evaluating the ETL packages as well as the data stored in the source SQL, SAS, and flat files, and the destination MS SQL Server systems.

  6. Develop, update and maintain ETL specifications and documentation used to develop data migration mappings and transformations for data warehouse loading.

  7. Perform other related duties as assigned.



• An undergraduate degree in a related field or an equivalent combination of training and experience.
• A minimum of 3 - 5 years related experience with T-SQL and SQL Server Integration Services (SSIS) development in MS SQL Server environment.
• A minimum of two years Banking or financial services experience desirable
Other Qualifications:
• A working knowledge of Anti Money Laundering platforms and technologies such as Actimize a plus
• A basic knowledge of BASE/SAS or SAS data integration a plus
• 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
• A team player able to work effectively in a team fostered, multi-tasking environment with the ability to dive into issues with data to discover root causes.
• Proficient in Microsoft Office suite, e.g. Excel, PowerPoint, Word, Outlook

Contact Information

The Bancorp Bank
6100 S Old Village Place
Suite 200
Sioux Falls, SD 57108

Other Information

Category(s): Information Technology
Industry: Banking / Financial Services
Experience Req.: Yes
Degree Req.: No
Apply Now
Options for this Employer