RPG/AS400 Analyst

Position: RPG/AS400 Analyst

Duration: 6 months

Location: Bismark, ND (Preferably Hybrid, are open to remote)

Summary:
The Application Systems Analyst / Programmer will analyze and enhance data exports from an IBM AS400 (iSeries) system to support operational needs. This role requires strong AS400 expertise, data analysis skills, and the ability to develop new export processes if existing files are insufficient.

Years of Experience: Minimum of three (3) years of experience

Top Skills & Years of Experience:

• At least 2 years hands on experience successfully analyzing AS400 files and code and the ability to produce a relational export file from the AS400 database.
• Hands-on experience with IBM AS400 (iSeries) systems and data export processes.
• Proficiency in RPG, SQL, CL, and other AS400 programming languages
• Strong understanding of flat file structures and data transformation

Nice to Have:

• Consulting or operational support experience with the AS400

Required Skills

• 2+ years of experience successfully analyzing IBM AS400(iSeries) files and data export processes
• Proficiency in RPG, SQL, CL, and other AS400 programming languages
• Proficient in handling and converting flat-file data formats (e.g., delimited or fixed-width) and applying data transformation techniques to produce accurate outputs for operational and reporting needs.
• Proven experience working in cross-functional project teams with strong communication, problem-solving, and accurate documentation skills of technical deliverables.

Preferred Skills

• Prior consulting or operational support experience on IBM i (AS/400), including stakeholder engagement, job monitoring/troubleshooting, and process/documentation improvements.

Required Skills:

• Hands-on experience with IBM AS400 (iSeries) systems and data export processes.
• Proficiency in RPG, SQL, CL, and other AS400 programming languages (required).
• Strong understanding of flat file structures and data transformation.
• Ability to troubleshoot and optimize data workflows.
• Excellent communication and documentation skills.

Responsibilities:

• Review and analyze flat files exported from AS400 systems for usability in operational workflows.
• Identify gaps or issues in current export structure and recommend solutions.
• Design and develop replacement export files if necessary, ensuring compatibility with downstream systems.
• Collaborate with business stakeholders to understand operational requirements and data needs.
• Perform testing and validation of new or modified export processes.
• Document technical specifications and procedures for future reference.
• Compliance with any related state IT standards and requirements.
• Participate in project work, as directed by the program manager, and as assigned by the project management team, the approved project plans, and the approved project schedules.