Programmer Analyst

Office of Information Technology

Opening Date:
October 08, 2026

Closing Date:
October 23, 2026

Grade / Admin Unit: 23 / Professional/Technical

Job Class Code: 0865
Salary: $60,384.69 - $84,723.91*/Annually (
* includes 17.25% recruitment and retention stipend, and eligible for a 5% training bonus)
Position Number:

Location:

Augusta

Telework:
Available

Currently, this position is not eligible for visa sponsorship or STEM OPT extensions.

DESCRIPTION:

This is technical services work involving the development and maintenance of computer programs. Responsibilities include designing, developing, and maintaining application programs. This classification may be transitional in nature as assignments and skill building can be directed toward either more complex programming or systems analysis activities. Supervision may be exercised over computer programmers for specific assignments. Work may involve frequent communications with users.

Programmer Analysts are typically located within an agency's data processing unit and assigned to multiple application development and support teams on a project-by-project basis. This classification does not encompass non-information services personnel in highly technical, specialized fields such as engineering, medical or physical sciences, accounting, etc. whose duties require them to utilize and/or customize standardized application products unique to their area of specialization, nor other professional staff who develop applications for their own use or in support of a small work unit utilizing off the shelf, desktop products such as spreadsheets and PC-based databases.

This differs from that of Computer Programmer in that Programmer Analysts are increasingly responsible for developing program specifications, analyzing and designing small systems or sub-systems, and performing programming work of greater breadth and complexity. Work is performed under limited supervision.

MaineIT embraces the following core values (C.A.R.E.):

• Customer-Focus – Ensuring our customers are heard and their needs are met.
• Accountability – Holding ourselves to a high standard through transparency with stakeholders.
• Responsiveness – Providing timely updates in a proactive manner.
• Empathy – Delivering people-focused services with emotional intelligence.

REPRESENTATIVE RESPONSIBILITIES:

• Develop, enhance, test, debug, and maintain data warehouse programs, database code, and data-integration processes.
• Write and maintain Oracle SQL and PL/SQL, including packages, procedures, functions, queries, and scripts.
• Support and enhance Oracle APEX applications.
• Develop and maintain ETL processes that load staging, warehouse, and reporting structures.
• Maintain data warehouse solutions using the team’s established architecture, standards, and development practices.
• Support data-loading processes that use shell scripts, Oracle SQL
  * Loader, and related utilities.
• Analyze existing applications and code, recommend improvements, and help migrate functionality to supported technologies.
• Investigate production incidents, identify root causes, correct defects, and communicate status clearly to customers and team members.
• Monitor and validate data loads, reconcile results, and address data-quality issues.
• Translate business needs into clear technical requirements and workable solutions.
• Develop and perform appropriate unit, integration, system, and data-validation testing.
• Create and maintain system, program, operational, and user documentation.
• Participate in reviews of system designs, code, test plans, and deployment activities.
• Assist users in understanding application features, warehouse data, and reporting capabilities.
• Manage assigned work independently while coordinating with the team and raising risks or blockers promptly.
• Participate in relevant agency, vendor, and technical training to expand professional and technical knowledge.

KNOWLEDGE, SKILLS, AND ABILITIES:

The successful candidate will demonstrate:

• Knowledge of SQL, structured programming, and database or data warehouse development.
• Ability to analyze data, programs, and business processes and translate findings into effective technical solutions.
• Familiarity with the…