Programmer Analyst

Office of Information Technology
Opening Date:
June 29, 2026
Closing Date:
July 14, 2026
Grade / Admin Unit: 23 / Professional/Technical
Job Class Code: 0865
Salary: $57,775.17 - $81,065.71 annually (includes 17.25% recruitment and retention stipend, and eligible for a 5% training bonus)
Position Number:

Location:

Augusta
Telework:
Available

The Department of Administrative and Financial Services (DAFS) Office of Information Technology (OIT) provides information technology support to over 13,000 employees. OIT oversees large‑scale enterprise applications that support the critical and diverse business needs of the State of Maine and its agencies.

• Practice Customer‑focus, ensuring that our customers are heard, and their needs are met.
• Hold ourselves to a high level of Accountability by being transparent with our stakeholders.
• Maintain an effective level of Responsiveness by providing timely updates in a proactive manner.
• Strive to provide Empathy‑driven, people‑focused services by applying emotional intelligence skills and behaviors.

As a Programmer Analyst, you will work with a team of developers of varying experience, supporting the development and maintenance of computer programs and data warehouses. You will interact with Enterprise Data Services customers daily as you complete various tasks, with assignments that can vary between multiple applications and projects.

• Evaluate existing code and migrate current functionality into new technology.
• Test and debug programs to ensure proper functionality.
• Educate users on the use of programs and program features.
• Create documentation in support of enhancements and reported issues.
• Write final user, system, and program documentation to facilitate system use and future modifications.
• Maintain existing systems and respond to problems to ensure programs remain effective.
• Lead or participate in walk‑throughs of system and program designs, coding, and testing to minimize occurrence of program problems.
• Attend and participate in vendor, agency, and computer‑based training programs to develop technical skills and expand knowledge of automation technology products and capabilities.

• Knowledge of high‑level programming languages and enterprise‑class application development tools such as PL/SQL, SQL Developer, and Oracle APEX.
• Knowledge of program documentation procedures and structured programming.
• Knowledge of all phases of the project development cycle.
• Knowledge of systems analysis and design techniques.
• Knowledge of state government or business application areas.
• Ability to work effectively as a member of a team.
• Ability to communicate effectively via verbal or written communication methods.
• Familiarity with application testing techniques and processes.
• Knowledge of Oracle Cloud Infrastructure (OCI) services and cloud‑based application deployment concepts.
• Knowledge of Oracle Database architecture, SQL performance tuning, and database optimization techniques.
• Knowledge of data warehousing methodologies, including Kimball dimensional modeling, star schema design, and ETL/ELT processes.
• Skill in developing, testing, debugging, and maintaining Oracle PL/SQL code and database objects.
• Skill in analyzing business requirements and translating them into technical solutions.
• Familiarity with source code management and software release processes.
• Ability to troubleshoot and resolve complex application and database issues.

A Bachelor's Degree in Computer Sciences or an equivalent industry certification, or an Associate's Degree in Computer Information Science with 1 year application development experience, or 2 years application development experience.

• Work‑Life Balance: 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 the chart to find the premium costs for you and your family.
• Health Insurance…