The Bancorp Bank

  • Data Warehouse Technician

    Job Location US-SD-Sioux Falls
    Regular Full-Time
  • Overview

    Design, develop, test, and maintain applications and processes to parse, extract, transform, and load data from multiple data sources to the data warehouse.


    1. Develop applications for parsing, extracting, and loading raw data into the data warehouse.
    2. Document, test and debug ETL programs prior to implementation in the live production environment using standard testing and validation protocols.
    3. Group and summarize data to optimize performance for scheduled processes and end user reporting.
    4. Maintain, support and develop the data warehouse.
    5. Develop data feeds and reports for external and internal clients as requested.
    6. Develop data integration processes and procedures for transforming, extracting, and loading data between the data warehouse and internal OLTP database systems.
    7. Develop close working relationships with project management and end users to understand issues arising with the reporting and data systems and deliver accurate and time-saving solutions through the data warehouse.
    8. Perform other related duties as assigned.



      • An undergraduate degree in a related field or an equivalent combination of training and experience.
      • Data processing, data modeling, or SAS experience a plus
    • Previous financial services industry experience a plus


    Other Qualifications:

    • Working knowledge of SAS technologies including Base SAS, SAS DI Studio, SAS Data Management, DataFlux, Integration Technologies, Enterprise Guide, and Metadata Server.
    • Basic industry knowledge of SQL Server, Perl, HTML, JavaScript, Scheduling systems a plus
    • Excellent verbal, written, and interpersonal communication skills
    • A team player able to work effectively in a team fostered, multi-tasking environment
    • Proficient in Microsoft Office suite, e.g. Excel, PowerPoint, Word, Outlook

    The Bancorp is an Equal Opportunity Employer.


    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed