AVP Data Warehouse Analyst II

Job Location US-SD-Sioux Falls
Type
Regular Full-Time

Overview

Senior developer for the data warehouse team.  Designs, develops, tests, and maintains applications and processes to parse, extract, transform, and load data from multiple data sources to the data warehouse.

Responsibilities

 

Essential Functions

  1. Develops ETL applications for parsing, extracting, and loading of data.
  2. Documents, tests and debugs data programs prior to implementation in the live production environment using standard testing and validation protocols.
  3. Groups and summarizes data to optimize performance for scheduled processes and end user reporting.
  4. Develops, maintains and supports the data warehouse data structures and ETL processes.
  5. Develops the more complex data feeds and reports for external and internal clients as requested. Questions 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. Mentors less experienced data warehouse staff to develop their skills. Acts as a resource for the team by providing advice and guidance on programming issues and concerns.  Brainstorms solutions with the team and provides feedback as needed.
  7. Develops data integration processes and procedures for transforming, extracting, and loading data between the data warehouse and internal OLTP database systems.
  8. Develops close working relationships with project management and end users to understand data and reporting issues and deliver accurate and time-saving solutions.
  9. Performs other related duties as assigned.

Qualifications

Education/Experience Requirements

  • An undergraduate degree in a related field or an equivalent combination of training and experience.
  • A minimum of three years related data warehouse development, data modeling and ETL design and development experience.

Preferred Requirements

  • Previous financial services industry experience a plus.
  • Strong working knowledge of data warehouse storage, ETL and reporting technologies such as SQL, SAS, Snowflake, Tableau, Power BI, SAP Business Objects and AWS Glue.
  • Understanding of data governance and data quality practices.
  • Excellent verbal, written, and interpersonal communication skills
  • A team player able to work effectively in a team fostered, multi-tasking environment.

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

 

The Bancorp 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.

Options

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