AVP Database Developer III (Hybrid)

Work Arrangement:

***This position is available as a hybrid position in our Sioux Falls, SD office.***  

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.

The AVP Database Developer III role 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. Becomes a subject matter expert in the organization’s SSIS packages.

• Creates new Extraction, Transformation, and Loading (ETL) packages to achieve data integration between various source and destination systems including the ACH & Wire transfer processing system GPP.
• 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 GPP data for reporting. 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.
• Develops close working relationships with project management and end users to understand issues and delivers accurate and efficient solutions.
• Serves as a mentor to less experienced database developers to develop their skills. Acts as a resource for the team by providing advice and guidance on programming issues and concerns. Brainstorms solutions with the team and provide feedback as needed.
• Performs other duties as assigned.
• No travel required.

• Undergraduate degree in a related field or an equivalent combination of training and experience.
• Minimum 5 years of T-SQL and SQL Server Integration Services (SSIS) development experience.

• Banking or financial services experience, preferred.
• Working knowledge of Anti Money Laundering platforms and technologies such as Actimize, preferred.
• Working knowledge of Global Payment Processing platforms and technologies such as Finastra’s GPP, preferred.
• Excellent verbal, written, and interpersonal communication skills, preferred.
• Excellent analytical ability, judgement, and problem analysis techniques, preferred.
• Ability to write and understand complex SQL queries, preferred.
• Ability to take ownership of projects and be self-directed, preferred.
• Ability to work effectively in a team-fashioned, multi-tasking environment, preferred.

What Success Looks Like

• SSIS packages and T-SQL solutions are clearly scoped, developed, tested, documented, and implemented in accordance with departmental standards.
• Data integrations across the organization’s ETL portfolio, including those supporting Actimize, operate reliably and deliver accurate, timely data to critical systems.
• Finastra Global Payment Processing (GPP) data structures, mappings, transformation rules, dependencies, and downstream uses are thoroughly understood and documented.
• Changes affecting GPP data used for ACH payments governed by Nacha rules and wire payment processing are evaluated early and translated into controlled ETL updates with minimal disruption and rework.
• Production issues are identified, analyzed, communicated, and resolved efficiently, with consideration for source data, ETL processing, destination systems, and business impact.
• Database designs and code are reviewed consistently, with performance, quality, maintainability, and control concerns identified and addressed before deployment.
• ETL specifications, data mappings, support procedures, and technical documentation remain current, accessible, and sufficient for ongoing maintenance and troubleshooting.
• Team capability grows through mentoring, knowledge sharing, constructive code reviews, and collaboration with developers, project managers, business stakeholders, and external partners.

Why This Role Matters

• The AVP Database Developer III helps The Bancorp turn internal and partner-provided data requirements into reliable, maintainable ETL solutions across critical business systems. By providing technical leadership across the ETL portfolio and serving as the subject matter expert for Finastra GPP data, this role helps ensure that data generated through ACH and wire payment processing is accurately understood, integrated, and made available for reporting and other downstream uses.
• In a regulated financial services environment, changes to third-party payment data can affect reporting, operational processes, compliance activities, and multiple downstream systems. This role provides the technical knowledge, disciplined testing, effective controls, reliable documentation, and cross-functional coordination needed to reduce risk, resolve issues efficiently, and support scalable data integration with confidence.

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:

Company Culture at The Bancorp Bank:

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.