Hybrid Systems Programmer Analyst — SQL & Mainframe

Milestone Technologies, Inc.

Pasadena (CA)

Hybrid

USD 90,000 - 103,000

Full time

2 days ago

Be an early applicant

Application generator

Turn this role into an interview — a resume and cover letter built around what this employer wants.

Get past ATS filters

Benefits offered by this job

Comprehensive benefits

Job summary

Milestone Technologies, Inc. is seeking a Systems Programmer Analyst in Pasadena, CA for hybrid work (onsite 1–2x per week).

The role focuses on analyzing business and system needs, documenting requirements, and translating them into clear functional and technical specifications. You will perform systems analysis, develop and validate complex SQL queries, and support modernization efforts across applications, databases, and batch processes.

Qualifications

Bachelor's degree in CS/IS/Business Information Systems or related field.
At least three years of progressive full-time IT experience in systems analysis, requirements, or data analysis.
Strong COBOL/JCL/CICS/DB2 analysis skills and hands-on coding preferred.
Advanced SQL proficiency for data research, validation, and reporting.
Experience with mainframe migrations and production support is a plus.

Responsibilities

Analyze systems across applications, databases, batch jobs, interfaces, reports and operations.
Develop, validate, and optimize complex SQL queries and scripts.
Analyze data structures, mappings, and logic to support reporting and modernization.
Create and maintain requirements documents, specifications, data mappings, and test materials.
Collaborate with users, developers, DBAs, QA, architects, and project teams.
Support development and testing activities, review logic, and document defects.
Assist with production support, deployment planning, and post-deployment validation.