Senior Programmer Analyst - MaineDOT Data Warehousing Team

State of Maine•Augusta, GA

12d•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. 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

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
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

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 analytical and transactional databases.
Database design, implementation, and support for 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.
Interacting frequently with both technical partners and business stakeholders.
Performing related requirements gathering, analysis, and documentation assignments.
Working at the highest technical level under limited supervision.

Benefits

13 paid holidays
12 days of sick leave
3+ weeks of vacation leave annually
Health Insurance Coverage (State pays 85%-100% of employee-only premiums)
Health Insurance Premium Credit (Participation decreases employee-only premiums by 5%)
Dental Insurance (State pays 100% of employee-only dental premiums)
Retirement Plan (State contributes 14.11% of pay to MainePERS)
Gym Membership Reimbursement (up to $40 per month)
Health and Dependent Care Flexible Spending Accounts
Public Service Student Loan Forgiveness eligibility
Living Resources Program (employee assistance program)
Parental leave (42 consecutive calendar days of fully paid leave for welcoming a child)
Voluntary Deferred Compensation (MaineSaves 457(b) account)