Lead Data Engineer - Mainframe DB2 DBA

JPMorgan Chase & Co.; Plano (TX); On-site; USD 140,000 - 190,000; Full time

Job summary

JPMorgan Chase & Co. seeks a Lead Data Engineer in Plano, TX to drive data collection, storage, access, and analytics solutions within a secure, scalable framework. You will maintain critical data pipelines and architectures across multiple business functions to support firm objectives.

The role emphasizes collaboration with cross-functional teams, mainframe DB2 expertise, and leveraging AI-assisted methods while ensuring data safety and resiliency in production environments.

Qualifications

• Formal training or certification in Data Engineering concepts with 5+ years applied experience.
• Working knowledge of relational databases (RDBMS) and SQL operations.
• Experience using enterprise-authorized AI capabilities to support data engineering workflows with validation habits and awareness of data sensitivity.
• Ability to review and validate AI-assisted outputs before use, escalating when uncertain and following data handling requirements.
• Knowledge of JES2 and JCL, including RACF/ACF2 Security and CA7/ZEKE.
• Experience with performance analysis to optimize SQL workloads.
• Knowledge of SYSPLEX mainframe configuration including Data Sharing.
• Knowledge of the data lifecycle and data management functions.
• Working knowledge of mainframe data system components.
• Strong understanding of data modeling fundamentals.
• Ability to work in large, collaborative teams to achieve goals.

Responsibilities

• Maintains and supports Db2 database applications.
• Uses enterprise-authorized AI capabilities to accelerate data platform and model design analysis and documentation, validating outputs and handling data per security requirements.
• Experienced with mainframe environment including TSO/ISPF/JCL.
• Develop rapport with application development teams for collaboration.
• Expertise with troubleshooting/diagnosing mainframe DB2 related issues.
• Maintains review of controls to ensure protection of enterprise data.
• Implements database back-up, recovery, and archiving strategy.
• DDL Deployment, environment data refreshes, health checks.
• Maintains highest levels of stability, integrity, reliability, and availability.
• Experience with SQL and databases utilities including connectivity.
• Adds to team culture of teamwork, collaboration, and partnership.
• Applies reuse-first, AI-assisted practices within delivery and operational routines with traceability and auditability.

Skills

Relational databases & SQL

AI-assisted data engineering

Data modeling fundamentals

Team collaboration

Data lifecycle understanding

Mainframe data systems

SQL performance analysis

Data sensitivity & security awareness

Review AI outputs for validation

Problem solving in large teams

Education

Formal training or certification in Data Engineering

5+ years data engineering experience

Tools

JES2 & JCL

RACF/ACF2 Security

CA7/ZEKE

TSO/ISPF

Job description

As a Lead Data Engineer at JPMorgan Chase within the Commercial & Investment Bank - Production Management team, you are an integral part of an agile team that works to enhance, build, and deliver data collection, storage, access, and analytics solutions in a secure, stable, and scalable way. As a core technical contributor, you are responsible for maintaining critical data pipelines and architectures across multiple technical areas within various business functions in support of the firm's business objectives.

Job responsibilities

• Maintains and supports Db2 database applications
• Uses enterprise-authorized AI capabilities within the work environment to accelerate data platform and model design analysis and documentation, validating outputs and handling data according to sensitivity and security requirements.
• Experienced with mainframe environment and use of TSO / ISPF / JCL
• Develop rapport with application development teams for collaboration
• Expertise with troubleshooting / diagnosing mainframe db2 related issues
• Maintains review of controls to ensure sufficient protection of enterprise data
• Implements database back-up,recovery, and archivingstrategy
• DDL Deployment , environment data refreshes, regular health checks
• Maintains highest levels of stability, integrity, reliability, and availability
• Experience with SQL and databases utilities including connectivity
• Adds to team culture of team work , collaboration, and partnership
• Applies reuse-first, AI-assisted practices within delivery and operational routines (e.g., backup/recovery validation and access control review support), ensuring traceability/auditability and alignment to resiliency and security expectations.

Required qualifications, capabilities, and skills

• Formal training or certification on Data Engineering concepts and 5+ years applied experience
• Working knowledge of relational databases (RDBMS) and SQL operations
• Demonstrated experience using enterprise-authorized AI capabilities within the work environment to support data engineering workflows with strong validation habits and awareness of data sensitivity.
• Ability to review and validate AI-assisted outputs (e.g., model/design summaries or operational checklists) before use, escalating when uncertain and following data handling requirements.
• Working knowledge of JES2 and JCL, including RACF / ACF2 Security and CA7 / ZEKE
• Experience with performance analysis to optimize SQL workloads
• Knowledge of SYSPlex mainframe configuration including Data Sharing
• Knowledge of the data lifecycle and data management functions
• Working knowledge of mainframe data system components
• Strong understanding of data modeling fundamentals (e.g., primary and foreign keys, constraints, indexing, etc.)
• Ability to work in large, collaborative teams to achieve organizational goals, with a passion to build an innovative culture
• Knowledge of industry-wide technology trends and best practices

Preferred qualifications, capabilities, and skills

• Understanding of general Mainframe Utilities, Database Utilities and Stored Procedures
• Familiar with mainframe environment and the use of TSO / ISPF
• Understanding of Distributed and Static SQL workloads
• Understanding of plex mainframe configuration including Data Sharing & Stand-In
• Familiar with IDAA (Data Analytics Accelerators)