The Ban
Overview
Work Arrangement:
***After the initial training period, this is a hybrid role, working onsite in our Sioux Falls, SD office.***
Acts as a lead developer and designer 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
Develops ETL/ELT processes and models for parsing, extracting, and loading data.
Documents, tests, and debugs data programs prior to implementation in the live production environment using standard testing and validation protocols.
Groups and summarizes data to optimize performance for scheduled processes and end user reporting.
Develops, maintains, and supports the data warehouse data structures and ETL/ELT processes.
Develops complex data feeds and reports for external and internal clients as requested. Questions users to determine fields and data needed to fulfill requests. Creates and documents reports. Builds dynamic end user reporting systems to generate standard scheduled reports and interfaces for ad hoc reporting needs.
Mentors less experienced team members, providing guidance on programming issues and concerns. Collaborates with the team to brainstorm solutions and offers feedback.
Develops data integration processes and procedures for transforming, extracting, and loading data between the data warehouse and other internal systems.
Fosters close working relationships with project management and end users to design efficient data-driven solutions.
Assists in managing the team's workload by assigning projects and tasks.
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 5 years of experience in data warehouse design and development, report writing, and ETL development. Previous financial services industry experience is a plus.
Preferred Qualifications: Experience with Snowflake, SnowSQL, and ETL/ELT tools. Experience with dbt and SSIS is a plus. Understanding of data governance and data quality best practices. Excellent verbal, written, and interpersonal communication skills. A team player, able to work effectively in a team-oriented, multi-tasking environment.
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 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 categories in recruitment, hiring, training, promotion, and other employment terms. Employment includes passing a background check including credit, criminal, education, employment, OFAC, and social media background history. #LI-CB1 #LI-Hybrid #J-18808-Ljbffr
Qualifications
Education/Experience Requirements: An undergraduate degree in a related field or an equivalent combination of training and experience. A minimum of 5 years of experience in data warehouse design and development, report writing, and ETL development. Previous financial services industry experience is a plus.
Preferred Qualifications: Experience with Snowflake, SnowSQL, and ETL/ELT tools. Experience with dbt and SSIS is a plus. Understanding of data governance and data quality best practices. Excellent verbal, written, and interpersonal communication skills. A team player, able to work effectively in a team-oriented, multi-tasking environment.
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 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 categories in recruitment, hiring, training, promotion, and other employment terms. Employment includes passing a background check including credit, criminal, education, employment, OFAC, and social media background history. #LI-CB1 #LI-Hybrid #J-18808-Ljbffr