Mainframe Migration Data Analyst

Suna Solutions; Pasadena (CA); Hybrid; USD 96,000 - 103,000; Full time

Job summary

Suna Solutions in Pasadena, CA seeks a Systems Programmer Analyst for a contract role focused on mainframe migration and COBOL/JCL/CICS/DB2 analysis. The position requires hands-on COBOL experience and strong SQL/data analysis skills.

The hybrid role requires 3 days in-office, offering a 6–12 month engagement with a pay rate of $70.00 to $75.00 per hour. Candidates should be adept at impact assessments, data comparisons, and parallel-run validation while leveraging AI tools.

Qualifications

• Bachelor's degree from an accredited college in Computer Science, Information Systems, or closely related field, and at least three years of progressively responsible, full-time, paid experience in a centralized IT organization performing systems analysis, requirements documentation, application support, data analysis, SQL development, or related technical analysis work.
• Strong systems analyst experience including requirements gathering, functional and process analysis, technical documentation, stakeholder coordination, testing support, and implementation support.
• Advanced SQL proficiency for data analysis, reconciliation, testing, and validation.
• Experience analyzing relational databases, data models, source-to-target mappings, stored procedures, data quality issues, and application or batch processing logic.
• Experience supporting application development, enhancement, conversion, or modernization initiatives, including working with developers to clarify logic, validate outputs, and support design decisions.
• Desirable programming experience may include Java, Spring, scripting, batch processing, report development, stored procedures, mainframe, or legacy technologies.
• Experience designing automated parity/comparison gates and supporting legacy-to-modern parallel-run/cut-over cycles.

Responsibilities

• Serve as a Systems Programmer Analyst responsible for analyzing business and system needs, documenting requirements, and translating them into clear functional and technical specifications.
• Perform systems analysis across applications, databases, batch jobs, interfaces, reports, and operational processes to support enhancements, troubleshooting, conversions, and production support.
• Develop, execute, validate, and optimize complex SQL queries and scripts to research data issues, support analysis, confirm expected results, and validate business rules or system changes.
• Analyze data structures, database relationships, source-to-target mappings, and application logic to support reporting, integrations, batch processing, and modernization efforts.
• Create and maintain requirements documents, functional specifications, process flows, data mappings, test scenarios, validation results, and implementation support materials.
• Collaborate with business users, developers, database administrators, quality assurance staff, architects, and project teams to clarify requirements, evaluate options, and support delivery of system changes.
• Support development and testing activities by reviewing logic, validating program output, creating test data, documenting defects, and assisting with optional programming or scripting tasks when needed.
• Assist with production support, implementation planning, post-deployment validation, and clear communication of findings, risks, and recommended remediation steps.

Skills

Mainframe migration

COBOL

JCL

CICS

DB2

SQL

Education

Bachelor's Degree in Computer Science / Information Systems

Tools

COBOL tooling

Mainframe access

Job description

Suna Solutions in Pasadena, CA seeks a Systems Programmer Analyst for a contract role focused on mainframe migration and COBOL/JCL/CICS/DB2 analysis. The position requires hands-on COBOL experience and strong SQL/data analysis skills.

The hybrid role requires 3 days in-office, offering a 6–12 month engagement with a pay rate of $70.00 to $75.00 per hour. Candidates should be adept at impact assessments, data comparisons, and parallel-run validation while leveraging AI tools.