Oracle Analytics Cloud (OAC) Developer & Administrator

This position is listed on behalf of a partner company, who manages all applications and next steps. Our partner is looking for an Oracle Analytics Cloud (OAC) Developer & Administrator based in the United States.

We are seeking a hands-on Oracle Analytics Cloud (OAC) Developer and Administrator to support a six-month consulting engagement focused on migrating Oracle Analytics Server (OAS) to the cloud. In this role, you will lead technical migration activities, manage repository configurations, and ensure analytics content transitions smoothly into the target environment. You will leverage your expertise in semantic modeling, BAR-file migration, SQL optimization, and cloud administration to maintain data accuracy, performance, and reliability. Working independently, you will troubleshoot complex technical challenges, configure security settings, validate migrated content, and support testing activities. You will also document migration procedures, configurations, and resolutions to ensure a consistent and well-managed transition. This remote contract opportunity is ideal for an experienced analytics professional who enjoys solving technical problems and delivering reliable, scalable business intelligence solutions.

Accountabilities:

• Manage OAS-to-OAC migrations: Execute the migration of analytics content, configurations, and related components from Oracle Analytics Server to Oracle Analytics Cloud, ensuring a smooth and reliable transition.
• Handle repository migration: Export Repository Definition (RPD) repositories into BAR files and import them into Oracle Analytics Cloud, validating configurations and resolving migration-related issues.
• Develop and maintain semantic models: Build, update, and troubleshoot semantic models and repository configurations to support accurate reporting and consistent analytics.
• Administer the cloud environment: Configure and maintain OAC security settings, user access, permissions, and environment configurations in accordance with project and client requirements.
• Develop and optimize SQL: Write, analyze, troubleshoot, and optimize SQL queries to support analytics workloads, improve query performance, and ensure reliable reporting.
• Resolve technical issues: Investigate and troubleshoot connectivity problems, migration errors, performance bottlenecks, semantic model inconsistencies, and environment configuration issues.
• Validate migrated analytics content: Conduct functional checks, data validation, and testing to confirm that migrated reports, models, and configurations operate as expected.
• Support cloud and data integration activities: Apply relevant knowledge of Oracle Cloud Infrastructure (OCI) and ETL technologies to support migration dependencies and analytics integration requirements.
• Document migration activities: Maintain clear technical documentation covering migration steps, environment configurations, issues encountered, troubleshooting procedures, and resolutions.
• Work independently and meet project milestones: Manage assigned technical tasks, identify risks proactively, and deliver high-quality migration outcomes within the six-month engagement.
• Meet client security requirements: Complete all required security checks and approvals before accessing client systems, environments, or confidential information.

Requirements:

• Relevant professional experience: Three to five years of experience in Oracle Analytics development, administration, migration, or a closely related technical discipline.
• OAC and OAS expertise: Demonstrated hands-on experience with Oracle Analytics Cloud and Oracle Analytics Server, including direct involvement in OAS-to-OAC migration projects.
• Repository migration skills: Practical experience exporting RPD repositories to BAR files and importing those files into Oracle Analytics Cloud, including troubleshooting migration issues.
• Semantic modeling and administration: Strong knowledge of semantic model development, repository management, OAC administration, environment configuration, and analytics content migration.
• SQL proficiency: Strong SQL development and troubleshooting skills, including query analysis, performance optimization, and resolving data-related issues.
• Cloud and integration knowledge: Familiarity with Oracle Cloud Infrastructure (OCI), analytics migration methodologies, testing and validation practices, and ETL tools such as …