About the company
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.
Responsibilities
- Execute the migration of analytics content, configurations, and related components from Oracle Analytics Server to Oracle Analytics Cloud
- Export Repository Definition (RPD) repositories into BAR files and import them into Oracle Analytics Cloud, validating configurations and resolving migration-related issues
- Build, update, and troubleshoot semantic models and repository configurations
- Configure and maintain OAC security settings, user access, permissions, and environment configurations
- Write, analyze, troubleshoot, and optimize SQL queries to support analytics workloads
- Investigate and troubleshoot connectivity problems, migration errors, performance bottlenecks, semantic model inconsistencies, and environment configuration issues
- Conduct functional checks, data validation, and testing to confirm migrated reports, models, and configurations operate as expected
- Apply knowledge of Oracle Cloud Infrastructure (OCI) and ETL technologies to support migration dependencies
- Maintain clear technical documentation covering migration steps, environment configurations, issues, and resolutions
Requirements
- Three to five years of experience in Oracle Analytics development, administration, migration, or a closely related technical discipline
- Demonstrated hands-on experience with Oracle Analytics Cloud and Oracle Analytics Server, including OAS-to-OAC migration projects
- Practical experience exporting RPD repositories to BAR files and importing them into Oracle Analytics Cloud
- Strong knowledge of semantic model development, repository management, OAC administration, environment configuration, and analytics content migration
- Strong SQL development and troubleshooting skills, including query analysis and performance optimization
- Familiarity with Oracle Cloud Infrastructure (OCI), analytics migration methodologies, testing and validation practices, and ETL tools such as Oracle Data Integrator (ODI) or ODI-C
- Strong analytical and troubleshooting skills
- Experience validating migrated reports, semantic models, configurations, and data
- Ability to maintain accurate technical records and document troubleshooting activities
- Self-motivation, attention to detail, and ability to manage priorities with minimal supervision
- Willingness and ability to work as a 1099 independent contractor for the full six-month engagement
- Ability to successfully complete all client-required security requirements
Conditions
- Competitive hourly compensation: $55–$70 per hour, depending on experience, education, and certifications
- Fully remote engagement performed from within the United States
- Six-month consulting opportunity focused on a specialized Oracle Analytics Cloud migration project