Hybrid Systems Analyst: Mainframe & SQL Modernization

Ledgent Technology; Pasadena (CA); Hybrid; USD 96,000 - 103,000; Full time

Job summary

Ledgent Technology is seeking an experienced Systems Programmer Analyst to support business-critical applications, data analysis, system enhancements, and modernization initiatives across legacy COBOL/mainframe and modern environments. You will analyze requirements, troubleshoot issues, and collaborate with stakeholders, DBAs, QA, and development teams.

The role demands COBOL experience, advanced SQL, and strong systems analysis skills, with a hybrid schedule of 2–3 days onsite per week in

Qualifications

• Bachelor’s degree or higher in a related field.
• Minimum 3 years of IT experience involving systems analysis, data analysis, or related work.
• Hands-on COBOL experience in mainframe/legacy environments.
• Strong systems analysis, requirements gathering, and documentation skills.
• Advanced SQL proficiency for complex queries and data validation.
• Experience with relational databases, data models, and batch processing.

Responsibilities

• Translate business and system requirements into functional/technical specs.
• Perform systems analysis across applications, databases, batch jobs, interfaces, and reports.
• Write, modify, and optimize complex SQL queries and scripts for data analysis and validation.
• Analyze databases, data structures, and data mappings; review application logic.
• Support COBOL-based applications and legacy systems for modernization efforts.
• Create and maintain requirements docs, specs, data mappings, and test scenarios.
• Collaborate with business users, developers, DBAs, QA, and project teams to clarify requirements.
• Support testing activities and post-deployment validation.

Skills

COBOL

SQL

Systems Analyst

Education

Bachelor’s degree in Computer Science, Information Systems, Business Information Systems, or related field

Tools

Java

Spring

Stored Procedures

Scripting

Batch Processing

Report Development

Job description

Ledgent Technology is seeking an experienced Systems Programmer Analyst to support business-critical applications, data analysis, system enhancements, and modernization initiatives across legacy COBOL/mainframe and modern environments. You will analyze requirements, troubleshoot issues, and collaborate with stakeholders, DBAs, QA, and development teams.

The role demands COBOL experience, advanced SQL, and strong systems analysis skills, with a hybrid schedule of 2–3 days onsite per week in