UCSF

Public health sciences university in San Francisco

Oracle Cloud Data Systems Analyst

Business IntelligenceConfirmed live in the last 24 hours

Full-timeSan Francisco, CA, USA$118k - $185k

About the Job

Requirements

A bachelor's degree in a related area, or equivalent experience or training.
At least 3 years of experience with relational databases, SQL, or system development life-cycle projects, or equivalent experience or training.
At least 3 years of experience as a Reporting Analyst or equivalent role supporting Oracle Cloud Supply Chain Management, Human Capital Management, or Financials.
Advanced knowledge of Oracle reporting tools, BI Publisher, or OTBI practices and standards.
Ability to prepare complex data models independently.
Ability to understand and model complex knowledge-intensive processes, Oracle ERP data structures, and HCM business processes.
Proficiency in SQL and data analysis.
Ability to translate business needs into technical reporting requirements.
Familiarity with highly complex data quality and governance issues and requirements.
Ability to communicate technical information to technical and non-technical personnel at various organizational levels.
Advanced problem-solving skills and ability to learn effectively and meet deadlines.

Responsibilities

Design, develop, and maintain reports, dashboards, and data extracts across Oracle Cloud HCM to meet operational and analytical needs.
Build and optimize BI Publisher data models and templates in RTF, Excel, and PDF formats to support formatted reports, data extracts, and system-to-system integrations.
Build and maintain data models, BI Publisher templates, and OTBI analyses for operational and strategic reporting needs.
Maintain documentation for reporting specifications, data definitions, and logic transformations.
Support report and dashboard data validation, reconciliation, and troubleshooting.
Provide ad hoc reporting and data analysis support to functional teams and leadership.
Collaborate with Finance, HR, Supply Chain, and IT teams to ensure data integrity and consistency across reporting platforms.
Develop shared reports, dashboards, and training materials to promote self-service analytics for business users.
Manage report security, roles, and data access in compliance with organizational standards.
Assist in transitioning from legacy reporting tools to Oracle Cloud reporting solutions.
Provide user training, documentation, and ongoing support for reporting tools and dashboards.
Participate in testing, upgrades, and system enhancement projects related to Oracle ERP.
Monitor Oracle quarterly releases for reporting capabilities or changes that affect existing reports.
Identify opportunities for automation, standardization, and improved data visualization.
Collaborate with Business Systems Analysts, technical integration teams, and data warehouse developers to ensure consistent, integrated reporting across systems.
Provide ad hoc data analysis and support to business partners during month-end, year-end, and key operational cycles.

Desired Qualifications

Knowledge of Oracle Fusion Analytics Warehouse, Oracle Analytics Cloud, or EPM reporting.
Familiarity with highly complex logical data design and data mapping or data conversion, especially for higher education or healthcare reporting requirements.
At least 1 year of experience in an organization comparable to UCSF in budget, size, complexity, scope of operation, and accounting systems.
Knowledge of human capital management within a healthcare environment.
Advanced knowledge of PeopleSoft 9.2.
Oracle certification(s).
Lean Six Sigma Black Belt certification.
Project Management Professional certification.
Certified Business Analysis Professional certification.

Certain terms and conditions of employment for this position, including the rate of pay, benefits, etc., are currently subject to negotiation with the appropriate union.

The Oracle Reporting Analyst is responsible for designing, developing, and maintaining reports and dashboards across Oracle Cloud ERP (and related systems) to support business decision-making. This role partners with functional teams and business stakeholders to translate requirements into effective reporting solutions, ensuring data accuracy, consistency, and usability across the enterprise.

The analyst will leverage Oracle reporting tools (OTBI, BI Cloud Connector, BI Publisher, Fusion Analytics Warehouse) and other enterprise analytics platforms to meet both operational and strategic reporting needs. The ideal candidate will have a strong understanding of Oracle ERP data structures, functional business processes, and analytics best practices, coupled with technical skills in SQL, data modeling, and visualization.

Collaborates with Business Systems Analysts (BSAs), technical integration teams, and data warehouse developers to ensure consistent and integrated reporting across systems.Provide ad hoc data analysis and support to business partners during month-end, year-end, and key operational cycles.

This position includes regular onsite work, typically 1-3 days per month. The exact schedule and frequency may be adjusted as needed to meet departmental and operational demands.

Department Overview

The Business Informatics & Analysis team is responsible for delivering functional expertise, business process analysis, and application support across the enterprise’s Oracle Cloud ERP ecosystem. This team partners with business stakeholders, technical and cross-functional teams to ensure that Oracle ERP modules—such as Finance, Procurement, Projects,Research, Supply Chain, and Human Capital Management (HCM)—are effectively configured, optimized, and aligned with organizational objectives.

The team provides both strategic and operational support, including requirements gathering, solution design, process improvement, system configuration, testing, reporting, and training. Their work ensures that Oracle Cloud ERP and the boundary systems it integrates with enable accurate, efficient, and scalable business operations.

REQUIRED QUALIFICATIONS

Bachelor's degree in a related area and/or equivalent experience/training.
3+ years of experience in relational database, SQL, or system development life-cycle project; and/or equivalent experience/training.
3+ years of experience as a Reporting Analyst or equivalent role supporting Oracle Cloud Supply Chain Management, Human Capital Management, or Financials
Advanced knowledge of Oracle reporting tools, BI Publisher, or OTBI practices and standards.
Ability to prepare complex data models unassisted.
Ability to understand and model complex knowledge-intensive processes Oracle ERP data structures and business processes (HCM)
Proficient in SQL and data analysis
Ability to translate business needs into technical reporting requirements.
Familiarity with highly complex data quality and governance issues and requirements.
Demonstrated effective communication and interpersonal skills. Demonstrated ability to communicate technical information to technical and non-technical personnel at various levels in the organization. Interpersonal and communication skills to work with both technical and non- technical personnel at various levels in the organization.
Demonstrated advanced problem-solving skills. Able to learn effectively and meet deadlines.

PREFERRED QUALIFICATIONS

Knowledge of Oracle Fusion Analytics Warehouse (FAW) or Oracle Analytics Cloud
(OAC) or EPM reporting.
Familiarity with highly complex logical data design and data mapping or data conversion specially related to higher education or healthcare reporting requirements.
1+ year of experience in an organization comparable to UCSF in terms of budget, size, complexity, scope of operation, and accounting systems
Knowledge of human capital management within a healthcare environment
Advanced knowledge of PeopleSoft 9.2
CERTIFICATIONS
- Oracle Certifications
- Lean Six Sigma Black Belt (LSSBB)
- Project Management Professional (PMP)
- Certified Business Analysis Professional (CBAP)

% of time	Essential Function (Yes/No)	Key Responsibilities (To be completed by Supervisor)
25	Yes	Design, develop, and maintain reports, dashboards, and data extracts across Oracle Cloud HCM to meet operational and analytical needs. Build and optimize BI Publisher data models and templates (RTF, Excel, PDF) to support formatted reports, data extracts, and system-to-system integrations.
20	Yes	Build and maintain data models, BI Publisher templates, and OTBI (Oracle Transactional Business Intelligence)analyses to support operational and strategic reporting needs. Maintain documentation for reporting specifications, data definitions, and logic transformations to support transparency and continuity.
10	Yes	Support data validation, reconciliation, and troubleshooting for reports and dashboards. Provide ad hoc reporting and data analysis support for functional teams and leadership to enable data-driven decision-making.
10	Yes	Collaborate with cross-functional teams (Finance, HR, Supply Chain, IT) to ensure data integrity and consistency across reporting platforms. Promote self-service analytics by developing shared reports, dashboards, and training materials that empower business users.
5	Yes	Manage report security, roles, and data access in compliance with organizational standards
5	Yes	Assist in the transition from legacy reporting tools to Oracle Cloud reporting solutions
10	Yes	Provide user training, documentation, and ongoing support for reporting tools and dashboards
10	Yes	Participate in testing, upgrades, and system enhancement projects related to Oracle ERP. Monitor Oracle quarterly releases for new reporting capabilities or changes affecting existing reports.
5	Yes	Identify opportunities for automation, standardization, and improved data visualization.
100%		(To update total %, enter the amount of time in whole numbers (without the % symbol - e.g., 15, 20) then highlight the total sum (e.g., 1%) at the bottom of the column and press F9. The total sum should add up to 100%.)

Budgeted Job Salary Range: 118,000 - 185,000

About the Company

UCSF

Public health sciences university in San Francisco

UC San Francisco is a public research university in San Francisco focused solely on health sciences, combining professional education with biomedical research and patient care. Its schools of dentistry, medicine, nursing and pharmacy train clinicians and scientists, while teams investigate cancer, immunology, genomics and neuroscience. UCSF Medical Center and Benioff Children's Hospitals connect clinical care with faculty research and training, and university clinics serve patients across Northern California. Founded in 1864, UCSF is the University of California campus dedicated to graduate and professional education and biomedical research, based in San Francisco.

Company size: 10,001+
Company stage: Not listed
Total funding: Not listed
Headquarters: Not listed
Founded: 1864

Recently Posted Jobs

Explore more opportunities at UCSF

See more jobs