Lead Software Engineer-ETL

Testing Site - JPMC; Wilmington (DE); On-site; USD 140,000 - 190,000; Full time

Job summary

JPMorgan Chase is seeking a Lead Software Engineer-ETL to join the Consumer and Community Banking Data Technology team. You will be a core technical contributor delivering secure, scalable data solutions and advancing trusted technology products.

Responsibilities include designing and delivering production code, reviewing peers, automating remediation, and guiding architectural decisions with internal and external partners.

Qualifications

• Formal training or certification in software engineering concepts and 5+ years applied experience.
• Extensive Data Engineering experience with Ab Initio, Teradata, PySpark, AWS Cloud and Snowflake.
• Proficiency in Python and SQL; strong SDLC and automation knowledge.

Responsibilities

• Executes creative software solutions with the ability to think beyond routine approaches.
• Develops secure production code and reviews code written by others.
• Identifies opportunities to automate remediation for reliability.
• Leads evaluation sessions with vendors and teams to drive architectural decisions.
• Leads communities of practice to promote new technologies.
• Contributes to team culture of diversity, inclusion, and respect.

Skills

Python

SQL

Data Engineering

CI/CD

Agile methodologies

Automation

SDLC

Cloud

Education

Software Engineering Certification

Tools

Ab Initio

Teradata

PySpark

AWS

Snowflake

DBT

Airflow

Data Modelling

Job description

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-ETL at JPMorgan Chase within the Consumer and Community Banking Data Technology team, youare an integral part of an agile team that works to enhance, build, and deliver trusted market-leading technology products in a secure, stable, and scalable way. As a core technical contributor, you are responsible for conducting critical technology solutions across multiple technical areas within various business functions in support of 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
• Extensive experience in Data Engineering with strong background in both legacy and modern tech stack - Ab Initio, Teradata, PySpark, AWS Cloud, and Snowflake
• Expertise in Python programming language and SQL
• Hands-on practical experience delivering system design, application development, testing, and operational stabilityDemonstrated proficiency in automation and continuous delivery methods
• Demonstrated proficiency in all aspects of the Software Development Life Cycle
• 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 systems
• Practical cloud native experience

Preferred qualifications, capabilities, and skills

• Previous experience working on credit card related projects
• Working knowledge of DBT, Airflow, Data Modelling