The Bancorp Bank, N.A. is looking for a lead developer and designer for their data warehouse team to design, develop, test, and maintain applications and processes for data extraction, transformation, and loading from multiple sources into the data warehouse.
Requirements
- A minimum of 5 years of experience in data warehouse design and development, report writing, and ETL development.
- Experience with Snowflake, SnowSQL, and ETL/ELT tools.
- Experience with dbt and SSIS a plus.
- Understanding of data governance and data quality best practices.
Responsibilities
- Designs, develops, tests, and maintains applications and processes to parse, extract, transform, and load data from multiple data sources to the data warehouse.
- 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.
- Develops data integration processes and procedures for transforming, extracting, and loading data between the data warehouse and other internal data systems.
Other
- Acts as a lead developer and designer for the data warehouse team.
- 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.
- 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.
- Excellent verbal, written, and interpersonal communication skills.
- A team player, able to work effectively in a team fostered, multi-tasking environment.
