Job Description

***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 organization’s SSIS packages.

At The Bancorp, we’ve spent more than 25 years driving innovation in the financial services industry. As one of the first banks to embrace fintech, we combine technology, expertise and a forward-looking approach to deliver creative, real-world solutions. We work side by side with our partners to help them grow and innovate with confidence. Across Fintech Solutions, Institutional Banking, Commercial Lending and Real Estate Bridge Lending, we provide the people, processes, technology and banking capabilities that turn bold ideas into outcomes.

Join a team that brings urgency and rigor to every challenge and plays a direct role in driving growth for our clients and the communities we serve.

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/

Company Culture & Background Screening

Company Culture at The Bancorp Bank https://www.thebancorp.com/company/company-culture/

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