We are seeking a highly skilled Oracle Fusion Reporting & Analytics Specialist with expertise in Oracle Analytics Cloud (OAC), Oracle Fusion Cloud Applications (ERP/HCM) and Oracle Cloud integrations. The ideal candidate will have extensive experience developing and maintaining BI Publisher reports, modifying customer invoice templates etc.
The candidate should possess strong experience troubleshooting Oracle Fusion ERP–EPM integrations, managing scheduled reports and job processes, and resolving external vendor integration issues including banking and tax integrations.
The successful candidate will demonstrate advanced SQL and PL/SQL expertise, hands-on experience connecting OAC to Oracle and non-Oracle data sources, and a deep understanding of Oracle Fusion security models, analytics architecture, and data extraction frameworks such as BICC.
ResponsibilitiesKey Responsibilities
- Design and develop BI Publisher (BIP) reports within Oracle Fusion
- Modify and maintain customer invoice templates using BI Publisher
- Build and maintain reports using OTBI and other Oracle reporting tools
- Schedule reports and manage scheduled job processes, ensuring timely and accurate execution
- Utilize BI Connector to enable advanced reporting and data extraction
- Leverage BI Analytics to create dashboards and support management and executive reporting
- Collaborate with stakeholders to gather and translate reporting requirements into scalable solutions
- Ensure data accuracy, performance optimization, and usability of reports
- Develop and manage integrations using Oracle Integration Cloud (OIC)
- Build and consume APIs (REST/SOAP) for seamless data exchange
- Troubleshoot and resolve issues related to Oracle Cloud integrations
- Diagnose and resolve external vendor integration issues (banking, tax, third-party systems)
- Troubleshoot Fusion ERP ↔ EPM integrations
- Maintain documentation for reporting and integration solutions
Responsible for environment management, security, and lifecycle management tasks.
Demonstrates extensive experience connecting OAC to Oracle Fusion Cloud Applications (ERP/HCM) to access operational data in real-time.
Demonstrates hands-on experience in connecting OAC to a variety of external, non-Oracle databases (such as SQL Server or other cloud databases like Azure) using native connectors.
Required Skills & Qualifications
Bachelor’s degree in a computer related field or equivalent computer related experience with at least 5 years of relevant, progressively responsible experience.
Minimum of 6-8 years in BI and analytics, with at least 3-4 years specifically with Oracle Analytics Cloud (OAC).
- Strong hands-on experience in BI Publisher (BIP) and OTBI report development
- Proven experience modifying customer invoice templates in Oracle Fusion
- Experience monitoring and troubleshooting scheduled jobs and batch processes
- Experience with BI Connector and enabling downstream analytics
- Ability to leverage BI Analytics for management reporting
- Solid experience with Oracle Cloud Integrations (OIC)
- Hands-on experience troubleshooting Fusion ERP ↔ EPM integrations
- Experience resolving external vendor integration issues (banking, tax, etc.)
- Good understanding of Oracle Fusion data models, especially in Finance (AR/Invoicing)
- Experience with SQL, XML, and data templates
- Familiarity with REST/SOAP web services
- Hands-on experience with Oracle Visual Builder Cloud Service (VBCS) for extending and customizing Redwood UI pages, including creation of custom components, business rules, and integrations with Fusion applications
- Experience in implementing Redwood UX enhancements and page-level customizations aligned with Oracle’s modern UI framework
- Familiarity with AI-driven automation and AI Agents within Oracle ecosystem, including leveraging AI for use cases such as intelligent workflows, predictive analytics, and conversational experiences
- Exposure to integrating AI capabilities with Oracle Fusion applications to enhance user experience, decision-making, and operational efficiency
Nice to Have
- Strong analytical and problem-solving skills
- Strong communication and stakeholder management skills
Relevant Oracle certifications are highly valued, such as Oracle Analytics Cloud Certified Professional.
Skills Required
- Bachelor's degree in a computer related field or equivalent experience with at least 5 years relevant experience
- 6-8 years in BI and analytics with 3-4 years specifically with Oracle Analytics Cloud (OAC)
- Strong hands-on experience in BI Publisher (BIP) and OTBI report development
- Proven experience modifying customer invoice templates in Oracle Fusion
- Experience monitoring and troubleshooting scheduled jobs and batch processes
- Experience with BI Connector and enabling downstream analytics
- Ability to leverage BI Analytics for management and executive reporting
- Solid experience with Oracle Cloud Integrations (OIC)
- Hands-on experience troubleshooting Fusion ERP ↔ EPM integrations
- Experience resolving external vendor integration issues (banking, tax, third-party systems)
- Good understanding of Oracle Fusion data models, especially Finance (AR/Invoicing)
- Advanced SQL and PL/SQL expertise
- Experience with SQL, XML, and data templates
- Familiarity with REST and SOAP web services and building/consuming APIs
- Hands-on experience with Oracle Visual Builder Cloud Service (VBCS) for UI extensions and custom components
- Experience implementing Redwood UX enhancements and page-level customizations
- Familiarity with AI-driven automation and AI Agents within the Oracle ecosystem and integrating AI capabilities with Fusion
- Relevant Oracle certifications (e.g., Oracle Analytics Cloud Certified Professional)
- Strong analytical, communication, and stakeholder management skills
Cytel Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Cytel and has not been reviewed or approved by Cytel.
-
Healthcare Strength — Health coverage is described as comprehensive, spanning medical, dental, vision, life and disability, with FSAs/HSAs also available. Plan quality is often characterized as good to excellent, which lifts the perceived value of the overall package.
-
Retirement Support — A 401(k) with employer match is consistently part of the benefits package. The plan is also characterized as well managed, contributing to a sense of baseline retirement support.
-
Fair & Transparent Compensation — Overall pay is characterized as decent-to-good and broadly competitive in parts of the business, with stronger alignment noted in senior technical tracks like biostatistics and programming. The total package is often framed as respectable rather than premium.
Cytel Insights
What We Do
Cytel enables decision-makers in the life sciences to unlock the full potential of their products. From navigating uncertainty to proving value, Cytel’s 30 years of global expertise in consulting, data-driven analytics, and industry-leading software helps biotech and pharmaceutical companies transform intelligence into confident decisions. We have an uncompromising commitment to scientific rigor and high standards of operational excellence, which are channeled through our locations in North America, Europe, the United Kingdom, and Asia. Together, we enable our clients to deliver the therapies that propel humanity forward. Cytel employs a range of data science tools from biostatistics to machine learning to help executives in the life-sciences to make confident decisions powered by data. We are probably best known for being leaders in the field of adaptive clinical trial design, a subset of trial design that uses interim looks to enhance the patient safety and commercial value of pharmaceutical products. We also have specialists in Bayesian statistics, real world evidence, artificial intelligence, health economics, and a number of other research fields to ensure that academic and scientific findings can have impact on industry quickly and seamlessly. www.cytel.com
