Programmer Analyst

State of Maine

Augusta, Maine

JOB DETAILS
SALARY
$57,775.17–$81,065.71 Per Month
SKILLS
Accounts Receivable, Administrative Skills, Analysis Skills, Automation, Business Analysis, Business Solutions, Communication Skills, Computer Maintenance, Computer Programming, Computer Science, Computer-Based Training (CBT), Customer Relations, Data Warehousing, Database Architecture, Database Design, Database Extract Transform and Load (ETL), Database Optimization, Debugging Skills, Dimensional Modeling, Documentation, Enterprise Applications, Financial Services, Identify Issues, Information Technology & Information Systems, Oracle, Oracle Database, Oracle PL-SQL, PL-SQL Developer Tools, Performance Tuning/Optimization, Presentation/Verbal Skills, Programming Languages, Project Lifecycle, Quality Assurance Methodology, Requirements Management, SQL (Structured Query Language), SQL Databases, Software Development, Software Testing, Source Code/Configuration Management (SCM), Star Schema, State Government, Structured Programming Methodologies, Support Documentation, Systems Analysis, Systems Maintenance, Team Player, Technical Support, Test Plan/Schedule, Testing, Time Management, Training Program
LOCATION
Augusta, Maine
POSTED
9 days ago
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: 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: 020001763

Location: Augusta

Telework: Available

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

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

MaineIT is seeking a highly talented individual who will represent our C.A.R.E. values in all that they do. At MaineIT we:
  • 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.

ABOUT THE JOB:
As a Programmer Analyst, you'll work with a team of developers with various degrees of experience, supporting the development and maintenance of computer programs and data warehouses. You'll interact with Enterprise Data Services customers daily as you complete various tasks. Assignments can vary between multiple applications and projects.

REPRESENTATIVE TASKS:
  • Evaluates 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
  • Writes final user, system, and program documentation in order to facilitate system use and future modifications.
  • Maintains existing systems and responds to problems in order to ensure programs remain effective.
  • Leads or participates in walk-throughs of system and program designs, coding, and testing in order to minimize occurrence of program problems.
  • Attends and participates in vendor, agency, and computer-based training programs in order to develop technical skills and expand knowledge of automation technology products and capabilities.

KNOWLEDGE, SKILLS AND ABILITIES:
  • 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. Knowledge of 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.

MINIMUM QUALIFICATIONS:

A Bachelors Degree in Computer Sciences or an equivalen

About the Company

S

State of Maine