Lead Software Engineer- Data Warehousing- Snowflake

We have an opportunity to impact your career and provide an adventure where you can push the limits of whats possible.

As a Lead Software Engineer at JPMorgan Chase within the Consumer and Community Banking Data Platforms team you play a crucial role in an agile team dedicated to enhancing building and delivering trusted market-leading technology products in a secure stable and scalable manner. As a key technical contributor you are tasked with implementing critical technology solutions across multiple technical domains supporting various business functions to achieve the firms business objectives.

Job responsibilities

• Executes creative software solutions design development and technical troubleshooting with ability to think beyond routine or conventional approaches to build solutions or break down technical problems
• Develops secure high-quality production code and reviews and debugs code written by others
• Identifies opportunities to eliminate or automate remediation of recurring issues to improve overall operational stability of software applications and systems
• Leads evaluation sessions with external vendors startups and internal teams to drive outcomes-oriented probing of architectural designs technical credentials and applicability for use within existing systems and information architecture
• Leads communities of practice across Software Engineering to drive awareness and use of new and leading-edge technologies
• Adds to team culture of diversity opportunity inclusion and respect

Required qualifications capabilities and skills

• Formal training or certification on software engineering concepts and 5 years applied experience
• Hands-on practical experience delivering system design application development testing and operational stability
• Strong understanding of Snowflake architecture and features with hands-on experience in data loading unloading and transformation as well as knowledge of best practices for performance optimization.
• Proficient in Python for automation scripts and data processing.
• Experience with libraries such asboto3(for AWS interaction)pandas(for data manipulation) andsqlalchemy(for database interaction).
• Experience with AWS services such as S3 EC2 Lambda IAM and Glue with experience in setting up and managing AWS resources for data storage and processing as well as a solid understanding of AWS security best practices and cost management.
• Proficient in all aspects of the Software Development Life Cycle
• Strong SQL skills for querying and manipulating data in Snowflake with experience in writing complex queriesincluding joins subqueries and window functionsand a solid understanding of data modeling and database design principles.
• Advanced understanding of agile methodologies such as CI/CD Application Resiliency and Security
• Demonstrated proficiency in software applications and technical processes within a technical discipline (e.g. cloud artificial intelligence machine learning mobile etc.)
• In-depth knowledge of the financial services industry and their IT system.

• Familiarity with data visualization tools (e.g. Tableau Looker) for reporting.
• Knowledge of machine learning concepts and frameworks (if applicable to the role).
• Familiarity with version control systems like Git & Bitbucket.
• Ability to document processes and provide training to team members.
• Strong analytical skills to troubleshoot issues and optimize performance.