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: 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.

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.

CONTACT INFORMATION:

For more information or questions specific to the position, please contact View email address on click.appcast.io 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.24annual value), depending on salary. Use this chart to find thepremium costs ( 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 leave is one of the most important benefits for any working parent. All employees who are welcoming a child—including fathers and adoptive parents—receive forty-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. There's a job and then there's 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 you’re looking for a great next step, and want to feel good about what you do, we’d 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 you’re 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. #J-18808-Ljbffr State of Maine