Software Engineer III - AWS, Databricks, Python, Cognos

JPMorgan Chase & Co.; Columbus (OH); On-site; USD 110,000 - 160,000; Full time

Benefits offered by this job

Total rewards

Health care

Wellness centers

Job summary

JPMorganChase is seeking an experienced Software Engineer III to join the Corporate Technology FINTECH team in Columbus, OH. You’ll design and deliver trusted technology products in a secure, scalable way, contributing across multiple technical areas to support the firm’s objectives.

You’ll lead end-to-end ETL/ELT pipelines on Databricks, orchestrate AWS-based workflows, and enforce access controls and data security using Terraform and best practices.

Qualifications

• Formal training or certification on software engineering concepts
• 3+ years of experience with Databricks, PySpark, AWS and building ETL pipelines from scratch
• 3+ years of AWS experience (Lambda, Step Functions, SQS, SNS, API Gateway, Secrets Manager, storage)
• 3+ years of software engineering with Python and Terraform
• Hands-on experience with NiFi, Airflow and Autosys
• Strong REST API development using FASTAPI or similar frameworks
• Strong SQL skills with joins and aggregations

Responsibilities

• Design and build end-to-end ETL/ELT pipelines on Databricks using PySpark and SQL
• Develop and orchestrate AWS-based data workflows with Lambda, Step Functions, SQS/SNS, API Gateway
• Implement orchestration and operations using Airflow/NiFi/Autosys with SLAs and runbooks
• Build secure data-access controls via Terraform and enforce backup, recovery, and archiving

Skills

Python

REST API

ETL design

Data pipelines

Agile methods

Education

Technical training or certification in software engineering

Tools

Databricks

PySpark

AWS

Terraform

Apache Airflow

Apache NiFi

Autosys

FASTAPI

Job description

Job Description

Push the limits of what's possible with us as an experienced member of our Software Engineering team.

Job Description

Push the limits of what's possible with us as an experienced member of our Software Engineering team.

Job Description

Push the limits of what's possible with us as an experienced member of our Software Engineering team.

As a Software Engineer III at JPMorganChase within the Corporate Technology FINTECH team, you serve as member of an agile team to design and deliver trusted market-leading technology products in a secure, stable, and scalable way. You are responsible for carrying out critical technology solutions across multiple technical areas within various business functions in support of the firm's business objectives.

Job Responsibilities

• Design and build end-to-end ETL/ELT pipelines from scratch on Databricks using PySpark and SQL, including ingestion, transformation, and publishing of curated datasets for downstream analytics and applications.
• Develop and orchestrate AWS-based data workflows using Lambda, Step Functions, SQS/SNS, API Gateway, Secrets Manager, and storage services, with robust error handling, retries, and monitoring.
• Implement orchestration/scheduling and operational support using Apache Airflow / Apache NiFi / Autosys, including SLAs, backfills, runbooks, and production incident triage/root-cause analysis.
• Build secure, repeatable platform and data-access controls via Terraform and least-privilege principles; partner on access reviews/audit evidence and ensure backup, recovery, and archiving strategies are implemented and tested

Required Qualifications, Capabilities, And Skills

• Formal training or certification on software engineering concepts and 3+ years applied experience
• 3+ years of experience using technologies such as Databricks , Pyspark, AWS, is essential and creating ETL Pipeline from scratch is a must.
• 3+ years of experience working with AWS (Lambda, Step Function, SQS, SNS, API Gateway, secrets manager and storage services) is a must.
• 3+ years of experience in software engineering and object-oriented programming skills with expertise in Python and Terraform
• Hands on experience with open-source frameworks/libraries, such as Apache NiFi, Apache Airflow and Autosys.
• Strong understanding of REST API development using FASTAPI or equivalent frameworks.
• Advanced at SQL (e.g., joins and aggregations)

Preferred Qualifications, Capabilities, And Skills

• Familiar with development tools such as Jenkins, Jira, Git/Stash, spinnaker
• Familiarity with unit testing frameworks such as pytest or unittest.
• Extensive experience in statistical data analysis, with the ability to select appropriate tools and identify data patterns for effective analysis, as well as experience throughout the data lifecycle

ABOUT US

JPMorganChase, one of the oldest financial institutions, offers innovative financial solutions to millions of consumers, small businesses and many of the world's most prominent corporate, institutional and government clients under the J.P. Morgan and Chase brands. Our history spans over 200 years and today we are a leader in investment banking, consumer and small business banking, commercial banking, financial transaction processing and asset management.

We offer a competitive total rewards package including base salary determined based on the role, experience, skill set and location. Those in eligible roles may receive commission-based pay and/or discretionary incentive compensation, paid in the form of cash and/or forfeitable equity, awarded in recognition of individual achievements and contributions. We also offer a range of benefits and programs to meet employee needs, based on eligibility. These benefits include comprehensive health care coverage, on-site health and wellness centers, a retirement savings plan, backup childcare, tuition reimbursement, mental health support, financial coaching and more. Additional details about total compensation and benefits will be provided during the hiring process.

We recognize that our people are our strength and the diverse talents they bring to our global workforce are directly linked to our success. We are an equal opportunity employer and place a high value on diversity and inclusion at our company. We do not discriminate on the basis of any protected attribute, including race, religion, color, national origin, gender, sexual orientation, gender identity, gender expression, age, marital or veteran status, pregnancy or disability, or any other basis protected under applicable law. We also make reasonable accommodations for applicants' and employees' religious practices and beliefs, as well as mental health or physical disability needs. Visit our FAQs for more information about requesting an accommodation.

JPMorgan Chase & Co. is an Equal Opportunity Employer, including Disability/Veterans

About The Team

Our professionals in our Corporate Functions cover a diverse range of areas from finance and risk to human resources and marketing. Our corporate teams are an essential part of our company, ensuring that we're setting our businesses, clients, customers and employees up for success.