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 what's 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 firm's 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 as boto3 (for AWS interaction), pandas (for data manipulation), and sqlalchemy (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 queries-including joins, subqueries, and window functions-and 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 appli...