[Remote] Oracle Analytics Cloud/ADW Specialist (US Citizenship Required)
Note: The job is a remote job and is open to candidates in USA. 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.
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
Skills
- 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
- Competitive pay
- Comprehensive health, dental, and vision insurance
- Paid life insurance
- Paid time off
- 11 paid holidays
- Performance bonuses
- Tuition reimbursement
- Unlimited training
- The opportunity to thrive in a collaborative, flexible, and innovative environment
Company Overview