OAC & ADW Solutions Architect — Federal Cloud

Concept Plus LLC; Fairfax (VA); On-site; USD 120,000 - 160,000; Full time

Benefits offered by this job

Competitive pay

Health insurance

Dental insurance

Vision insurance

Life insurance

Paid time off

11 paid holidays

Performance bonuses

Tuition reimbursement

Unlimited training

Job summary

Concept Plus is seeking an experienced Oracle Analytics Cloud (OAC) / Autonomous Data Warehouse (ADW) Specialist to design, implement, and optimize analytics solutions for a government program leveraging OCI. You will collaborate with data architects, developers, analysts, and stakeholders to deliver secure, cloud-native data and analytics capabilities.

Responsibilities include building dashboards, modeling data, configuring security, and ensuring compliance with federal standards such as FISMA

Qualifications

• US citizen able to obtain/maintain US Government Public Trust.
• Bachelor’s degree in Computer Science, Information Systems, Engineering, or related field.
• 5+ years of experience with Oracle BI, OAC, or OBIEE.
• 3+ years with Oracle Autonomous Database (ADW/ATP) or Oracle Cloud solutions.
• 3+ years developing reports or dashboards for and EBS implementations.
• Hands-on experience with OCI components (Object Storage, IAM, Networking, Logging, Monitoring).
• Strong SQL, PL/SQL, and data modeling skills.
• Experience with ETL/ELT pipelines and cloud data integration tools.

Responsibilities

• Develop interactive dashboards, data visualizations, and self-service analytics using OAC.
• Model semantic layers, data sets, and data flows to support analytics and reporting.
• Configure OAC security, roles, and access controls in line with government policies.
• Optimize OAC performance through tuning, caching, and dataset optimization.
• Integrate OAC with ADW, Object Storage, OCI Data Integration, APIs, and data sources.
• Design and manage ADW schemas, tables, partitions, and data pipelines.
• Implement ETL/ELT processes using OCI Data Integration or ODI/Data Flow.
• Monitor ADW performance and manage resource usage.
• Support data ingestion from on-premises, multi-cloud, and external systems.
• Enforce ADW security practices including VCN integration, private endpoints, data masking, and auditing.
• Deploy OAC and ADW within OCI using secure patterns.
• Manage OCI services such as Object Storage, Data Integration, IAM, Logging, Networking, Monitoring.
• Provide Tier 2/3 support for OAC/ADW functionality, performance, and availability.
• Deliver training to analysts and end users on OAC dashboards, reporting, and data models.
• Document cloud architectures, data flows, and operational processes for compliance.
• Support Authority to Operate (ATO) documentation and security assessments.

Skills

Oracle BI/OAC/OBIEE

Oracle Autonomous Database (ADW/ATP)

SQL/PLSQL

Data modeling

ETL/ELT pipelines

Education

Bachelor's degree in Computer Science/IS/Engineering

Tools

Object Storage

IAM

Networking

Logging

Monitoring

Terraform

ADW/ATP

Job description

Concept Plus is seeking an experienced Oracle Analytics Cloud (OAC) / Autonomous Data Warehouse (ADW) Specialist to design, implement, and optimize analytics solutions for a government program leveraging OCI. You will collaborate with data architects, developers, analysts, and stakeholders to deliver secure, cloud-native data and analytics capabilities.

Responsibilities include building dashboards, modeling data, configuring security, and ensuring compliance with federal standards such as FISMA