Senior Programmer Analyst

State of Maine•Augusta, ME

23h•Hybrid

About The Position

The Maine Office of Information Technology’s Enterprise Data Services team is seeking a Senior Programmer Analyst to help develop and support multiple data warehouses and analytics services along with integrations between systems and support applications for Maine Office of Information Technology. The selected individual will work in a team to support the logistical needs of the Enterprise Shared Services (ESS) directors in delivering IT services to state agencies. This position offers the opportunity to be involved in improving operations, making data pertinent to ESS operations available in the data warehouse and other miscellaneous activities. The primary skillset is development of applications using Oracle Apex and SQL. TELEWORK OPPORTUNITY: This is a full-time telework position with restrictions. The employee must come into the office in Augusta, Maine once every two weeks and must live in the state of Maine.

Requirements

Demonstrated ability to define and resolve complex technical problems independently.
The ability to effectively communicate orally and in writing to both technical and non-technical audiences.
Excellent organizational and time-management skills.
Friendly and collaborative interpersonal skills.
Experience working with Jira and Confluence.
Experience with custom application design and development.
Experience with relational database modeling and process flow diagrams.
Experience developing abstract/sharable code and components for reusability and a shared code base.
Experience with Oracle Database developing and supporting software applications.
Extensive experience with Oracle PL/SQL. Including triggers, packages, procedures, functions and scheduled jobs.
Experience with Oracle APEX or exposure to Oracle APEX and a willingness to learn quickly.
Experience with basic web technologies (HTML5, CSS3, JavaScript, AJAX, JQuery).
Experience with version control (GitHub).
Willingness to learn new technology and use new tools as needs change.
Four (4) years of computer programming experience utilizing higher level languages including two (2) years at the Programmer Analyst level or equivalent -OR- a Bachelors Degree in Computer Sciences including two (2) years at the Programmer Analyst level or equivalent. A Masters Degree in Computer Science may be substituted for one (1) year of programming experience.

Nice To Haves

Experience with Oracle and Oracle APEX Cloud implementations a plus.

Responsibilities

Design, develop, test, and maintain application code.
Partner with technical staff and end-users to test and refine your work.
Work under limited supervision.
Supervise, coach and train junior programmers.
Comply with State of Maine standards for production, quality, and productivity.
Train system end users, serve as an information resource, develop resource materials, and provide ongoing support.
Respond to customer support escalations.
Write documentation for system references.

Benefits

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, 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 about program 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.11% 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 the Federal 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 the Family 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.