Senior Programmer Analyst

State of Maine•Augusta, ME

2d•$71,994 - $101,162•Hybrid

About The Position

The Department of Administrative and Financial Services (DAFS) Office of Information Technology (OIT), also known as MaineIT, provides information technology support to over 13,000 employees. MaineIT 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 qualified and skilled individual who is self-motivated to be a part of a highly technical team supporting MaineDOT and who will represent our C.A.R.E. values in all 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. The Maine Office of Information Technology (OIT) is seeking a Senior Programmer Analyst to support the Maine Department of Transportation (MaineDOT) Database and Data Warehousing Team. This position is responsible for the analysis, design, development, configuration, implementation, and maintenance of enterprise databases and data analytics systems, including MaineDOT’s Data Marts and centralized Data Warehouse. Potential candidates should be confident in their database and data warehousing skillsets, as a large portion of assignments will require these skillsets. Database design, implementation, and support responsibilities might also extend to work for our application development and geospatial teams as needed.

Requirements

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.
Knowledge of data system design techniques
Knowledge of Systems Development Life Cycle (SDLC) and documentation standards.
Knowledge of structured systems methodologies
Knowledge of higher-level programming languages and enterprise class application development tools
Ability to diagnose and correct system malfunctions
Ability to adapt and enhance application software
Ability to design, conduct, and evaluate system testing
Ability to lead, coordinate the activities of, and provide technical support to project teams

Nice To Haves

Firm understanding of Data Warehousing fundamentals
ETL/ELT design, implementation, and support experience
Practical database design experience
Experience with Dimensional Modeling and Star Schema design
Experience working with Oracle databases and/or Data Analytics offerings
Ability to gather requirements directly from stakeholders and subject matter experts
Significant experience with PL/SQL
Python experience
JIRA experience
GitHub experience
Effective communicator and logical/structured thinker
Demonstrable experience of being a true technical leader as well as an individual contributor

Responsibilities

Serve as a senior Technical Lead on complex data-intensive projects.
Designing, testing, implementing, deploying, and supporting Extract, Transform, and Load operations.
Designing and implementing new subject areas within our Enterprise Data Warehouse and/or related Data Marts.
Performing a variety of other data-related assignments in support of both our analytical and transactional databases.
Database design, implementation, and support for both Online Transactional Processing systems (OLTP) as well as Online Analytical Processing systems (OLAP).
Mentoring and training less experienced developers in complex technical concepts.
Performing operational and maintenance needs for existing systems and processes.
Frequent interaction with both technical partners, as well as business stakeholders.
Related requirements gathering, analysis, and documentation assignments.

Benefits

13 paid holidays
12 days of sick leave
3+ weeks of vacation leave annually
Health Insurance Coverage – The State of Maine pays 85%-100% of employee-only premiums
Health Insurance Premium Credit – Participation decreases employee-only premiums by 5%
Dental Insurance – The State of Maine pays 100% of employee-only dental premiums
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 – up to $40 per month
Health and Dependent Care Flexible Spending Accounts
Public Service Student Loan Forgiveness
Living Resources Program – employee assistance program
Parental leave – forty-two (42) consecutive calendar days of fully paid parental leave for employees welcoming a child (including fathers and adoptive parents).
Voluntary Deferred Compensation – MaineSaves 457(b) account