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 array of data needed to fulfill requests. Creates and documents reports. Builds dynamic end user reporting systems to generate standard scheduled reports and easy interface functionality for ad hoc reporting needs.
- Mentors less experienced team members 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.
- Develops data integration processes and procedures for transforming extracting and loading data between the data warehouse and other internal data systems.
- Fosters close working relationships with project management and end users to design efficient data driven solutions.
- Assists with managing the workload of the team by assigning projects and tasks for the group.
- 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 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 fostered multi-tasking environment.Background & EEO Statement
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 & 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
Key Skills
Apache Hive,S3,Hadoop,Redshift,Spark,AWS,Apache Pig,NoSQL,Big Data,Data Warehouse,Kafka,Scala
Employment Type : Full-Time
Experience : years
Vacancy : 1
J-18808-Ljbffr