Top 11 Data warehousing architects Jobs in Maine

Senior Programmer Analyst - MaineDOT Data Warehousing Team
State of Maine —Augusta, ME
- $71,993.86 - $101,161.81 a year
- Online Application
- Hybrid work
- Computer Science
- Office
- Master's degree
- Paid parental leave
- Paid holidays
1d
Data Architect
CEDENT —Maine
- Contract
- 5 years
- Research
- Mentoring
Director, Data Science Operations
Kemper Insurance —Augusta, ME
- $160,555 - $226,500 a year
- Email
- Remote
- Computer Science
- Java
- SQL
- Health insurance
- Dental insurance
Quick Apply
13d
Enterprise Information Architect I
L. L. Bean —Freeport, ME
- Full-time
- Office
- 8 years
- SQL
2d
Data Architect
RitePros —Portland, ME
- Azure
- Computer Science
- 5 years
M-78-Data Architect 144227.
FHR —Bangor, ME
- Contract
- Hybrid work
- 5 years
- Mentoring
- Senior level
Quick Apply
Database Architect
RitePros —Portland, ME
- Azure
- 5 years
- Engineering
Solution Architect
RitePros —Portland, ME
- Azure
- Management
- Computer Science

More jobs to discover

Find similar jobs that you might be interested in.

Data Migration Specialist
CM Almy —Pittsfield, ME
The ideal candidate will have experience leading or implementing complex ecommerce migrations and will be comfortable working across both technical data…
$70,000 - $90,000 a year
Quick Apply
Data Architect
CEDENT —Maine
Experience with utilizing API calls for automated data refreshes. Demonstrates previous success in independently researching technical options to find suitable…

Show more similar jobs

Explore jobs in cities nearby

Check out jobs in cities near your current location, Columbus

Enterprise Data Modeler Databricks
Proteam Solutions —Dublin, OH
Experience with ERwin, ER/Studio, or comparable data modeling tools. This role will focus on designing scalable enterprise data models that support analytics,…
Quick Apply
Data Architects
Lambdanets —Columbus, OH
Bachelors degree in computer science, computer engineering, or liberal arts with equivalent technical experience. 5+ years expertise with modular XML DTDs.

Show more jobs in cities nearby

I want to receive the latest job alert for data warehousing architects in maine

By signing in to your account, you agree to SimplyHired's Terms of Service and consent to our Cookie and Privacy Policy.

Explore jobs in more locations

data warehousing architects jobs near maine

Senior Programmer Analyst - MaineDOT Data Warehousing Team

State of Maine -
Augusta, ME

Apply Now

Job Details

Full-time
$71,993.86 - $101,161.81 a year
1 day ago

Benefits

Paid parental leave
457(b)
Paid holidays
Health insurance
Dental insurance
Flexible spending account
Parental leave
Dependent health insurance coverage
Employee assistance program
Gym membership
Loan forgiveness
Retirement plan

Qualifications

Engineering development testing
Team supervision
System testing
Software documentation
Systems & applications support
Cross-functional collaboration
Developer tools
Design (software development lifecycle)

Full Job Description

If you are a current State of Maine employee, please submit your application through the internal application process using the Find Jobs report in PRISM. Seasonal employees who do not have PRISM access should apply through the State’s career page and indicate on the application that they have previously worked for the State.

Office of Information Technology

Opening Date: July 28, 2026

Closing Date: August 11, 2026

Grade / Admin Unit : 27 / Professional/Technical

Job Class Code: 0866
Salary: $71,993.86 - $101,161.81*/Annually (*includes a 23.66% recruitment and retention stipend, and eligible for a 5% training bonus)
Position Number: 200024881

Location: Augusta

Telework: This position is a hybrid remote/onsite position. The onsite location is in Augusta, Maine and the remote location must be within the S tate 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 blaz e paths towards newly emerging data domains .

You c ould 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 question s , 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 S enior P rogrammer A nalyst within the Database and Data Warehousing Team , y ou 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 D ata M arts . 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.

KNOWLEDGE, SKILLS, AND ABILITIES REQUIRED:

K nowledge of data system design techniques

Knowledge of S ystems D evelopment 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

MINIMUM QUALIFICATIONS:

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

APPLICATION INSTRUCTIONS:

Please submit a cover letter along with a current resume and three (3) professional references .

In order for us to properly determine if you meet the minimum qualifications for any posting, you must be sure your resume includes the month and year for any relevant experience listed. Your resume should include the duties and responsibilities associated with each position. Any experience that was not full-time employment should be identified as such.

CONTACT INFORMATION: For more information or questions specific to the position, please contact [email protected]

The selected candidate will be required to pass the required background checks (fingerprinting may be required) as a condition of employment.

BENEFITS OF WORKING FOR THE STATE OF MAINE:

No matter where you work across Maine state government, you find employees who embody our state motto—"Dirigo" or "I lead"—as they provide essential services to Mainers every day. We believe in supporting our workforce's health and wellbeing with a valuable total compensation package, including:

Work-Life Balance – Rest is essential. Take time for yourself using 13 paid holidays, 12 days of sick leave, and 3+ weeks of vacation leave annually. Vacation leave accrual increases with years of service, and overtime-exempt employees receive personal leave.
Health Insurance Coverage – The State of Maine pays 85%-100% of employee-only premiums ($11,857.68-$13,950.24 annual value), depending on salary. Use this chart to find the premium costs for you and your family, including the percentage of dependent coverage paid by the State.
Health Insurance Premium Credit – Participation decreases employee-only premiums by 5%. Visit the Office of Employee Health and Wellness for more information about program requirements .
Dental Insurance – The State of Maine pays 100% of employee-only dental premiums ($365.28 annual value).
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 – Improve overall health with regular exercise and receive up to $40 per month to offset this expense.
Health and Dependent Care Flexible Spending Accounts – Set aside money pre-tax to help pay for out-of-pocket health care expenses and/or daycare expenses.
Public Service Student Loan Forgiveness – The State of Maine is a qualified employer for this federal program. For more information, visit the Federal Student Aid office .
Living Resources Program – Navigate challenging work and life situations with our employee assistance program.
Parental leave is one of the most important benefits for any working parent. All employees who are welcoming a child—including fathers and adoptive parents—receive forty-two (42) consecutive calendar days of fully paid parental leave . Additional, unpaid leave may also be available, under the Family and Medical Leave Act .
Voluntary Deferred Compensation – Save additional pre-tax funds for retirement in a MaineSaves 457(b) account through payroll deductions.

State employees are eligible for an extensive and highly competitive benefits package , covering many aspects of wellness. Learn about additional wellness benefits for State employees from the Office of Employee Health and Wellness .

Note: Benefits may vary somewhat according to specific collective bargaining agreements and are prorated for anything less than full-time.

There's a job and then there's purposeful, transformative work. Our aim is to create a workplace where you can learn, grow, and continuously refine your skills. Applicants demonstrate job requirements in differing ways, and we appreciate that many skills and backgrounds can make people successful in this role.

As an Equal Opportunity employer, Maine State Government embraces a culture of respect and awareness. We are committed to creating a strong sense of belonging for all team members, and our process ensures an inclusive environment to applicants of all backgrounds including diverse race, color, sex, sexual orientation or gender identity, physical or mental disability, religion, age, ancestry, national origin, familial status or genetics.

If you’re looking for a great next step, and want to feel good about what you do, we’d love to hear from you. Please note reasonable accommodations are provided to qualified individuals with disabilities upon request.

Thinking about applying?

Research shows that people from historically excluded communities tend to apply to jobs only when they check every box in the posting. If you’re currently reading this and hesitating to apply for that reason, we encourage you to go for it! Let us know how your experience and passion set you apart.

If you are unable to complete the online application, please contact the Human Resources representative listed on the job opening you are interested in applying for. They will work with you for an alternative method of submitting.

Apply Now

Refine Your Search

data warehousing architects jobs in maine

Senior Programmer Analyst - MaineDOT Data Warehousing Team

Data Architect

Director, Data Science Operations

Enterprise Information Architect I

Data Architect

M-78-Data Architect 144227.

Database Architect

Solution Architect

More jobs to discover

Explore jobs in cities nearby

I want to receive the latest job alert for data warehousing architects in maine

Explore jobs in more locations

Job Seeker Tools

Employer Tools

Browse

Stay Connected