Oracle Analytics Cloud (OAC) Developer & Administrator (Sr Prin Applications Analyst)

The Information Technology Directorate is looking for an Oracle Analytics Cloud (OAC) Developer & Administrator (Senior Principal Applications Analyst) to join the Enterprise Application Solutions team.

Key Responsibilities

• 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.