Role Responsibilities
The candidate is expected to work closely with business partners as a thought leader, driving the development of data opportunities, gathering requirements and successfully delivering solutions that result in cost savings, risk mitigation, regulatory compliance, business enablement and client engagement
- Collaborate with business partners to proactively identify, design, develop, test, and maintain automation of the business processes
- Coordinate development across stakeholder groups and influence decision making across the full lifecycle of the projects
- Serve as lead architect and escalation point for maintenance issues
- 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
Required Skills
- 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.
- 8+ 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.
- 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.
1st shift (United States of America)