Application Systems Analyst / Programmer IV

Job Title : Application Systems Analyst / Programmer IV

Job ID :  82350

Location : Salem, Oregon (Hybrid / Remote eligible; onsite onboarding required)

Overview :

Our client seeks an experienced SQL Programmer to modernize and enhance the Health Analytics Library (HAL) — a Medicaid analytical and reporting SQL data mart. This role is critical in converting legacy SAS ETL processes to SQL and Python, preparing HAL for integration with the new AWS-hosted DSSURS data environment, and supporting future migration to Azure. You will work closely with data management, analytics, and program teams to design, develop, and implement updated ETL processes, improve data architecture, and enhance analytical capabilities for Medicaid claims and enrollment data.

What you will be doing :

System Analysis & Requirements Gathering

• Analyze HAL’s current architecture, ETL processes, data models, schemas, tables, and reporting environment.
• Collaborate with project managers, business analysts, DBAs, data analysts, and architects to identify business and technical requirements.
• Document detailed system, data, and integration requirements for enhancements.

ETL Development & Modernization

Testing, Implementation & Support

What you must have :

Nice to have :

Other Information : Work Environment

Thank you for your interest in this opportunity. If you are selected to move forward in the process, we will contact you directly. If you do not hear from us, we encourage you to continue visiting our website for other roles that may be a good fit.