> Markdown version of [/jobs/ext/1291932-oracle-analytics-cloud-oac-developer](https://www.wearedevelopers.com/jobs/ext/1291932-oracle-analytics-cloud-oac-developer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Oracle Analytics Cloud (OAC) Developer... - **Company:** Mission Support and Test Services, LLC - **Location:** North Las Vegas, NV, United States - **Experience:** Expert - **Salary:** $97,219.0 - $145,829.0 - **Contract:** Permanent contract - **Skills:** Artificial Intelligence, Data Analysis, Audit Trail, Microsoft Azure, Big Data, Software as a Service, Cloud Computing, Cloud Database, Databases, System Configuration, Data Files, Extract Transform Load (ETL), Data Masking, Data Transformation, Data Mining, Data Retrieval, Data Security, Data Visualization, Data Warehousing, Java Database Connectivity, Python (Programming Language), Network Security, Machine Learning, Microsoft SQL Server, Network Connections, Operational Data Store, Oracle Databases, Oracle (Applications), Performance Tuning, SAP Sales and Distribution, PL-SQL, Oracle Fusion Middleware, Data Streaming, Systems Integration, Sql Optimization, Bi Publisher, Pixel Perfect, Indexer, Usage Tracking, Oracle Service Cloud, Data Lineage, Tools for Reporting, Virtual Agents, Oracle Cloud Infrastructure, Data Pipelines, Sql Tuning, Data Caching - **Published:** July 16, 2026 - **Apply:** https://www.juju.com/job/00000000ggvq8y ## About the Role Due to the nature of our work, US Citizenship is required for all positions. + Bachelor's degree in a computer related field or equivalent computer related experience with at least 5 years of relevant, progressively responsible experience. + Minimum of 6-8 years in BI and analytics, with at least 3-4 years specifically with Oracle Analytics Cloud (OAC). + Proven experience as an OAC Administrator, responsible for environment management, security, and lifecycle management tasks. + Experience in designing end-to-end reporting solutions within the Oracle Cloud environment. + Expertise in OAC development, data modeling, performance tuning, and integrating various data sources. + Fusion SaaS Connectivity & Reporting: + Extensive experience connecting OAC to Oracle Fusion Cloud Applications (ERP/HCM) to access operational data in real-time. This includes deep familiarity with leveraging Oracle Transactional Business Intelligence (OTBI) subject areas and analyses as data sources within OAC datasets. + Proficiency in utilizing BI Publisher (BIP) reports as data sources for more complex or pixel-perfect reporting requirements within the Fusion environment. + Experience with BI Cloud Connector (BICC) for extracting data from Fusion SaaS into a data warehouse (e.g., Oracle Autonomous Data Warehouse) for blended, cross-functional reporting and data transformation. + Understanding of the shared security model, where OAC can utilize the security permissions and role assignments established in the source Fusion applications. + Proficiency in OAC components: Data Visualization, RPD modeling, Data Flows, and Data Sets. + Expertise in Advanced SQL and PL/SQL. + Familiarity with data warehousing concepts, including schema design, ETL/ELT processes, and database architecture for scalability. + External Database Integration: + Hands-on experience in connecting OAC to a variety of external, non-Oracle databases (such as SQL Server or other cloud databases like Azure/Google) using native connectors or JDBC drivers. + Experience with connection types, network security groups (NSGs), and private access channels within OCI to ensure secure and reliable communication between OAC and private or on-premise databases. + Data Security & Governance: Expertise in establishing and enforcing robust data security and governance frameworks across the entire Oracle Analytics Cloud and Oracle Fusion ecosystem. + Relevant Oracle certifications are highly valued, such as Oracle Analytics Cloud Certified Professional. + The primary work location will be at the Losee Road facility in North Las Vegas, Nevada. + Work schedule will be 4/10s Monday through Thursday (subject to change). + Pre-placement physical examination, which includes a drug screen, is required. MSTS maintains a substance abuse policy that includes random drug testing. + Must possess a valid driver's license. Ability to obtain a HSPD-12 Personal Identity Verification credential under the Department of Energy Order 206.2, ' _Identity, Credential, and Access Management_ ,' and Supplemental Directive NNSA SD 206.2, ' _Implementation of Personal Identity Verification for Uncleared Contractors_ .' ## Description + **Fusion SaaS Connectivity & Reporting:** + Monitor and optimize the performance of OAC dashboards, reports, and data models by fine-tuning queries, managing data caching, and implementing best practices for handling **large-volume datasets** . + Troubleshoot and resolve performance issues related to report generation, data extraction, and database bottlenecks using tools such as SQL Tuning Advisor and Explain Plan analysis. + Design and implement efficient data loading and extraction strategies (using tools like BICC or OIC) to manage data pipelines for large-scale data solutions. + Advise on data partitioning, indexing, and materialized views to improve query execution speed and overall system responsiveness. + **External Database Integration:** + Configure **Remote Data Connectivity** using the OAC Data Gateway for secure, live data access to on-premise data sources. + Design solutions that blend data from various sources (Fusion SaaS, external databases, flat files) into cohesive datasets and visualizations for comprehensive analysis. + **Application & Data Security (OAC):** + Implement **fine-grained access controls** within OAC, managing application roles, catalog permissions, and data filters to ensure users only view data relevant to their security context. + Configure security settings to ensure that the security model defined in the source Oracle Fusion Applications (e.g., HR role hierarchies in HCM, data access sets in ERP) is respected when accessing data via OTBI or BICC extractions. + Utilize data masking and encryption best practices to protect sensitive or personally identifiable information (PII/PHI) within data sets and warehouses used for analytics. + **Governance & Compliance:** + Define and document governance policies for OAC content lifecycle management, data lineage, and audit logging to meet regulatory requirements (e.g., SOX, GDPR). + Monitor data usage, access patterns, and policy compliance using OAC and OCI audit logs and reporting tools. + Ensure system configurations adhere to established security zones and corporate security standards within the Oracle Cloud Infrastructure (OCI) environment. + **Compartment Strategy:** + Leverage OCI compartment management for logical isolation of OAC instances and data resources to enhance security and governance posture. + **AI and Machine Learning Integration:** + Leverage OAC's embedded ML and AI capabilities to build predictive models, perform anomaly detection, and generate data-driven insights. + Utilize the OAC **AI Assistant** for natural language querying and data visualization generation to enhance user accessibility and productivity. + Integrate and deploy Machine Learning models developed using tools like Oracle Machine Learning (OML) or Python/R into OAC dashboards to support advanced analytics and forecasting. ## Related Videos - [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology) - [Remote Driving on Plant Grounds with State-of-the-Art Cloud Technologies](https://www.wearedevelopers.com/videos/251-remote-driving-on-plant-grounds-with-state-of-the-art-cloud-technologies) - [Optimizing Discovery: PostgreSQL's Role in Transforming GetYourGuide's Search](https://www.wearedevelopers.com/videos/1647-optimizing-discovery-postgresql-s-role-in-transforming-getyourguide-s-search) - [From Global Capability Centers to AI-Powered Command Centers](https://www.wearedevelopers.com/videos/100096-from-global-capability-centers-to-ai-powered-command-centers) - [PySpark - Combining Machine Learning & Big Data](https://www.wearedevelopers.com/videos/44-pyspark-combining-machine-learning-big-data) - [Dynamic Entities in .NET: Building Low-Code Systems on Top of Entity Framework Core](https://www.wearedevelopers.com/videos/100218-dynamic-entities-in-net-building-low-code-systems-on-top-of-entity-framework-core) ## Related Articles - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production) - [7 Cloud Computing Trends Coming in 2025 for Developers](https://www.wearedevelopers.com/magazine/412-7-cloud-computing-trends-coming-in-2025-for-developers) - [MLOps – What’s the deal behind it?](https://www.wearedevelopers.com/magazine/125-mlops-what-s-the-deal-behind-it)