Oracle Cloud Data & Reporting Analyst — Onsite 1–3 days/mo

University of California, San Francisco; San Francisco (CA); On-site; USD 110,000 - 160,000; Full time

Job summary

University of California, San Francisco (UCSF) is seeking an Oracle Reporting Analyst to design, develop, and maintain reports and dashboards across Oracle Cloud ERP. You will partner with functional teams to translate requirements and ensure data accuracy and usability enterprise-wide.

The role leverages OTBI, BI Publisher, and FAW/OAC tools, with emphasis on data modeling, SQL, and knowledge of ERP data structures (including HCM).

Qualifications

• Bachelor's degree or equivalent experience.
• 3+ years in relational DB, SQL, or SDLC.
• 3+ years as a Reporting Analyst for Oracle Cloud SCM/HCM/Financials.
• Advanced knowledge of Oracle reporting tools (OTBI, BI Publisher).
• Ability to prepare complex data models unassisted.
• Ability to model complex ERP data structures and processes (HCM).
• Proficient in SQL and data analysis.
• Translate business needs into reporting requirements.
• Familiar with data quality and governance issues.
• Effective communication across technical and non-technical teams.
• Strong problem-solving and deadline-driven mindset.

Responsibilities

• Design, develop, and maintain Oracle Cloud ERP reports and dashboards.
• Collaborate with BSAs and stakeholders to translate requirements.
• Ensure data accuracy, consistency, and usability enterprise-wide.
• Provide ad hoc data analysis during month-end/year-end cycles.
• Support reporting across Finance, Procurement, Projects, and HCM.
• Work with integration teams to ensure consistent reporting across systems.

Skills

Bachelor's degree

SQL proficiency

Oracle Cloud Reporting

OTBI/BI Publisher

Data modeling

Business process knowledge (HCM/ERP)

Report design and analytics

Communication skills

Problem solving

Governance & data quality awareness

Education

Bachelor's degree in a related area

Tools

OTBI

BI Publisher

Fusion Analytics Warehouse (FAW)

Oracle Analytics Cloud (OAC)

PeopleSoft 9.2

Job description

University of California, San Francisco (UCSF) is seeking an Oracle Reporting Analyst to design, develop, and maintain reports and dashboards across Oracle Cloud ERP. You will partner with functional teams to translate requirements and ensure data accuracy and usability enterprise-wide.

The role leverages OTBI, BI Publisher, and FAW/OAC tools, with emphasis on data modeling, SQL, and knowledge of ERP data structures (including HCM).