> Markdown version of [/jobs/ext/2271804-systems-programmer-analyst](https://www.wearedevelopers.com/jobs/ext/2271804-systems-programmer-analyst). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Systems Programmer Analyst - **Company:** LEDGENT - **Location:** Pasadena, United States - **Experience:** Experienced - **Contract:** Permanent contract - **Skills:** Java (Programming Language), Data Analysis, Business Logic, Batch Processing, Information Systems, Computer Programming, Databases, Relational Databases, Database Development, Database Storage Structures, Software Debugging, Systems Analysis, Spring Framework, Mainframes, Software Engineering, Software Requirements Analysis, Verification and Validation (Software), SQL Stored Procedures, System Testing, Test Data, Freeform SQL, Sql Optimization, Information Technology, Legacy Systems - **Published:** August 27, 2026 - **Apply:** https://www.dice.com/job-detail/04e32616-2f64-4b8f-be10-0199e46bcd06 ## About the Role * Bachelor's degree from an accredited institution in Computer Science, Information Systems, Business Information Systems, or a related field. * Minimum of three (3) years of progressively responsible experience within an Information Technology organization performing systems analysis, requirements gathering, application support, data analysis, SQL development, application development, or related technical functions. * Strong experience as a Systems Analyst, including requirements elicitation, business process analysis, technical documentation, stakeholder management, testing coordination, and implementation support. * Advanced SQL skills with demonstrated experience writing, modifying, debugging, optimizing, and validating complex queries and scripts for troubleshooting, reporting, reconciliation, and system verification. * Experience working with relational databases, data models, stored procedures, source-to-target mappings, data quality analysis, and application or batch-processing logic. * Experience supporting application development, system enhancements, migrations, conversions, or modernization initiatives in partnership with development teams. * Strong analytical thinking, problem-solving, troubleshooting, communication, facilitation, documentation, and organizational skills with exceptional attention to detail. Preferred * Programming and scripting experience in technologies such as Java, Spring Framework, batch processing environments, report development tools, stored procedures, mainframe systems, or other legacy platforms. * Experience supporting legacy-to-modern platform migrations, including parallel testing, cutover planning, and system validation. * Experience designing and implementing automated validation, reconciliation, or parity-testing processes that reduce reliance on manual comparison efforts. * Experience working in complex enterprise environments with cross-functional teams and large-scale technology initiatives. ## Description We are 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, ensuring business needs are translated into effective system solutions while supporting application enhancements, troubleshooting efforts, modernization initiatives, and ongoing production support., * Analyze business processes, system requirements, and user needs, translating findings into detailed functional and technical specifications. * Perform comprehensive systems analysis across applications, databases, interfaces, batch processes, reports, and operational workflows to support enhancements, issue resolution, system conversions, and production support activities. * Develop, execute, validate, and optimize complex SQL queries and scripts to investigate data issues, perform reconciliations, verify business rules, and support system validation efforts. * Evaluate data models, database structures, source-to-target mappings, and application logic to support reporting, integrations, batch processing, and modernization projects. * Create and maintain technical and functional documentation, including business requirements, process flows, data mappings, test plans, test results, implementation guides, and support materials. * Collaborate with business users, software developers, database administrators, QA teams, architects, and project stakeholders to gather requirements, assess solutions, and ensure successful project delivery. * Support software development and testing efforts by validating business logic, reviewing program outputs, creating test scenarios and test data, documenting defects, and assisting with scripting or development activities as needed. * Participate in production support, deployment planning, post-implementation validation, and issue resolution while effectively communicating risks, findings, and recommendations. ## Related Videos - [Security Pitfalls for Software Engineers](https://www.wearedevelopers.com/videos/726-security-pitfalls-for-software-engineers) - [Dirty Tests And How To Clean Them](https://www.wearedevelopers.com/videos/515-dirty-tests-and-how-to-clean-them) - [Cloud as the new mainframe: why the cloud hype does not reflect the dev reality](https://www.wearedevelopers.com/videos/797-cloud-as-the-new-mainframe-why-the-cloud-hype-does-not-reflect-the-dev-reality) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [Grappling With Clunky Old Software? Start by Understanding What’s Inside!](https://www.wearedevelopers.com/videos/1189-grappling-with-clunky-old-software-start-by-understanding-what-s-inside) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) ## Related Articles - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again) - [What’s the Difference between a Junior, Mid, and Senior Developer?](https://www.wearedevelopers.com/magazine/238-what-s-the-difference-between-a-junior-mid-and-senior-developer) - [What is Software Engineering?](https://www.wearedevelopers.com/magazine/289-what-is-software-engineering) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [7 Important Tips That Every Software Developer Should Know](https://www.wearedevelopers.com/magazine/101-7-important-tips-that-every-software-developer-should-know) - [Is Software Engineering Over-Saturated?](https://www.wearedevelopers.com/magazine/418-is-software-engineering-over-saturated)