Data Warehouse Technician II

Job Description

Overview

Work Arrangement:

***After the initial training period, this is a hybrid role, working onsite in our Sioux Falls, SD office.***

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

Responsibilities

Essential Functions

1. Develops applications for parsing, extracting, and loading data using Base SAS, dbt, and Snowflake.
2. Documents, tests, and debugs data programs prior to implementation in the production environment using standard testing and validation protocols.
3. Summarizes data to optimize performance for scheduled processes and end-user reporting.
4. Maintains the data warehouse by monitoring production processes, developing ETL/ELT workflows, and troubleshooting issues.
5. Creates 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. Develops ETL/ELT processes for transforming, extracting, and loading data into the data warehouse and downstream systems.
7. Builds strong working relationships with project management and end users to understand issues related to reporting and data systems, and deliver accurate, time-saving solutions through the data warehouse.
8. Performs other duties as assigned.

Qualifications

Education/Experience Requirements

• Undergraduate degree in a related field or an equivalent combination of training and experience.
• Minimum 2 years of data warehouse development, ETL development or SAS programming experience.

Preferred Qualifications

• Experience with Snowflake, SnowSQL, and SAS. Experience with dbt, SSIS, Tableau, and Sigma is a plus.
• Previous financial services industry experience.
• Basic industry knowledge of SQL Server, Oracle, Perl, HTML, JavaScript, SFTP, Scheduling systems.
• 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.
• A team player who thrives in a collaborative, multitasking environment.
• No travel required.

Additional Information

This job will be open and accepting applications for a minimum of five days from the date it was posted.

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

Company Culture & Background Screening

Company Culture 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.

#LI-CB1

#LI-Hybrid