Concept Plus, LLC ยท 1 week ago
Oracle Analytics Cloud/ADW Specialist
Concept Plus is a mission-focused technology solutions provider that transforms IT concepts into impactful solutions for federal agencies. They are seeking an experienced Oracle Analytics Cloud (OAC) / Autonomous Data Warehouse (ADW) Specialist to design, implement, and optimize analytics solutions that enhance data accessibility and decision-making across the enterprise.
Information Technology & Services
Responsibilities
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
Qualification
Required
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 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
Benefits
Comprehensive health, dental, and vision insurance
Paid life insurance
Paid time off
11 paid holidays
Performance bonuses
Tuition reimbursement
Unlimited training