DeveloperJobs.io
← Back to all jobs

Job Description

The Bancorp Bank, N.A. is seeking an AVP Database Developer III to design, develop, and implement data integration packages that support reliable reporting and payment processing. In this hybrid role based in Sioux Falls, SD, you will work across ETL and database programming, serving as a subject matter expert for SSIS packages and contributing to the disciplined delivery of controlled changes.

You will focus on creating and maintaining ETL workflows, troubleshooting integration issues, and supporting GPP data loading used for reporting and downstream uses tied to ACH and wire payment systems.

Responsibilities

  • Create new Extraction, Transformation, and Loading (ETL) packages to integrate data between source and destination systems, including the ACH & Wire transfer processing system GPP.
  • Test and debug ETL-related code using departmental standards and protocols prior to elevation.
  • Act as a subject matter expert for existing ETL packages that load GPP data for reporting, recommending and implementing improvements.
  • Review database designs and code written by other database and application developers, identifying issues and discussing efficiencies to improve integration code and/or controls.
  • Troubleshoot ETL issues by evaluating ETL packages, source data, and destination systems.
  • Develop, update, and maintain ETL specifications and documentation used to build data migration mappings and transformations.
  • Build close working relationships with project management and end users to understand issues and deliver accurate and efficient solutions.
  • Serve as a mentor to less experienced database developers by providing advice and guidance on programming issues, brainstorming solutions, and offering feedback as needed.
  • Perform other duties as assigned.
  • No travel required.

Requirements

  • 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.

Technologies

  • T-SQL
  • SQL Server
  • SQL Server Integration Services (SSIS)
  • Actimize
  • Finastra GPP
  • Global Payment Processing

Work Arrangement

  • Hybrid position in the Sioux Falls, SD office.

What Success Looks Like

  • SSIS packages and T-SQL solutions are clearly scoped, developed, tested, documented, and implemented according to departmental standards.
  • Data integrations across the organization’s ETL portfolio, including integrations supporting Actimize, run 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 impacting GPP data used for ACH payments governed by Nacha rules and wire payment processing are evaluated early and implemented through controlled ETL updates with minimal disruption.
  • Production issues are identified, analyzed, communicated, and resolved efficiently while considering source data, ETL processing, destination systems, and business impact.
  • Database designs and code are reviewed consistently, with attention to performance, quality, maintainability, and control concerns before deployment.
  • ETL specifications, data mappings, support procedures, and technical documentation remain current, accessible, and sufficient for ongoing maintenance and troubleshooting.
  • Team capability improves through mentoring, knowledge sharing, constructive code reviews, and collaboration with developers, project managers, business stakeholders, and external partners.

Additional Information

  • This job will be open and accepting applications for a minimum of five days from the date it was posted.

Company Culture & Background Screening

  • 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 includes successfully passing a background check, including credit, criminal, education, employment, OFAC, and social media background history.

Similar Jobs