The Bancorp Bank

  • Data Warehouse Technician

    Job Location US-SD-Sioux Falls | US-DE-Wilmington
    Type
    Regular Full-Time
  • Overview

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

    Responsibilities

    1. Develop less complex applications for parsing, extracting, and loading data in base SAS.
    2. Document, test and debug data programs prior to implementation in the live production environment using standard testing and validation protocols. Escalate issues as needed to manager.
    3. Group and summarize data to optimize performance for scheduled processes and end user reporting.
    4. Assist in the maintenance, support and development of the SAS data warehouse, working under the guidance and direction of more experienced data warehouse programmers.
    5. Use SAS Dataflux technologies to clean and standardize data. Verify accuracy of data.
    6. Develop the simplest to moderately complex data feeds and reports for external and internal clients as requested. Question users to determine fields and array of data needed to fulfill requests. Create and document reports available in the report library.  Build dynamic end user reporting systems to generate standard scheduled reports and easy interface functionality for ad hoc reporting needs.
    7. Develop the least complex and more standardized data integration processes and procedures for transforming, extracting, and loading data between the data warehouse and internal OLTP database systems. Review processes with management as needed.
    8. Build close working relationships with systems project management with limited exposure to end users to review and resolve issues arising with the reporting and data systems and deliver accurate and time-saving solutions through the data warehouse.

    Qualifications

    Education/Experience:

    • An undergraduate degree in a related field or an equivalent combination of training and experience. Would consider as an internship. 
    • A minimum of 6 months to 1 year related data warehouse development, data modeling or SAS programming experience

    Other Qualifications:

    • Basic working knowledge of SAS technologies including Base SAS, SAS data management, DataFlux, Integration Technologies, Enterprise Guide, Metadata Server and SAS Visual Analytics.
    • Basic industry knowledge of SQL Server, Oracle, Perl, HTML, JavaScript, SFTP, 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

    Employment with The Bancorp includes successfully passing a background check including credit, criminal, OFAC, education and past employment.

     

    The Bancorp is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, religion, color, national origin, sex, sexual orientation, gender identity, age, status as a protected veteran, among other things, or status as a qualified individual with disability.

     

    Options

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