Data Warehouse Analyst I

Job Location US-SD-Sioux Falls
Full Time


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


Essential Functions

  1. Develop ETL processes for parsing, extracting, and loading data in Base SAS and SnowSQL.
  2. Document, test and debug data 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. Develop 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.
  5. Develop data integration processes and procedures for transforming, extracting, and loading data between the data warehouse and internal OLTP database systems.
  6. Develop close working relationships with project management and end users to understand issues arising with reporting and data systems and deliver accurate and time-saving solutions through the data warehouse.
  7. Monitor, troubleshoot, and resolve issues with daily production processes and assist with maintenance of reporting portal and data warehouse.
  8. Perform other related duties as assigned.


Education/Experience Requirements

  • An undergraduate degree in a related field or an equivalent combination of training and experience.
  • A minimum of 1 year work or coursework experience with data warehouse design, SAS programming or SQL query writing
  • Previous financial services industry experience a plus

Preferred Requirements

  • Working knowledge of SAS technologies including Base SAS, SAS Data Management, DataFlux, Integration Technologies, Enterprise Guide, or Metadata Server.
  • Basic industry knowledge of MS SQL Server, HTML, and Scheduling systems a plus
  • Excellent verbal, written, and interpersonal communication skills
  • Self-motivated with the ability to effectively work independently and as a team member in a multi-tasking environment.

Background & EEO Statement

Working at The Bancorp Bank, N.A. and Benefits Information: click here

Diversity & Background Screening

Diversity & Inclusion at The Bancorp Bank: click here


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.


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