Lead Data Engineer - Mainframe DB2 DBA

Next Frontier Capital; Plano (TX); On-site; USD 140,000 - 170,000; Full time

Job summary

JPMorgan Chase & Co. seeks a Lead Data Engineer to join the Commercial & Investment Bank - Production Management team. You will be a core technical contributor, maintaining data pipelines, storage, access, and analytics solutions in a secure, scalable manner.

The role emphasizes collaboration across teams to deliver data-driven insights and robust data architectures supporting the firm's objectives.

Qualifications

• Formal training or certification on Data Engineering concepts and 5+ years applied experience
• Working knowledge of relational databases (RDBMS) and SQL operations
• 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)
• 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

Responsibilities

• Maintains and supports Db2 database applications
• 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 archiving strategy
• 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

Skills

Data Engineering

SQL

Mainframe

JCL

TSO/ISPF

JES2

RACF/ACF2

Education

Data Engineering Certification

Tools

DB2

JES2

ISPF

JCL

RACF/ACF2

CA7/ZEKE

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
• 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 archiving strategy
• 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

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
• 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)

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.