Senior Oracle Data Warehouse Architect - Hybrid/Remote

Austincc; Augusta (ME); Hybrid; USD 110,000 - 165,000; Full time

Benefits offered by this job

Job summary

Austincc is seeking an experienced Oracle Database Architect to lead enterprise data architecture, data warehousing, and automated data integration workflows. This hybrid role focuses on on-prem and cloud Oracle environments, analytics, and mentoring staff.

Responsibilities include designing data repositories, ETL pipelines, data models, and BI solutions with Oracle Analytics Cloud. The position requires collaboration with leadership and stakeholders across engineering teams.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, or related field.
• Proven track record as a Database Architect, Senior Data Warehouse Developer, or Senior Oracle DBA.
• Deep expertise across modern Oracle ecosystems (on-premises and cloud).
• Strong background in dimensional modeling, data warehousing, and data governance.
• Public Sector / Government IT Project Experience is valued.
• Location: Hybrid / Mostly Remote with 1 day onsite per month in New England.

Responsibilities

• Design, implement, and maintain enterprise-class data repositories on Oracle platforms (on‑prem and cloud).
• Build, deploy, and monitor automated ETL/ELT pipelines from diverse sources.
• Develop dimensional and tabular data models for analytics and reporting.
• Write and optimize SQL/PL/SQL code, procedures, views, and jobs.
• Implement BI and reporting using Oracle Analytics Cloud.
• Establish standards for monitoring, error handling, and metadata.

Skills

Oracle DB Design

SQL/PLSQL

ETL Development

Dimensional Modeling

Oracle Analytics Cloud

Reporting Optimization

System Architecture

Govt IT Experience

Education

Bachelor's degree

Job description

Austincc is seeking an experienced Oracle Database Architect to lead enterprise data architecture, data warehousing, and automated data integration workflows. This hybrid role focuses on on-prem and cloud Oracle environments, analytics, and mentoring staff.

Responsibilities include designing data repositories, ETL pipelines, data models, and BI solutions with Oracle Analytics Cloud. The position requires collaboration with leadership and stakeholders across engineering teams.