Sign upLog in
See more jobs

Systems Programmer Analyst

Prosum
  • Pasadena, CA
  • $70–$75 Per Hour
  • Instant Apply
Today

Job Description

Systems Programmer Analyst Pay Range: $70/hour to $75/hour
Location: Pasadena, CA (Hybrid)  Position Overview
We are seeking an experienced Systems Programmer Analyst to join our Information Technology team. This role combines systems analysis, advanced SQL, data analysis, technical documentation, application support, and collaboration with business and technical teams.

The Systems Programmer Analyst will analyze business and system needs, translate requirements into clear functional and technical specifications, investigate complex data and application issues, and support the design, development, testing, implementation, and ongoing support of enterprise systems.

The ideal candidate is a strong analytical problem-solver who is comfortable working with relational databases and SQL, understands application and batch-processing logic, and can effectively communicate with both technical and non-technical stakeholders.
Key Responsibilities
  • Analyze business and system needs and translate requirements 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, perform analysis, confirm expected results, and validate business rules and system changes.
  • Analyze data structures, database relationships, data models, source-to-target mappings, and application logic to support reporting, integrations, batch processing, and system modernization initiatives.
  • Create and maintain requirements documents, functional specifications, process flows, data mappings, test scenarios, validation results, and implementation support documentation.
  • Collaborate with business users, developers, database administrators, quality assurance teams, architects, and project teams to clarify requirements, evaluate technical options, and support successful delivery of system changes.
  • Support application development and testing by reviewing program logic, validating outputs, creating test data, documenting defects, and assisting with programming or scripting tasks as needed.
  • Troubleshoot application and data issues and provide clear analysis of root causes, risks, impacts, and recommended remediation.
  • Support production implementations, implementation planning, post-deployment validation, and transition activities.
  • Contribute to application conversions, modernization efforts, and legacy-to-modern system initiatives.
  • Help design automated parity and comparison processes that reduce reliance on manual, report-by-report validation.
  • Support parallel-run and cut-over activities by analyzing results, identifying discrepancies, and helping technical and business teams resolve issues.
  • Communicate technical findings and recommendations clearly to both technical and non-technical audiences.
Required Qualifications
  • Bachelor's Degree from an accredited college or university in Computer Science, Information Systems, Business Information Systems, or a closely related field.
  • 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 experience as a systems analyst, including:
    • Requirements gathering and analysis
    • Functional and process analysis
    • Technical documentation
    • Stakeholder coordination
    • Testing and validation support
    • Implementation support
  • Direct Mainframe migration experience is required.
  • Strong COBOL/JCL/CICS/DB2 analysis skills.
  • Prefer candidates with hands-on COBOL experience.
  • Experience performing impact assessments, data comparisons, and parallel-run validation.
  • Familiarity with the latest AI tools.
  • Advanced SQL proficiency, including the ability to write, modify, debug, optimize, execute, and validate complex SQL queries and scripts for:
    • Data analysis
    • Reconciliation
    • Troubleshooting
    • Reporting
    • System validation
  • Experience analyzing relational databases, data models, database relationships, source-to-target mappings, stored procedures, data quality issues, and application or batch-processing logic.
  • Experience supporting application development, enhancement, conversion, or modernization initiatives.
  • Ability to work effectively with developers and other technical teams to clarify application logic, validate outputs, investigate issues, and support design decisions.
  • Strong analytical, troubleshooting, problem-solving, communication, facilitation, documentation, and attention-to-detail skills.
Preferred Qualifications
The following experience is desirable but not required:
  • Programming or scripting experience, including Java, Spring, or other modern programming technologies.
  • Experience with batch processing, report development, stored procedures, mainframe environments, or legacy technologies.
  • Experience developing automated data comparison, parity, or validation processes.
  • Experience supporting legacy technologies. 

Numbers & Facts

LocationPasadena, CA
Salary$70–$75 Per Hour

Skills

  • Analysis Skillsunmatched
  • Artificial Intelligence (AI)unmatched
  • Business Analysisunmatched
  • Business Solutionsunmatched
  • Cobol Programming Languageunmatched
  • Communication Skillsunmatched
  • Computer Scienceunmatched
  • Data Analysisunmatched
  • Data Modelingunmatched
  • Data Processingunmatched
  • Data Qualityunmatched
  • Data Structuresunmatched
  • Database Administrationunmatched
  • Database Analysisunmatched
  • Database Designunmatched
  • Debugging Skillsunmatched
  • Documentationunmatched
  • Functional Analysisunmatched
  • Functional Requirements Document (FRD)unmatched
  • IBM CICS (Customer Information Control System)unmatched
  • IBM DB2unmatched
  • Identify Issuesunmatched
  • Information Technology & Information Systemsunmatched
  • JCL (Job Control Language)unmatched
  • Javaunmatched
  • Mainframe Computerunmatched
  • Needs Assessmentunmatched
  • Operational Supportunmatched
  • Operations Processesunmatched
  • Options Analysisunmatched
  • Problem Solving Skillsunmatched
  • Process Analysisunmatched
  • Process Flowunmatched
  • Product Requirements Document (PRD)unmatched
  • Production Supportunmatched
  • Quality Assuranceunmatched
  • Query Optimizationunmatched
  • Reconciliationunmatched
  • Relational Databases (RDBMS)unmatched
  • Requirements Managementunmatched
  • Root Cause Analysisunmatched
  • SQL (Structured Query Language)unmatched
  • Sales/Support Engineering (SE)unmatched
  • Scripting (Scripting Languages)unmatched
  • Software Administrationunmatched
  • Software Developmentunmatched
  • Software Testingunmatched
  • Stored Proceduresunmatched
  • Support Documentationunmatched
  • System Validationunmatched
  • Systems Analysisunmatched
  • Systems/Internals Programmingunmatched
  • Technical Analysisunmatched
  • Technical Supportunmatched
  • Technical Writingunmatched
  • Test Dataunmatched
  • Test Plan/Scheduleunmatched
  • Test Scenariounmatched
  • Validation Testingunmatched
  • Writing Skillsunmatched

Be found by employers

5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

Level up your application

Professional resume templates

Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

Free resume templates

Free resume builder

Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

Free resume builder