Data Warehouse Technician II

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.

Responsibilities

Essential Functions

  1. Develops 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.
  3. Summarizes data to optimize performance for scheduled processes and end user reporting.
  4. Maintains SAS data warehouse.
  5. Develops data feeds and reports for external and internal clients as requested. Question users to determine fields and array of data needed to fulfill requests. Creates and documents reports available in the report library.  Builds dynamic end user reporting systems to generate standard scheduled reports and easy interface functionality for ad hoc reporting needs.
  6. Develops data integration processes and procedures for transforming, extracting, and loading data between the data warehouse and internal OLTP database systems.
  7. Develops 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. Performs other duties as assigned.

Qualifications

Education/Experience Requirements

Preferred Requirements

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.

The Bancorp is an Equal Opportunity Employer

Apply Online