Systems Programmer & SQL Data Analyst

Ledgent Technology; Pasadena (CA); On-site; USD 96,000 - 103,000; Full time

Job summary

Ledgent Technology is seeking a Systems Programmer Analyst to support business-critical applications through systems analysis, data analysis, requirements gathering, and technical documentation.

This role will serve as a key liaison between business stakeholders and technical teams in Pasadena, ensuring business needs are translated into effective system solutions while supporting modernization initiatives and production support.

Qualifications

• Bachelor's degree in CS/IS or related field.
• 3+ years of systems analysis and SQL development experience.
• Strong systems analyst skills including requirements elicitation and testing coordination.
• Advanced SQL skills for complex queries and validation.

Responsibilities

• Analyze business processes, system requirements, and user needs into detailed specs.
• Perform comprehensive systems analysis across applications, databases, interfaces, batch processes, reports, and workflows.
• Develop, execute, validate, and optimize complex SQL queries and scripts for data issues and validation.
• Evaluate data models, mappings, and application logic to support reporting and modernization projects.
• Create and maintain technical and functional documentation: requirements, data mappings, test plans.

Skills

Analytical thinking

Problem solving

Communication

Documentation

Requirements elicitation

Stakeholder management

Education

Bachelor's degree in CS/IS

Tools

SQL development

Java

Spring Framework

Batch processing

Stored procedures

Mainframe

Job description

Ledgent Technology is seeking a Systems Programmer Analyst to support business-critical applications through systems analysis, data analysis, requirements gathering, and technical documentation.

This role will serve as a key liaison between business stakeholders and technical teams in Pasadena, ensuring business needs are translated into effective system solutions while supporting modernization initiatives and production support.