Job Description:

The Function
The Client Outreach team are the front line unit who work with clients as part of meeting Know Your Client (KYC) periodic refresh and remediation requirements. We work in close collaboration with Global Corporate and Investment Bankers and Global Markets Sales to support the Bank's global regulatory and policy requirements as it relates Client Due Diligence (CDD) documentation collection, with support from Operations and Global Financial Crimes Risk teams.

The team identifies and develops client connections, engages client representatives to obtain KYC documentation, and acts as a coordination point for resolving issues/challenges with respect to client and country specific documentation requirements in a timely manner.

• Collaborate with business partners to identify, design, develop, test, and maintain automation of business processes
• Develop and maintain Dash web application with user friendly interface for workflow processing, data visualization and exploration and efficient reporting
• Design and implement relational databases in Impala to effectively store and manage data
• Develop optimal schemas for Impala tables based on query patterns and data characteristics
• Integrate Dash applications with Impala to efficiently query and process large data sets
• Implement and manage Oozie job schedulers for maintaining ETL processes to efficiently load, transform and distribute daily data
• Employ agile development practices to develop effective business solutions based on the business needs

• Education & Experience:
• Bachelor's degree required, Master's or higher degree in Computer Science, Mathematics, Applied Mathematics, Statistics/Data Science, or related Quantitative experience preferred.

• 5+ years of working experience in process automation, data analysis, and/or ETL development with a focus on banking and financial services.

• Domain Knowledge & Problem-Solving Skills:

• Demonstrable experience in the banking industry, with a solid understanding of banking processes, financial regulations, and risk management principles.
• Excellent problem-solving with a knack for identifying automation opportunities and designing efficient solutions.
• Strong analytical and critical thinking skills to assess process efficiency and effectiveness.

• Technical Expertise:

• Advanced proficiency in Python with minimum 2 years of programming experience including data manipulation and analysis using libraries such as Pandas, NumPy, and SQLAlchemy.
• Extensive experience with Dash framework for building web applications.
• In-depth knowledge of Impala or other SQL-on-Hadoop query engines.
• Understanding of web development concepts (HTML, CSS, JavaScript).
• Proficiency in data visualization libraries (Plotly, Seaborn).
• Solid understanding of database design principles and normalization.
• Experience with ETL tools and processes and Apache Oozie or similar workflow management tools.
• Understanding of Machine Learning and AI concepts is a plus.

• Leadership & Interpersonal Skills:

• Proven track record of managing and executing automation projects from initiation to completion, ensuring adherence to timelines and quality standards
• Strives to bring new thoughts and ideas to drive innovation and implement unique solutions.
• Exceptional communication and interpersonal skills to effectively drive collaboration with stakeholders across all levels of the organization.
• Commitment to challenging the status quo and promoting positive change through automation.
• Ability to present complex technical concepts in a clear and concise manner to both technical and non-technical audiences.