Data Architect

Knowledge Services is seeking a Data Architect to support a project through June 2026 (potential for extension) with the State of Maine Office of Technology in Augusta ME.

• Work Location: Majority Remote position but will be required to be onsite in Augusta ME one day a month.
• 40-hour work week from Monday through Friday 8:00am to 5:00pm

Data Architect Responsibilities:

This individual will serve as a daily subject-matter expert for all Oracle technologies and toolsets.

Much of the work will focus on data modeling and developing automated ETL processes that pull data from a variety of data sources.

Developing automated ETL.
Designing & implementing enterprise class data repositories built upon Oracle on prem and cloud hosted DBs.
Expertise in dimensional modeling and ability to act as a technical mentor.

Will be expected to develop monitor and maintain a variety of automated DB processes.

Will be expected to research and resolve database issues as they arise.

Will be assigned a variety of database management and maintenance tasks.

Will serve as trusted technical advisor to the MaineIT/MaineDOT Application Support team and serve as a technical mentor.

Will collaborate with other developers analysts and employed DBAs.

Will work closely with IT vendors IT leadership and MaineDOT business partners.

Will play a key role in upcoming system migrations system expansions and data modernization efforts.

Data ArchitectRequired Skills:

Has extensive practical experience with the modern Oracle platforms and technologies. This includes the following:

Significant Senior DBA-level experience with regards to designing and implementing enterprise class data repositories built upon Oracle on-prem and cloud-hosted databases.

Practical experience developing fully automated ETL processes from a variety of flat-file and DB sources.

Practical experience utilizing API calls for automated data refreshes.

Practical experience with Oracle Analytics Cloud (OAC)

Mastery of SQL and PL/SQL and the ability to develop complex procedures functions views and scripts.

Expertise in dimensional modeling.
Experience with tabular data models.
Proven ability to accurately capture complex business requirements and translate those into technical solutions which are robust performant scalable reliable and expandable.
Demonstrates a disciplined approach to process and error logging.
Maintains excellent work habits when it comes to coding comments system documentation and metadata creation.
Ability to serve as a technical mentor to both senior and junior IT staff.
Ability to develop architectural diagrams and system documentation and train others on the content.
Demonstrates previous success in independently researching technical options to find suitable solutions for evolving technical needs.
Works independently towards project and/or assignments goals with limited day-to-day oversight and/or prompting.

We are an Equal Opportunity Employer. We do not discriminate on the basis of race religion color sex age national origin or disability.

INDIT

ISDPD