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 DB's.
• 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 Architect Required 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