HukariAscendent · 21 hours ago
Oracle Analytics Cloud (OAC) Administrator\Developer
United States
Contract
Remote
Senior Level
6+ years expHukariAscendent is a Women-Owned, Small Business specializing in engineering and technical support services for the nuclear power sector. They are seeking an Oracle Analytics Cloud (OAC) Developer/Administrator to connect OAC to Oracle Fusion Cloud Applications, manage data integration and security governance while leveraging advanced analytics capabilities.
EnergyRenewable Energy
No H1B
U.S. Citizen OnlyHiring Manager
Jordan Moon
Responsibilities
Extensive experience connecting OAC to Oracle Fusion Cloud Applications (ERP/HCM) to access operational data in real-time
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 complex or pixel-perfect reporting requirements
Experience with BI Cloud Connector (BICC) for extracting data from Fusion SaaS into a data warehouse
Understanding of the shared security model with OAC and 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
Monitor and optimize performance of OAC dashboards, reports, and data models by fine-tuning queries, managing data caching, and implementing best practices
Troubleshoot and resolve performance issues using tools such as SQL Tuning Advisor and Explain Plan analysis
Design and implement efficient data loading and extraction strategies for large-scale data solutions
Advise on data partitioning, indexing, and materialized views to improve query execution speed and system responsiveness
Hands-on experience connecting OAC to external, non-Oracle databases (such as SQL Server or cloud databases like Azure/Google) using native connectors or JDBC drivers
Expertise in configuring Remote Data Connectivity using the OAC Data Gateway for secure, live data access to on-premise data sources
Experience with connection types, network security groups (NSGs), and private access channels within OCI
Ability to design solutions that blend data from various sources (Fusion SaaS, external databases, flat files) into cohesive datasets and visualizations
Expertise in establishing and enforcing robust data security and governance frameworks across Oracle Analytics Cloud and Oracle Fusion ecosystem
Implementing fine-grained access controls within OAC, managing application roles, catalog permissions, and data filters
Configuring security settings to ensure alignment with Oracle Fusion Applications security model
Utilizing data masking and encryption best practices to protect sensitive or personally identifiable information (PII/PHI)
Defining and documenting governance policies for OAC content lifecycle management, data lineage, and audit logging to meet regulatory requirements (e.g., SOX, GDPR)
Experience with monitoring data usage, access patterns, and policy compliance using OAC and OCI audit logs
Ability to leverage OCI compartment management for logical isolation of OAC instances and data resources
Leverage OAC 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
Integrate and deploy Machine Learning models developed using tools like Oracle Machine Learning (OML) or Python/R into OAC dashboards
Qualification
Required
Bachelor's degree in Computer Science, Information Technology, or a related field
Minimum of 6-8 years in BI and analytics, with at least 3-4 years specifically with Oracle Analytics Cloud (OAC)
Must be a U.S. Citizen. NO EXCEPTIONS
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
Relevant Oracle certifications are highly valued, such as Oracle Analytics Cloud Certified Professional
Ability to work collaboratively in a team environment while also being self-motivated
Extensive experience connecting OAC to Oracle Fusion Cloud Applications (ERP/HCM) to access operational data in real-time
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 complex or pixel-perfect reporting requirements
Experience with BI Cloud Connector (BICC) for extracting data from Fusion SaaS into a data warehouse
Understanding of the shared security model with OAC and 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
Monitor and optimize performance of OAC dashboards, reports, and data models by fine-tuning queries, managing data caching, and implementing best practices
Troubleshoot and resolve performance issues using tools such as SQL Tuning Advisor and Explain Plan analysis
Design and implement efficient data loading and extraction strategies for large-scale data solutions
Advise on data partitioning, indexing, and materialized views to improve query execution speed and system responsiveness
Hands-on experience connecting OAC to external, non-Oracle databases (such as SQL Server or cloud databases like Azure/Google) using native connectors or JDBC drivers
Expertise in configuring Remote Data Connectivity using the OAC Data Gateway for secure, live data access to on-premise data sources
Experience with connection types, network security groups (NSGs), and private access channels within OCI
Ability to design solutions that blend data from various sources (Fusion SaaS, external databases, flat files) into cohesive datasets and visualizations
Expertise in establishing and enforcing robust data security and governance frameworks across Oracle Analytics Cloud and Oracle Fusion ecosystem
Implementing fine-grained access controls within OAC, managing application roles, catalog permissions, and data filters
Configuring security settings to ensure alignment with Oracle Fusion Applications security model
Utilizing data masking and encryption best practices to protect sensitive or personally identifiable information (PII/PHI)
Defining and documenting governance policies for OAC content lifecycle management, data lineage, and audit logging to meet regulatory requirements (e.g., SOX, GDPR)
Experience with monitoring data usage, access patterns, and policy compliance using OAC and OCI audit logs
Ability to leverage OCI compartment management for logical isolation of OAC instances and data resources
Leverage OAC 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
Integrate and deploy Machine Learning models developed using tools like Oracle Machine Learning (OML) or Python/R into OAC dashboards
Benefits
Medical
Dental
Vision
Life insurance
401(k) plan
Paid time off
Company
HukariAscendent
HukariAscendent is an oil & energy company offering nuclear safety and licensing services.
51-200 employees
Funding
Current Stage
Growth StageCompany data provided by crunchbase