Oracle Analytics Cloud/ADW Specialist (US Citizenship Required)

Concept Plus, LLC; United States; On-site; USD 100,000 - 130,000; Full time

Benefits offered by this job

Competitive pay

Comprehensive health, dental, and vision insurance

Paid life insurance

Paid time off and 11 paid holidays

Performance bonuses

Tuition reimbursement

Unlimited training

Job summary

Concept Plus, LLC seeks an experienced Oracle Analytics Cloud (OAC) Specialist in the United States to support critical government programs. This position involves designing and optimizing analytics solutions within Oracle Cloud Infrastructure (OCI) while ensuring compliance with federal security frameworks. Ideal candidates have a degree in a related field, extensive experience with Oracle BI solutions, and strong SQL skills. Comprehensive health insurance and a competitive pay package are included.

Qualifications

• US Citizen with ability to obtain/maintain a US Government Public Trust clearance.
• 5+ years of experience working with Oracle BI, OAC, or OBIEE.
• 3+ years of experience with Oracle Autonomous Database (ADW/ATP) or Oracle Cloud solutions.

Responsibilities

• Develop interactive dashboards, data visualizations, and self-service analytics using OAC.
• Design and manage ADW schemas, tables, partitions, and data pipelines.
• Ensure compliance with federal IT security frameworks (FISMA, FedRAMP, NIST 800-53, etc.).

Skills

Oracle BI

Oracle Analytics Cloud

Oracle Autonomous Database

SQL

PL/SQL

Data modeling

ETL/ELT

Cloud data integration tools

Terraform

Education

Bachelor's degree in Computer Science, Information Systems, Engineering, or related field

Tools

Object Storage

IAM

Networking

Logging

Monitoring

Job description

About Concept Plus

Concept Plus is a mission-focused technology solutions provider that transforms IT concepts into impactful solutions for federal agencies. Headquartered in Fairfax, VA.

Benefits

• Competitive pay
• Comprehensive health, dental, and vision insurance
• Paid life insurance
• Paid time off and 11 paid holidays
• Performance bonuses
• Tuition reimbursement
• Unlimited training

About The Role

Concept Plus seeks an experienced Oracle Analytics Cloud (OAC)/Autonomous Data Warehouse (ADW) Specialist to support a mission‑critical government program within Oracle Cloud Infrastructure (OCI). The role involves designing, implementing, and optimizing analytics solutions to enhance data accessibility, reporting, and decision‑making across the enterprise.

What You’ll Do

Oracle Analytics Cloud (OAC)

• Develop interactive dashboards, data visualizations, and self‑service analytics using OAC.
• Model semantic layers, data sets, and data flows to support advanced analytics and reporting.
• Configure OAC security, user roles, and access controls in accordance with government security policies.
• Optimize OAC performance through tuning, caching, dataset optimization, and query analysis.

Autonomous Data Warehouse (ADW)

• Design and manage ADW schemas, tables, partitions, and data pipelines.
• Implement efficient ETL/ELT processes using OCI Data Integration, ODI, Data Flow, or custom solutions.
• Monitor ADW performance, manage resource usage, and apply tuning optimizations.
• Support data ingestion from on‑premises, multi‑cloud, and external systems.
• Enforce ADW security best practices including VCN integration, private endpoints, data masking, encryption, and auditing.

Oracle Cloud Infrastructure (OCI)

• Deploy and configure OAC and ADW within OCI using secure cloud architectural patterns.
• Manage OCI services such as Object Storage, Data Integration, IAM, Logging, Networking, and Monitoring.
• Support infrastructure automation using Terraform, Resource Manager, or equivalent IaC tools.
• Document cloud architectures, data flows, and operational processes for government compliance requirements.

Security & Compliance

• Ensure compliance with federal IT security frameworks (FISMA, FedRAMP, NIST 800‑53, etc.).
• Implement and maintain audit controls, access management, and vulnerability remediation activities.
• Support Authority to Operate (ATO) documentation, technical assessments, and ongoing monitoring.

Collaboration & Support

• Work closely with government stakeholders to translate analytic needs into cloud‑based solutions.
• 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.

Qualifications

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

Concept Plus is an Equal Opportunity Employer. All applications are considered without regard to race, color, religion, sex, age, national origin, disability, veteran status, sexual orientation, gender identity, or any other protected classification.