System 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

Location: Pasadena, CA 91030 hybrid role (3 days in office)

Pay Rate: $70.00 to $75.00 per hour

Duration: 6-12 Months

We are looking for a candidate with direct Mainframe migration experience and strong COBOL/JCL/CICS/DB2 analysis skills, preferably with hands‑on COBOL experience. The candidate should be able to perform impact assessments, data comparisons, and parallel‑run validation, while also being familiar with the latest AI tools.

Responsibilities and Requirements

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.

Requirements

• A Bachelor's Degree from an accredited college in Computer Science, Information Systems, Business Information Systems, or a closely related field, -AND- at least three (3) years of progressively responsible, full‑time, paid experience in a centralized Information Technology organization performing systems analysis, requirements documentation, application support, data analysis, SQL development, application development, or related technical analysis work.
• Strong systems analyst experience is required, including requirements gathering, functional and process analysis, technical documentation, stakeholder coordination, testing support, and implementation support.
• Advanced SQL proficiency is required, including writing, modifying, debugging, optimizing, executing, and validating SQL queries and scripts for data analysis, reconciliation, troubleshooting, reporting, and system validation.
• Experience analyzing relational databases, data models, source‑to‑target mappings, stored procedures, data quality issues, and application or batch processing logic is required.
• Experience supporting application development, enhancement, conversion, or modernization initiatives is required, including the ability to work with developers and technical teams to clarify logic, validate outputs, and support design decisions.
• Programming experience is preferred but not required; desirable experience may include Java, Spring, scripting, batch processing, report development, stored procedures, mainframe, or legacy technologies.
• Experience designing automated parity/comparison gates instead of manual report‑by‑report checks, and supporting a legacy‑to‑modern parallel‑run/cut‑over cycle is preferred.
• Strong analytical, troubleshooting, problem‑solving, communication, facilitation, documentation, and attention‑to‑detail skills are required.

EQUAL EMPLOYMENT OPPORTUNITY STATEMENT:

Suna Solutions provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.

This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.

Applicants, with criminal histories, are considered in a manner that is consistent with local, state, and federal laws.

REQUESTING AN ACCOMODATION

Suna Solutions is committed to providing equal employment opportunities for persons with disabilities or religious observances, including reasonable accommodation when needed. If you are hired by Suna Solutions and require accommodation to perform the essential functions of your role, you will be asked to participate in our reasonable accommodation process. Accommodations made to facilitate the recruiting process are not a guarantee of future or continued accommodations once hired.

PAY TRANSPARENCY POLICY STATEMENT

Compensation for roles at Suna Solutions varies depending on a wide array of factors including but not limited to the specific client, office or remote location, role, skill set and level of experience. As required by local law, Suna Solutions provides a reasonable pay scale to include the hourly or salary range that Suna Solutions reasonably expects to pay for roles that may be hired in California, Colorado, New York City or Washington as set forth below.