What are the responsibilities and job description for the Programmer Analyst position at Intelli ERP Software, LLC?
Job Title | Programmer Analyst |
Urgent | Yes- |
Location | Jackson, MS |
| Onsite required |
Immigration | USC/H1B |
Hours | 40 Hours per week-Only |
Project Start | 04/27/2026 or TBD by Client |
Duration | 18 Months |
Work Schedule | M to F-8:00 AM to 5:00 PM CST |
Salary/Rate- | Prefer W-2, 1099, C2C |
Last 5 Digit -SSN-Req.- |
|
On-Call Required |
|
Travel | Not Required |
Client | Direct |
Criminal Background Check/ Drug Screen Requirement | Standard Background Check |
DESCRIPTION:
We are seeking a skilled Programmer Analyst with strong experience in enterprise software development, SQL/Oracle programming, and cloud-based modernization initiatives. The ideal candidate will review, refactor, and migrate legacy application logic including PL/SQL code, stored procedures, and Crystal Reports into a modern AWS-based architecture. This role involves understanding existing business logic, documenting current workflows, and collaborating with both internal teams and a third-party vendor. They will support the redesign of core application functionality, including modules such as records, classification and sentence computation, to ensure accurate operation within the updated system.
Key Responsibilities
· Review and document existing application architecture, data models, workflows, and stored procedures.
· Rewrite and optimize Oracle PL/SQL packages, functions, triggers, and views for migration to a cloud environment.
· Migrate legacy Crystal Reports to a modern reporting platform compatible with AWS.
· Extract, map, validate, and transform data to support ETL and database conversion activities.
· Analyze, document, and refactor core logic modules such as sentence computation.
· Convert legacy DHTML-based UI forms to modern formats as part of system redesign.
· Understand and document scheduled jobs and backend automation processes.
· Collaborate with a third-party vendor to clarify requirements and support modernization efforts.
Required Technical Skills
· Expert knowledge of Oracle PL/SQL (procedures, functions, triggers, packages, views).
· Strong SQL expertise including query optimization and performance tuning.
· Experience with data migration, ETL workflows, and schema transformation.
· Ability to understand logic from legacy applications and undocumented code.
· Familiarity with legacy front-end technologies (DHTML, HTML/JavaScript forms).
· Experience with task schedulers for data automation.
Preferred Qualifications
· Experience with AWS database and reporting services.
· Knowledge of BI/reporting tools such as Power BI or AWS QuickSight.
· Scripting experience (Python, PowerShell).
· Experience with Offender Management or enterprise justice systems.
· Experience working with external vendor teams on modernization projects.