Data Engineer II - AWS/PySpark/ETL

JP Morgan Chase; Columbus (OH); On-site; USD 110,000 - 150,000; Full time

Job summary

JPMorgan Chase in Columbus, OH is hiring a Data Engineer III to join the CCB and Data Technology team. You will design and deliver trusted data collection, storage, access, and analytics solutions in a secure, scalable manner, acting as a core technical contributor across multiple business functions.

You will build and optimize data pipelines, ensure data quality, and collaborate with cross-functional teams to meet business objectives.

Qualifications

• Experience with ETL tools and data integration
• Strong coding in PySpark and Python with AWS
• Hands-on experience with modern data lakes such as Snowflake and Databricks

Responsibilities

• Executes creative software solutions, design, development, and troubleshooting to build scalable data systems
• Develops secure production code and reviews code written by others
• Identifies opportunities to automate recurring remediation to improve stability
• Collaborate with cross-functional teams to develop efficient data pipelines for data-driven initiatives
• Implement best practices for data engineering, ensuring data quality, reliability, and performance
• Perform data extraction and transform data to meet business requirements
• Apply advanced analytics to improve data pipelines and ensure consistent data delivery
• Monitor data quality checks and address anomalies proactively
• Ensure data availability and accuracy for analytical use
• Identify opportunities to automate data engineering workflows
• Communicate technical concepts to technical and non-technical stakeholders

Skills

ETL tools

PySpark & Python

AWS

Data lakes

Data pipeline

Automation

Tools

Snowflake

Databricks

Airflow

CI/CD tooling

Job description

Job Description

Be part of a dynamic team where your distinctive skills will contribute to a winning culture and team.

As a Data Engineer III at JPMorgan Chase within the CCB and Data Technology team, you serve as a seasoned member of an agile team to design and deliver trusted data collection, storage, access, and analytics solutions 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
• Collaborate closely with cross-functional teams to develop efficient data pipelines to support various data-driven initiatives
• Implement best practices for data engineering, ensuring data quality, reliability, and performance
• Perform data extraction and implement complex data transformation logic to meet business requirements
• Leverage advanced analytical skills to improve data pipelines and ensure data delivery is consistent across projects
• Monitor and executes data quality checks to proactively identify and address anomalies
• Ensure data availability and accuracy for analytical purposes
• Identify opportunities for process automation within data engineering workflows
• Communicate technical concepts to both technical and non-technical stakeho

Required qualifications, capabilities, and skills

• Experience with ETL tools like Ab Initio, Informatica, Data Pipeline and workflow management tools (Airflow, etc.)
• Strong hands on coding experience with PySpark, Python and AWS
• Experience working with modern Data Lakes : (Snowflake, Databricks etc.)
• Hands-on practical experience delivering system design, application development, testing, and operational stability
• Very strong problem solving skills
• Proficiency in automation and continuous delivery methodsWillingness and ability to learn and pick up new skillsets

Preferred qualifications, capabilities, and skills

• Advanced in one or more programming language(s) like SQL, Java etc
• Proficient 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 etc.)
• In-depth knowledge of the financial services industry and their IT systems
• Practical cloud native experience
• Proven leadership and mentoring experience with varying levels of software engineers

ABOUT US

Chase is a leading financial services firm, helping nearly half of America’s households and small businesses achieve their financial goals through a broad range of financial products. Our mission is to create engaged, lifelong relationships and put our customers at the heart of everything we do. We also help small businesses, nonprofits and cities grow, delivering solutions to solve all their financial needs.

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.

Equal Opportunity