Systems Analyst - Mainframe Migration

Akkodis; Pasadena (CA); Hybrid; USD 90,000 - 101,000; Full time

Job summary

Akkodis is seeking a Systems Analyst with mainframe migration experience for a contract-to-hire role located in Pasadena, CA. The hybrid work setup offers opportunities to analyze, design, and implement modernization efforts across applications and data platforms.

The role emphasizes strong SQL skills, requirements documentation, and collaboration with cross-functional teams to deliver system changes and validation. Bachelor’s degree and 3+ years in IT analysis are required.

Qualifications

• Bachelor's degree in CS/IS or closely related field required with at least 3 years of relevant experience.
• Strong systems analyst experience including requirements gathering and documentation.
• Experience with legacy/mainframe systems and modernization/migration is highly valuable.
• Advanced SQL proficiency for data analysis, reconciliation, and validation.

Responsibilities

• Analyze business and system needs and translate into functional and technical specs.
• Conduct systems analysis across apps, databases, batch jobs, interfaces, and processes.
• Develop and optimize complex SQL queries to support data analysis and validation.
• Analyze data structures and mappings to support reporting and modernization efforts.
• Create requirements docs, functional specs, data mappings, and test scenarios.
• Collaborate with users, developers, DBAs, QA, architects, and project teams to clarify requirements.
• Support development and testing activities including defect documentation and test data creation.
• Assist with production support, deployment planning, and post-release validation.

Skills

Systems analysis

SQL development

Data analysis

Requirements gathering

Problem solving

Education

Bachelor's degree in CS/IS

Tools

SQL

Stored procedures

Mainframe

Job description

Akkodis is seeking a Systems Analyst - Mainframe Migration for a Contract-to-hire role with a client located in Pasadena, CA (Hybrid).

Pay Range: $65- $73/hour; The rate may be negotiable based on experience, education, geographic location, and other factors.

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.
• Experience working with legacy/mainframe systems and modernization/migrationis highly valuable.
• 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 Opportunity Employer/Veterans/Disabled

Benefit offerings available for our associates include medical, dental, vision, life insurance, short-term disability, additional voluntary benefits, an EAP program, commuter benefits, and a 401K plan. Our benefit offerings provide employees the flexibility to choose the type of coverage that meets their individual needs. In addition, our associates may be eligible for paid leave including Paid Sick Leave or any other paid leave required by Federal, State, or local law, as well as Holiday pay where applicable. Disclaimer: These benefit offerings do not apply to client-recruited jobs and jobs that are direct hires to a client.

The Company will consider qualified applicants with arrest and conviction records in accordance with federal, state, and local laws and/or security clearance requirements, including, as applicable:

• The California Fair Chance Act
• Los Angeles City Fair Chance Ordinance
• Los Angeles County Fair Chance Ordinance for Employers