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: $60384.69 - $84723.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 agencys 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 teams 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.

MINIMUMQUALIFICATIONS:

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:

Pleasesubmita cover letter along with a current resumeand three (3) professional references.

In order forus to properlydetermineif 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

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 mottoDirigo or I leadas they provide essential services to Mainers every day. We believe in supporting our workforces health and wellbeing with a valuable total compensation package including:

• Work-Life Balance Rest is essential. Take time for yourself using13 paid holidays 12 days of sick leaveand3 weeks of vacation leaveannually. Vacation leave accrual increases with years of service and overtime-exempt employees receive personal leave.
• Health Insurance Coverage The State of Maine pays85%-100%of employee-only premiums($11857.68-$13950.24annual value) depending on salary. Use this chart to find thepremium costsfor you and your family including the percentage of dependent coverage paid by the State.
• Health Insurance Premium Credit Participation decreases employee-only premiums by 5%. Visit the Office of Employee Health and Wellness for more information aboutprogram requirements.
• Dental Insurance The State of Maine pays 100% of employee-only dental premiums ($365.28 annual value).
• Retirement Plan The State of Maine contributes 14.06% of pay to the Maine Public Employees Retirement System (MainePERS) on behalf of the employee.
• Gym Membership Reimbursement Improve overall health with regular exercise and receive up to $40 per month to offset this expense.
• Health and Dependent Care Flexible Spending Accounts Set aside money pre-tax to help pay for out-of-pocket health care expenses and/or daycare expenses.
• Public Service Student Loan Forgiveness The State of Maine is a qualified employer for this federal program. For more information visit theFederal Student Aid office.
• Living Resources Program Navigate challenging work and life situations with our employee assistance program.
• Parental leaveis one of the most important benefits for any working parent. All employees who are welcoming a childincluding fathers and adoptive parentsreceiveforty-two (42) consecutive calendar days of fully paid parental leave. Additional unpaid leave may also be available under theFamily and Medical Leave Act.
• Voluntary Deferred Compensation Save additional pre-tax funds for retirement in a MaineSaves 457(b) account through payroll deductions.

State employees are eligible for an extensive and highly competitive benefits package covering many aspects of wellness. Learn about additional wellness benefits for State employees from the Office of Employee Health and Wellness.

Note: Benefits may vary somewhat according to specific collective bargaining agreements and are prorated for anything less than full-time.

Theres a job and then theres purposeful transformative work. Our aim is to create a workplace where you can learn grow and continuously refine your skills. Applicants demonstrate job requirements in differing ways and we appreciate that many skills and backgrounds can make people successful in this role.

As an Equal Opportunity employer Maine State Government embraces a culture of respect and awareness. We are committed to creating a strong sense of belonging for all team members and our process ensures an inclusive environment to applicants of all backgrounds including diverse race color sex sexual orientation or gender identity physical or mental disability religion age ancestry national origin familial status or genetics.

If youre looking for a great next step and want to feel good about what you do wed love to hear from you. Please note reasonable accommodations are provided to qualified individuals with disabilities upon request.

Thinking about applying

Research shows that people from historically excluded communities tend to apply to jobs only when they check every box in the posting. If youre currently reading this and hesitating to apply for that reason we encourage you to go for it! Let us know how your experience and passion set you apart.

If you require a paper application please download and print one HERE

.

If you are unable to complete the online application please contact the Human Resources representative listed on the job opening you are interested in applying for. They will work with you for an alternative method of submitting.