{"schemaVersion":"jobsearcher.job.v1","id":"b1a0636e32921589bfd855cf","url":"https://jobsearcher.com/jobs/b1a0636e32921589bfd855cf","canonicalUrl":"https://jobsearcher.com/jobs/b1a0636e32921589bfd855cf","title":"Oracle Analytics Cloud (OAC) Developer & Administrator (I-9 will be verified)","description":"Link Technologies (LinkTechConsulting.com), a Las Vegas based IT consulting firm, is currently seeking an Oracle Analytics Cloud (OAC) Developer & Administrator to join our team. Employer asks for I-9 information.\nREQUIREMENTS\n· Bachelor's degree in Computer Science, Information Technology, or a related field.\n· Minimum of six (6) to eight (8) years in BI and analytics, with at least three (3) to four (4) years specifically with Oracle Analytics Cloud (OAC).\n· Proven experience as an OAC Administrator, responsible for environment management, security, and lifecycle management tasks.\n· Experience in designing end-to-end reporting solutions within the Oracle Cloud environment.\n· Expertise in OAC development, data modeling, performance tuning, and integrating various data sources.\n· Certifications: relevant Oracle certifications are highly valued, such as Oracle Analytics Cloud Certified Professional.\n· Ability to work collaboratively in a team environment while also being self-motivated\nCORE TECHNICAL SKILLS\nFusion SaaS Connectivity & Reporting:\nExtensive 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.\nProficiency in utilizing BI Publisher (BIP) reports as data sources for more complex or pixel-perfect reporting requirements within the Fusion environment.\nExperience 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.\nUnderstanding of the shared security model, where OAC can utilize the security permissions and role assignments established in the source Fusion applications.\nProficiency in OAC components: Data Visualization, RPD modeling, Data Flows, and Data Sets.\nExpertise in Advanced SQL and PL/SQL.\nFamiliarity with data warehousing concepts, including schema design, ETL/ELT processes, and database architecture for scalability.\nMonitor 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.\nTroubleshoot and resolve performance issues related to report generation, data extraction, and database bottlenecks using tools such as SQL Tuning Advisor and Explain Plan analysis.\nDesign and implement efficient data loading and extraction strategies (using tools like BICC or OIC) to manage data pipelines for large-scale data solutions.\nAdvise on data partitioning, indexing, and materialized views to improve query execution speed and overall system responsiveness.\nExternal Database Integration:\nHands-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.\nExpertise in configuring Remote Data Connectivity using the OAC Data Gateway for secure, live data access to on-premise data sources.\nExperience 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.\nAbility to design solutions that blend data from various sources (Fusion SaaS, external databases, flat files) into cohesive datasets and visualizations for comprehensive analysis.\nData Security & Governance: Expertise in establishing and enforcing robust data security and governance frameworks across the entire Oracle Analytics Cloud and Oracle Fusion ecosystem.\nApplication & Data Security (OAC):\nImplementing 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.\nConfiguring 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.\nUtilizing data masking and encryption best practices to protect sensitive or personally identifiable information (PII/PHI) within data sets and warehouses used for analytics.\nGovernance & Compliance:\nDefining and documenting governance policies for OAC content lifecycle management, data lineage, and audit logging to meet regulatory requirements (e.g., SOX, GDPR).\nExperience with monitoring data usage, access patterns, and policy compliance using OAC and OCI audit logs and reporting tools.\nEnsuring system configurations adhere to established security zones and corporate security standards within the Oracle Cloud Infrastructure (OCI) environment.\nCompartment Strategy: Ability to leverage OCI compartment management for logical isolation of OAC instances and data resources to enhance security and governance posture.\nAI and Machine Learning Integration:\nLeverage OAC's embedded ML and AI capabilities to build predictive models, perform anomaly detection, and generate data-driven insights.\nUtilize the OAC AI Assistant for natural language querying and data visualization generation to enhance user accessibility and productivity.\nIntegrate 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.\nLink Technologies is an equal opportunity employer. All qualified applicants will receive consideration for employment without discrimination based on race, color, religion, sex, gender identity/expression, sexual orientation, national origin, protected veteran status, disability, or any other factors protected by law.\nJob Type: Full-time\nBenefits:\nDental insurance\nHealth insurance\nVision insurance\nExperience:\nOracle BI: 6 years (Required)\nAnalytics: 6 years (Required)\nOracle Analytics Cloud: 3 years (Required)\nOAC Administrator: 2 years (Required)\nReporting Solutions: 2 years (Preferred)\nData modeling: 5 years (Required)\nPerformance tuning: 5 years (Required)\nOTBI: 3 years (Required)\nBIP: 3 years (Required)\nBICC: 3 years (Required)\nRemote Data Connectivity : 3 years (Required)\nLicense/Certification:\nOracle Analytics Cloud Certified Professional (Preferred)\nWork Location: Remote","company":"Link Technologies","rawCompany":"link technologies","city":"Remote","state":"OR","isRemote":false,"isActive":false,"createdAt":"2026-04-14T10:26:22.030Z","occupations":[{"code":"15-1211.00","title":"Computer Systems Analysts","slug":"computer-systems-analysts"},{"code":"15-1243.01","title":"Data Warehousing Specialists","slug":"data-warehousing-specialists"},{"code":"15-1252.00","title":"Software Developers","slug":"software-developers"}],"industries":[{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"},{"code":"513210","title":"Software Publishers","slug":"software-publishers"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"Oracle Analytics Cloud (OAC) Developer & Administrator (I-9 will be verified)","description":"Link Technologies (LinkTechConsulting.com), a Las Vegas based IT consulting firm, is currently seeking an Oracle Analytics Cloud (OAC) Developer & Administrator to join our team. Employer asks for I-9 information.\nREQUIREMENTS\n· Bachelor's degree in Computer Science, Information Technology, or a related field.\n· Minimum of six (6) to eight (8) years in BI and analytics, with at least three (3) to four (4) years specifically with Oracle Analytics Cloud (OAC).\n· Proven experience as an OAC Administrator, responsible for environment management, security, and lifecycle management tasks.\n· Experience in designing end-to-end reporting solutions within the Oracle Cloud environment.\n· Expertise in OAC development, data modeling, performance tuning, and integrating various data sources.\n· Certifications: relevant Oracle certifications are highly valued, such as Oracle Analytics Cloud Certified Professional.\n· Ability to work collaboratively in a team environment while also being self-motivated\nCORE TECHNICAL SKILLS\nFusion SaaS Connectivity & Reporting:\nExtensive 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.\nProficiency in utilizing BI Publisher (BIP) reports as data sources for more complex or pixel-perfect reporting requirements within the Fusion environment.\nExperience 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.\nUnderstanding of the shared security model, where OAC can utilize the security permissions and role assignments established in the source Fusion applications.\nProficiency in OAC components: Data Visualization, RPD modeling, Data Flows, and Data Sets.\nExpertise in Advanced SQL and PL/SQL.\nFamiliarity with data warehousing concepts, including schema design, ETL/ELT processes, and database architecture for scalability.\nMonitor 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.\nTroubleshoot and resolve performance issues related to report generation, data extraction, and database bottlenecks using tools such as SQL Tuning Advisor and Explain Plan analysis.\nDesign and implement efficient data loading and extraction strategies (using tools like BICC or OIC) to manage data pipelines for large-scale data solutions.\nAdvise on data partitioning, indexing, and materialized views to improve query execution speed and overall system responsiveness.\nExternal Database Integration:\nHands-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.\nExpertise in configuring Remote Data Connectivity using the OAC Data Gateway for secure, live data access to on-premise data sources.\nExperience 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.\nAbility to design solutions that blend data from various sources (Fusion SaaS, external databases, flat files) into cohesive datasets and visualizations for comprehensive analysis.\nData Security & Governance: Expertise in establishing and enforcing robust data security and governance frameworks across the entire Oracle Analytics Cloud and Oracle Fusion ecosystem.\nApplication & Data Security (OAC):\nImplementing 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.\nConfiguring 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.\nUtilizing data masking and encryption best practices to protect sensitive or personally identifiable information (PII/PHI) within data sets and warehouses used for analytics.\nGovernance & Compliance:\nDefining and documenting governance policies for OAC content lifecycle management, data lineage, and audit logging to meet regulatory requirements (e.g., SOX, GDPR).\nExperience with monitoring data usage, access patterns, and policy compliance using OAC and OCI audit logs and reporting tools.\nEnsuring system configurations adhere to established security zones and corporate security standards within the Oracle Cloud Infrastructure (OCI) environment.\nCompartment Strategy: Ability to leverage OCI compartment management for logical isolation of OAC instances and data resources to enhance security and governance posture.\nAI and Machine Learning Integration:\nLeverage OAC's embedded ML and AI capabilities to build predictive models, perform anomaly detection, and generate data-driven insights.\nUtilize the OAC AI Assistant for natural language querying and data visualization generation to enhance user accessibility and productivity.\nIntegrate 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.\nLink Technologies is an equal opportunity employer. All qualified applicants will receive consideration for employment without discrimination based on race, color, religion, sex, gender identity/expression, sexual orientation, national origin, protected veteran status, disability, or any other factors protected by law.\nJob Type: Full-time\nBenefits:\nDental insurance\nHealth insurance\nVision insurance\nExperience:\nOracle BI: 6 years (Required)\nAnalytics: 6 years (Required)\nOracle Analytics Cloud: 3 years (Required)\nOAC Administrator: 2 years (Required)\nReporting Solutions: 2 years (Preferred)\nData modeling: 5 years (Required)\nPerformance tuning: 5 years (Required)\nOTBI: 3 years (Required)\nBIP: 3 years (Required)\nBICC: 3 years (Required)\nRemote Data Connectivity : 3 years (Required)\nLicense/Certification:\nOracle Analytics Cloud Certified Professional (Preferred)\nWork Location: Remote","datePosted":"2026-04-14T10:26:22.030Z","dateModified":"2026-04-14T10:26:22.030Z","hiringOrganization":{"@type":"Organization","name":"Link Technologies","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Remote","addressRegion":"OR","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"b1a0636e32921589bfd855cf"},"url":"https://jobsearcher.com/jobs/b1a0636e32921589bfd855cf"}}