Senior Programmer Analyst - MaineDOT Data Warehousing Team

maine; Augusta (ME); Hybrid; USD 75,000 - 106,000; Full time

Job summary

Maine Office of Information Technology (MaineIT) in Augusta, ME, seeks a senior Programmer Analyst to support the MaineDOT data warehousing team. You will analyze, design, develop, configure, implement, and maintain enterprise databases and analytics systems, including data marts and centralized data warehouse.

Ideal candidates are confident in database design and data warehousing, with the ability to work independently or with a team on multifaceted initiatives, including future AI discussions

Responsibilities

• Serve as senior Technical Lead on complex data-intensive projects.
• Design, test, implement, deploy, and support ETL operations.
• Collaborate with data/DB teams on data warehouses and data marts.
• Contribute to cloud migration efforts for databases and services.
• Explore future AI opportunities and applying them to data solutions.

Job description

.

Office of Information Technology

Opening Date: October 20, 2026

Closing Date: November 3, 2026

Grade / Admin Unit: 27 / Professional/Technical

Job Class Code: 0866

Salary: $75,234.74 - $105,714.46*/Annually (*includes a 23.66% recruitment and retention stipend, and eligible for a 5% training bonus)

Position Number: 200024881

Location: Augusta

Hybrid Work Location: This position is a hybrid telework/onsite position. The onsite location is in Augusta, Maine. All work, including telework, must be completed within the borders of the State of Maine.

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

You are a talented senior-level IT professional who is driven toward success. You enjoy exploring data, designing and implementing complex data structures and processes, and transforming data into knowledge. You can work independently but can also work collaboratively as part of a larger unit on multifaceted initiatives. If this describes you, we want you on our TEAM!!

OVERVIEW:

The Department of Administrative and Financial Services (DAFS) Office of Information Technology (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 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.

JOB DESCRIPTION:

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.

WHAT IS IN IT FOR YOU?

The MaineDOT strives to support economic opportunity and quality of life by responsibly providing their customers the safest and most reliable transportation system possible, given available resources. We can feel good about helping to support them in that mission.

You will be developing data solutions that inform business decisions being made at the very highest levels of MaineDOT management.

There will be opportunities to help shape the future direction of the DB/DW team as we look towards modernizing existing processes and blaze paths towards newly emerging data domains.

You could add your individual style to our evolving team culture. Collaboration is key. Fresh ideas and perspectives are most welcome.

Do you like being surrounded by smart people? Then our division is a good place to find yourself. You will be interacting with lots of talented IT professionals and lots of very experienced business partners daily. This includes many MaineDOT engineers and specialists who are subject matter experts in the areas in which they serve.

There will be endless opportunities to ask questions, learn, share, and teach.

You will help us define what our new cloud-based reality looks like as we continue to migrate more-and-more databases, applications, and services to the cloud.

There will be many of opportunities to discuss what the "future of AI" means to us, and how we can best leverage all its potential.

Things tend to evolve quickly within our team and within our division. This helps to keep boredom at bay and provides tremendous opportunities for those who like to contribute their experience and ideas towards our shared organizational goals.

WHAT WILL YOU DO?

As Senior Programmer Analyst within the Database and Data Warehousing Team, you will be expected to serve as a senior Technical Lead on complex data-intensive projects. This might often include designing, testing, implementing, deploying, and supporting Extract, Transform, and Load operations. At times it will involve designing and implementing new subject