Oracle Cloud Reports Developer

Stanfordlivetickets; Redwood City (CA); On-site; USD 153,000 - 168,000; Full time

Benefits offered by this job

Health benefits

Tuition reimbursement

Commuter benefits

Job summary

Stanford University IT is seeking an Oracle Cloud Reports Developer to join the Data Analytics & Reporting team. The role focuses on OTBI, BI Publisher, and Fusion Data Intelligence to deliver scalable, secure reports and dashboards that support enterprise decision making.

You will translate business needs into technical specifications, build data models and self-service visuals, and collaborate with stakeholders while ensuring data governance and compliance across systems.

Qualifications

• Bachelor’s degree with seven years of relevant experience in Computer Science, Information Systems, or related field.
• 3+ years of Oracle Cloud Applications (HCM, EBS) experience.
• 5+ years of experience with Oracle databases and Oracle applications.
• Experience with Fusion Data Intelligence (FDI) / Fusion Analytics Warehouse (FAW).
• Experience with data visualization tools (Tableau, OAS DV).
• REST APIs / data integration familiarity.

Responsibilities

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

Skills

OTBI

BI Publisher

Fusion Data Intelligence

SQL

Data modeling

REST APIs

Education

Bachelor’s degree in Computer Science or related field

Tools

Tableau

OAS DV

REST APIs

Job description

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.

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 (https://cardinalatwork.stanford.edu/benefits-rewards) 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.

Notice to Applicants

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 accommodation to any employee with a disability who requires accommodation to perform the essential functions of their job.

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.

Why work at Stanford

World-changing work in a culture of continuous learning

An inspiring community that values collaboration

High-quality health and wellness benefits that put you and your family first

Access to world-class education and career development, with tuition reimbursement, training assistance, and more

Benefits that support you, and your future

18+ PTO days per year

Health benefits start when you start

Flexible work options

$6000+ annual tuition and training assistance

403(b) plan

Mental health and wellness programs

Free and discounted commuter transportation

Applies to regular full-time positions.