Senior Programmer Analyst - MaineDOT Data Warehousing Team

State of Maine•Augusta, GA

5d•Hybrid

About The Position

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. The role analyzes, designs, develops, configures, implements, and maintains enterprise databases and data analytics systems, including MaineDOT’s Data Marts and centralized Data Warehouse. Database design, implementation, and support work may also extend to application development and geospatial teams as needed. The Senior Programmer Analyst serves as a senior technical lead on complex, data-intensive projects. Work may include designing, testing, implementing, deploying, and supporting Extract, Transform, and Load operations; developing subject areas for the Enterprise Data Warehouse and related Data Marts; and supporting analytical and transactional databases, including OLTP and OLAP systems. The position also handles ongoing operational and maintenance needs. The role involves frequent interaction with technical partners and business stakeholders, including requirements gathering, analysis, and documentation. Senior Programmer Analysts work at the highest technical level under limited supervision, mentor and train less experienced developers, and learn new processes and technologies as they are introduced. The position is hybrid, with an onsite location in Augusta, Maine; all work, including telework, must be performed within Maine. The position is not eligible for visa sponsorship or STEM OPT extensions.

Requirements

At least four years of computer programming experience using higher-level languages, including two years at the Programmer Analyst level or equivalent; alternatively, a Bachelor’s degree in Computer Science and two years at the Programmer Analyst level or equivalent.
A Master’s degree in Computer Science may substitute for one year of programming experience.
Knowledge of data system design techniques.
Knowledge of the 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 and coordinate project team activities and provide technical support.
Ability to work at the highest technical level under limited supervision.

Nice To Haves

Firm understanding of data warehousing fundamentals.
Experience designing, implementing, and supporting ETL/ELT.
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 communication and logical, structured thinking.
Demonstrable experience as both a technical leader and an individual contributor.

Responsibilities

Serve as a senior technical lead on complex, data-intensive projects.
Design, test, implement, deploy, and support Extract, Transform, and Load operations.
Design and implement new subject areas within the Enterprise Data Warehouse and related Data Marts.
Perform database design, implementation, and support for OLTP and OLAP systems and other analytical and transactional databases.
Support operational and maintenance needs for existing systems and processes.
Gather requirements, analyze needs, and document work in coordination with technical partners and business stakeholders.
Mentor and train less experienced developers in complex technical concepts.
Learn and apply new processes and technologies introduced to the team.
Diagnose and correct system malfunctions, adapt and enhance application software, and design, conduct, and evaluate system testing.
Lead and coordinate project team activities and provide technical support.

Benefits

13 paid holidays, 12 days of sick leave, and 3+ weeks of vacation leave annually; vacation accrual increases with years of service.
Personal leave for overtime-exempt employees.
State-paid 85%-100% of employee-only health insurance premiums, depending on salary.
A 5% health insurance premium credit for participation in the applicable program.
State-paid 100% of employee-only dental insurance premiums.
State contribution of 14.06% of pay to Maine Public Employees Retirement System (MainePERS).
Gym membership reimbursement of up to $40 per month.
Health and dependent care flexible spending accounts.
Eligibility for Public Service Student Loan Forgiveness.
Employee assistance through the Living Resources Program.
42 consecutive calendar days of fully paid parental leave for employees welcoming a child; additional unpaid leave may be available under the Family and Medical Leave Act.
Voluntary deferred compensation through a MaineSaves 457(b) account.
Eligible for a 5% training bonus.