Oracle Analytics Cloud/ADW Specialist

Concept Plus LLC; United States; 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

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, we bring the agility, responsiveness and customer intimacy of a small business combined with the quality and infrastructure of a larger firm.

Recognized as an award-winning Oracle partner, we have delivered innovative solutions across Defense, Intelligence, Civilian, Health IT, and Tribal sectors. Our highly certified experts build systems that drive efficiency, accelerate modernization, and ensure mission outcomes with certainty.

We offer competitive pay, comprehensive health, dental, and vision insurance, paid life insurance, paid time off, 11 paid holidays, performance bonuses, tuition reimbursement, unlimited training, and the opportunity to thrive in a collaborative, flexible, and innovative environment.

Concept Plus is seeking an experienced Oracle Analytics Cloud (OAC) / Autonomous Data Warehouse (ADW) Specialist to support a mission-critical government program operating within Oracle Cloud Infrastructure (OCI). The ideal candidate will design, implement, and optimize analytics solutions that enhance data accessibility, reporting, and decision making across the enterprise. This role involves close collaboration with data architects, developers, analysts, and government stakeholders to deliver secure, compliant, cloud‑native data and analytics capabilities.

What you'll do

• 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.
• Integrate OAC with ADW, Object Storage, OCI Data Integration, APIs, and other data sources.
• 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.
• 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.
• 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.
• 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.
• 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 with developing reports or dashboards for and 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. As such, we will give your application full consideration without regard to your race, color, religion, sex, age, national origin, disability, veteran status, sexual orientation, gender identity, or any other classification protected by federal, state, or local law.