Only the job description changed.
| Previous Job Description | Current Job Description | ||||
|---|---|---|---|---|---|
| n | 1 | Job Description: | n | 1 | Certain terms and conditions of employment for this position, including the rate of pay, benefits, e |
| > | tc., are currently subject to negotiation with the appropriate union. | ||||
| 2 | Certain terms and conditions of employment for this position, including the rate of pay, benefits, e | ||||
| > | tc., are currently subject to negotiation with the appropriate union. The Oracle Reporting Analyst i | ||||
| > | s 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 te | ||||
| > | ams and business stakeholders to translate requirements into effective reporting solutions, ensuring | ||||
| > | data accuracy, consistency, and usability across the enterprise. The analyst will leverage Oracle r | ||||
| > | eporting tools (OTBI, BI Cloud Connector, BI Publisher, Fusion Analytics Warehouse) and other enterp | ||||
| > | rise 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. Co | ||||
| > | llaborates with Business Systems Analysts (BSAs), technical integration teams, and data warehouse de | ||||
| > | velopers to ensure consistent and integrated reporting across systems.Provide ad hoc data analysis a | ||||
| > | nd support to business partners during month-end, year-end, and key operational cycles. This positio | ||||
| > | n includes regular onsite work, typically 1-3 days per month. The exact schedule and frequency may b | ||||
| > | e adjusted as needed to meet departmental and operational demands. Department Overview The Business | ||||
| > | Informatics & Analysis team is responsible for delivering functional expertise, business process ana | ||||
| > | lysis, and application support across the enterprise’s Oracle Cloud ERP ecosystem. This team partner | ||||
| > | s 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)—a | ||||
| > | re effectively configured, optimized, and aligned with organizational objectives. The team provides | ||||
| > | both strategic and operational support, including requirements gathering, solution design, process i | ||||
| > | mprovement, system configuration, testing, reporting, and training. Their work ensures that Oracle C | ||||
| > | loud ERP and the boundary systems it integrates with enable accurate, efficient, and scalable busin | ||||
| > | ess operations. | ||||
| 3 | 2 | ||||
| t | 4 | Qualifications: | t | 3 | 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 r | ||||
| > | ole partners with functional teams and business stakeholders to translate requirements into effectiv | ||||
| > | e reporting solutions, ensuring data accuracy, consistency, and usability across the enterprise. | ||||
| 5 | REQUIRED QUALIFICATIONS - Bachelor's degree in a related area and/or equivalent experience/training. | 4 | |||
| > | - 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 ro | ||||
| > | le supporting Oracle Cloud Supply Chain Management, Human Capital Management, or Financials - Advanc | ||||
| > | ed 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-intensiv | ||||
| > | e processes Oracle ERP data structures and business processes (HCM) - Proficient in SQL and data ana | ||||
| > | lysis - Ability to translate business needs into technical reporting requirements. - Familiarity wit | ||||
| > | h highly complex data quality and governance issues and requirements. - Demonstrated effective commu | ||||
| > | nication and interpersonal skills. Demonstrated ability to communicate technical information to tech | ||||
| > | nical and non-technical personnel at various levels in the organization. Interpersonal and communica | ||||
| > | tion skills to work with both technical and non- technical personnel at various levels in the organi | ||||
| > | zation. - Demonstrated advanced problem-solving skills. Able to learn effectively and meet deadlines | ||||
| > | . PREFERRED QUALIFICATIONS - Knowledge of Oracle Fusion Analytics Warehouse (FAW) or Oracle Analytic | ||||
| > | s Cloud - (OAC) or EPM reporting. - Familiarity with highly complex logical data design and data map | ||||
| > | ping 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 healthca | ||||
| > | re 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) | ||||
| 5 | The analyst will leverage Oracle reporting tools (OTBI, BI Cloud Connector, BI Publisher, Fusion An | ||||
| > | alytics Warehouse) and other enterprise analytics platforms to meet both operational and strategic r | ||||
| > | eporting 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, d | ||||
| > | ata modeling, and visualization. | ||||
| 6 | |||||
| 7 | 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 analysi | ||||
| > | s and support to business partners during month-end, year-end, and key operational cycles. | ||||
| 8 | |||||
| 9 | This position includes regular onsite work, typically 1-3 days per month. The exact schedule and fr | ||||
| > | equency may be adjusted as needed to meet departmental and operational demands. | ||||
| 10 | |||||
| 11 | Department Overview | ||||
| 12 | |||||
| 13 | The Business Informatics & Analysis team is responsible for delivering functional expertise, busine | ||||
| > | ss process analysis, and application support across the enterprise’s Oracle Cloud ERP ecosystem. Thi | ||||
| > | s team partners with business stakeholders, technical and cross-functional teams to ensure that Orac | ||||
| > | le ERP modules—such as Finance, Procurement, Projects,Research, Supply Chain, and Human Capital Mana | ||||
| > | gement (HCM)—are effectively configured, optimized, and aligned with organizational objectives. | ||||
| 14 | |||||
| 15 | The team provides both strategic and operational support, including requirements gathering, solutio | ||||
| > | n design, process improvement, system configuration, testing, reporting, and training. Their work en | ||||
| > | sures that Oracle Cloud ERP and the boundary systems it integrates with enable accurate, efficient, | ||||
| > | and scalable business operations. | ||||