AVP Database Developer II

As the AVP Database Developer II at The Bancorp Bank, you will take on diverse responsibilities such as designing and implementing ETL packages, particularly for our Anti Money Laundering system, Actimize. You'll also be involved in troubleshooting existing ETL packages, reviewing code for efficiency, and maintaining essential database documentation. Your expertise in T-SQL and SQL Server Integration Services (SSIS) will be crucial for improving our data integration processes.

To be considered for the AVP Database Developer II position at The Bancorp Bank, candidates should ideally possess an undergraduate degree in a related field or equivalent experience. A minimum of 3 years’ experience in T-SQL and SSIS is required, along with strong skills in writing complex SQL queries. Experience in banking or financial services, particularly with Anti Money Laundering technologies, will give applicants an edge.

Success as an AVP Database Developer II at The Bancorp Bank requires a combination of technical and interpersonal skills. Strong analytical ability and problem-solving techniques are essential, alongside excellent verbal and written communication skills. The ability to work effectively in teams while managing your projects independently is key. Familiarity with financial systems and technologies such as Actimize is a plus.

The work environment for the AVP Database Developer II at The Bancorp Bank combines onsite collaboration at our Sioux Falls office with the flexibility of a hybrid work arrangement after the initial training period. You'll join a supportive team that fosters professional growth and encourages innovation in data management and integration, all within the financial services sector.

At The Bancorp Bank, the AVP Database Developer II role opens doors to numerous growth opportunities. You’ll have access to professional development initiatives and training to enhance your technical skills. Additionally, as the bank continues to innovate, there may be avenues to advance into more senior roles or specialize in emerging database technologies and data governance practices.

In your response, detail your experience with T-SQL, providing examples of successful projects where you've utilized it. Discuss your understanding of T-SQL’s role in database management and how you’ve applied it to troubleshoot or improve ETL processes.

When answering this question, highlight your analytical process for identifying and resolving ETL issues. Discuss specific tools or methodologies you use, such as evaluating package logs, source data quality checks, and monitoring ETL workflows for bottlenecks.

Share your perspective on best practices for database integrations. Mention tools you prefer, how you conduct code reviews, optimize queries, and ensure your processes adhere to departmental standards for efficiency.

Use this opportunity to discuss a specific project where you took ownership. Describe the challenge, the approach you adopted, and the impact of your autonomous work on the project's success.

Explain your strategies for professional development, such as online courses, webinars, or reading industry publications. Highlighting a proactive approach shows your commitment to continuous learning, which is desirable in a fast-evolving field.

Articulate the significance of documentation in database management, especially for ETL processes. Discuss any tools or templates you prefer and your routine for maintaining up-to-date documentation for team collaboration.

Share techniques that help you bridge the gap between technical and non-technical audiences. Emphasize your ability to use clear language, visuals, or analogies to make complex concepts understandable.

If applicable, discuss your familiarity with Actimize and your role in integrating or maintaining it within a database environment. If you lack direct experience, mention any relevant skills that could apply, such as knowledge of regulatory compliance.

In your answer, envision a collaborative workspace that values innovation and communication. Describe how a supportive team culture and flexible arrangements could enhance your productivity and job satisfaction.

Discuss your systematic approach to analyzing ETL packages, focusing on performance metrics, identifying redundancies, and implementing improvements that streamline data processing. Mention specific tools or techniques you might use.