Oracle Cloud Reports Developer

JOB PURPOSE

At Stanford University IT, nothing matters more than helping the Faculty, Students, Researchers and Staff make the institution the best in the world. The organization's 700+ staff are united in a shared purpose to pursue the limitless potential of technology and ingenuity for clients across campus and business units.

We in University IT are seeking a skilled Oracle Cloud Reports Developer to join our dynamic Data Analytics & Reporting team. The ideal candidate will have deep expertise in Oracle Cloud reporting tools such as OTBI (Oracle Transactional Business Intelligence), BI Publisher, and Fusion Data Intelligence (formerly Fusion Analytics Warehouse). This role will be instrumental in designing and developing scalable, secure, and user-friendly reporting solutions to support enterprise decision-making. The position requires close collaboration with functional teams to transform business needs into actionable insights.

CORE DUTIES:

• Design, develop, and maintain reports and dashboards using OTBI, BI Publisher, and Fusion Data Intelligence.
• Collaborate with business stakeholders to gather and translate reporting requirements into technical specifications.
• Build custom data models, subject areas, and data visualizations to support self-service analytics.
• Optimize report performance and troubleshoot issues related to data accuracy and system integration.
• Assist in data validation, quality assurance, and system testing for new releases and patches.
• Provide end-user training and documentation for reports, dashboards, and self-service tools.
• Partner with functional teams to ensure data alignment with business processes.
• Support data governance initiatives and promote best practices for secure, compliant reporting.

Qualifications:

• Hands-on experience with OTBI, BI Publisher, and Fusion Data Intelligence/Fusion Analytics Warehouse.
• Proficiency in writing complex SQL queries and understanding of relational data models.
• Familiarity with Oracle Cloud subject areas and metadata layers.
• Understanding of data security models and role-based access in Oracle Cloud.
• Excellent problem-solving and communication skills.
• Ability to manage multiple priorities in a fast-paced environment.

Here's what you need:

• Experience with BI Publisher
• Experience with HCM Extracts HDLs
• Experience with Spreadsheet loaders Data Mapping
• Experience with Data Transformation
• Experience with Data Modeling
• Experience with Oracle HCM & EBS Cloud modules
• Experience with Oracle Transactional Business Intelligence (OTBI)

EDUCATION:

• Bachelor's degree and seven years of relevant experience in Computer Science, Information Systems, or a related field, or a combination of education and relevant experience.

EXPERIENCE:

• 3+ years of working experience with Oracle Cloud Applications (HCM, EBS is a must)
• 5+ years of experience working with Oracle databases and Oracle applications

PREFERRED QUALIFICATIONS:

• Experience with Fusion Data Intelligence (FDI) / Fusion Analytics Warehouse (FAW) implementation and customization.
• Familiarity with REST APIs, OData connectors, or other integration techniques.
• Experience with data visualization tools (e.g. OAS DV, Tableau) for cross-platform reporting.
• Understanding of Oracle Cloud architecture and update cycles.
• Knowledge of Agile or iterative development methodologies.
• Oracle Cloud certification(s) in reporting, analytics, or related areas.

The expected pay range for this position is $152,535 to $168,000 per annum.

Stanford University provides pay ranges representing its good faith estimate of what the university reasonably expects to pay for a position. The pay offered to a selected candidate will be determined based on factors such as (but not limited to) the scope and responsibilities of the position, the qualifications of the selected candidate, departmental budget availability, internal equity, geographic location and external market pay for comparable jobs.

At Stanford University, base pay represents only one aspect of the comprehensive rewards package. The Cardinal at Work website ( provides detailed information on Stanford's extensive range of benefits and rewards offered to employees. Specifics about the rewards package for this position may be discussed during the hiring process.

The job duties listed are typical examples of work performed by positions in this job classification and are not designed to contain or be interpreted as a comprehensive inventory of all duties, tasks, and responsibilities. Specific duties and responsibilities may vary depending on department or program needs without changing the general nature and scope of the job or level of responsibility. Employees may also perform other duties as assigned.

Consistent with its obligations under the law, the University will provide reasonable accommodations to applicants and employees with disabilities. Applicants requiring a reasonable accommodation for any part of the application or hiring process should contact Stanford University Human Resources by submitting a contact form.

Stanford is an equal employment opportunity and affirmative action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by law.