> Markdown version of [/jobs/ext/1499890-senior-programmer-analyst-mainedot-data-warehousing-team](https://www.wearedevelopers.com/jobs/ext/1499890-senior-programmer-analyst-mainedot-data-warehousing-team). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Senior Programmer Analyst - MaineDOT Data Warehousing Team - **Company:** State of Maine - **Location:** Augusta, GA, United States (Remote available) - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Artificial Intelligence, Software Applications, JIRA, Software Documentation, Computer Programming, Databases, Extract Transform Load (ETL), Data Mart, Data Structures, Data Systems, Data Warehousing, Database Design, Programming Tools, Dimensional Modeling, Github, Python (Programming Language), Online Analytical Processing, Online Transaction Processing, Systems Development Life Cycle, Software Engineering, PL-SQL, System Testing, Information Technology, Data Analytics, Star Schema - **Published:** July 30, 2026 - **Apply:** https://www.jofdav.com/jobs/59036745-senior-programmer-analyst-mainedot-data-warehousing-team ## About the Role 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!!, * Knowledge of data system design techniques * Knowledge of Systems Development Life Cycle (SDLC) and documentation standards. * Knowledge of structured systems methodologies * Knowledge ofhigher-levelprogramming 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. Preference will be given to candidates with the following skills or experience: * 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 * Demonstratable experience of being a true technical leader as well as an individual contributor ## Description 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., 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., * 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 areas within our Enterprise Data Warehouse and/or related Data Marts. It will also include a great variety of other data-related assignments in support of both our analytical and transactional databases. * Assignments related to database design, implementation, and support will be common. This will include both Online Transactional Processing systems (OLTP) as well as Online Analytical Processing systems (OLAP). * Senior Programmer Analysts are expected to be able to mentor and train less experienced developers in complex technical concepts when the need arises and are expected to be good students when new processes and/or technologies are introduced to the team. * Our existing systems and processes also include a fair amount of operational and maintenance needs, and that will be part of the ongoing responsibilities as well. * Assignments often require frequent interaction with both technical partners, as well as business stakeholders. Related requirements gathering, analysis, and documentation assignments are common and should be expected. Employees in this classification are competent to work at the highest technical level under limited supervision. ## Related Videos - [Innovating Developer Tools with AI: Insights from GitHub Next](https://www.wearedevelopers.com/videos/1268-innovating-developer-tools-with-ai-insights-from-github-next) - [Improving quality with Agentic AI with Rovo Dev and Xray](https://www.wearedevelopers.com/videos/2005-improving-quality-with-agentic-ai-with-rovo-dev-and-xray) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Bringing AI Model Testing and Prompt Management to Your Codebase with GitHub Models](https://www.wearedevelopers.com/videos/1536-bringing-ai-model-testing-and-prompt-management-to-your-codebase-with-github-models) - [Collaboration Quantified: Lessons from Open Source Developer Networks](https://www.wearedevelopers.com/videos/1422-collaboration-quantified-lessons-from-open-source-developer-networks) - [Grappling With Clunky Old Software? Start by Understanding What’s Inside!](https://www.wearedevelopers.com/videos/1189-grappling-with-clunky-old-software-start-by-understanding-what-s-inside) ## Related Articles - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Résumé-Driven Development: How IT trends affect the job market for software developers](https://www.wearedevelopers.com/magazine/59-resume-driven-development-how-it-trends-affect-the-job-market-for-software-developers) - [Dev Digest 121 - AI goes offline](https://www.wearedevelopers.com/magazine/456-dev-digest-121-ai-goes-offline) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)