Programmer Analyst

If you are a current State of Maine employee, please submit your application through the internal application process using the Find Jobs report in PRISM. Seasonal employees who do not have PRISM access should apply through the State’s career page and indicate on the application that they have previously worked for the State.
.
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:
020001763
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 application-development lifecycle, including requirements, design, development, testing, deployment, documentation, and maintenance.
Familiarity with application testing, data validation, debugging, and production-support practices.
Ability to investigate technical problems and develop practical, supportable solutions.
Ability to prepare clear system, program, operational, and user documentation.
Ability to communicate technical information effectively to technical and nontechnical audiences.
Ability to listen to customers, clarify their needs, and explain technical constraints or options in understandable terms.
Ability to collaborate respectfully and productively with coworkers, customers, vendors, and government agency partners.
Ability to organize work, manage competing priorities, and complete assignments with an appropriate degree of independence.
Ability to provide timely progress updates and remain available and responsive during the assigned work schedule.
MINIMUM QUALIFICATIONS:
A Bachelors Degree in Computer Sciences or an equivalent industry certification -OR- an Associates Degree in Computer Information Science with 1 year application development experience -OR- 2 years application development experience.
Preference may be given to candidates with experience in one or more of the following areas:
Oracle Database development, particularly SQL and PL/SQL.
Enterprise data warehouse or ETL development and support.
Oracle SQL Developer or comparable development tools.
Oracle APEX application development or support.
Oracle Cloud Infrastructure or another enterprise cloud environment.
Shell scripting, Oracle SQL*Loader, or comparable data-loading tools.
Performance analysis and troubleshooting involving SQL, PL/SQL, ETL processes, or data warehouse workloads.
Supporting business-critical systems or working with public-sector customers.
APPLICATION INSTRUCTIONS:

Please submit a cover letter along with a current resume and three (3) professional references.
In order for us to properly determine if you meet the minimum qualifications for any posting, you must be sure your resume includes the month and year for any relevant experience listed. Your resume should include the duties and responsibilities associated with each position. Any experience that was not full-time employment should be identified as such.
CONTACT INFORMATION:
For more information or questions specific to the position, please contact
recruiting.ggsc@maine.gov
The selected candidate will be required to pass the required background checks (fingerprinting may be required) as a condition of employment.

BENEFITS OF WORKING FOR THE STATE OF MAINE: No matter where you work across Maine state government, you find employees who embody our state motto—"Dirigo" or "I lead"—as they provide essential services to Mainers every day. We believe in supporting our workforce's health and wellbeing with a valuable total compensation package, including: Work-Life Balance – Rest is essential. Take time for yourself using 13 paid holidays, 12 days of sick leave, and 3+ weeks of vacation leave annually. Vacation leave accrual increases with years of service, and overtime-exempt employees receive personal leave. Health Insurance Coverage – The State of Maine pays 85%-100% of employee-only premiums ($11,857.68-$13,950.24 annual value), depending on salary. Use this chart to find the premium costs for you and your family,