| f | Job Description: | f | Job Description: |
| t | The Oracle SCM Reporting Analyst is responsible for designing, developing, and maintaining reports a | t | Certain terms and conditions of employment for this position, including the rate of pay, benefits, e |
| nd dashboards across Oracle Cloud ERP (and related systems) to support business decision-making. Thi | | tc., are currently subject to negotiation with the appropriate union. The Oracle SCM Reporting Analy |
| s role partners with functional teams and business stakeholders to translate requirements into effec | | st is responsible for designing, developing, and maintaining reports and dashboards across Oracle Cl |
| tive reporting solutions, ensuring data accuracy, consistency, and usability across the enterprise. | | oud ERP (and related systems) to support business decision-making. This role partners with functiona |
| The analyst will leverage Oracle reporting tools (OTBI, BI Cloud Connector, BI Publisher, Smartview | | l teams and business stakeholders to translate requirements into effective reporting solutions, ensu |
| , Narrative Reporting, Fusion Data Intelligence) and other enterprise analytics platforms to meet bo | | ring data accuracy, consistency, and usability across the enterprise. The analyst will leverage Orac |
| th operational and strategic reporting needs. The ideal candidate will have a strong understanding o | | le reporting tools (OTBI, BI Cloud Connector, BI Publisher, Smartview, Narrative Reporting, Fusion |
| f Oracle ERP data structures, functional business processes, and analytics best practices, coupled w | | Data Intelligence) and other enterprise analytics platforms to meet both operational and strategic r |
| ith technical skills in SQL, data modeling, and visualization. Collaborates with Business Systems An | | eporting needs. The ideal candidate will have a strong understanding of Oracle ERP data structures, |
| alysts (BSAs), technical integration teams, and data warehouse developers to ensure consistent and i | | functional business processes, and analytics best practices, coupled with technical skills in SQL, d |
| ntegrated reporting across systems. Provide ad hoc data analysis and support to business partners du | | ata modeling, and visualization. Collaborates with Business Systems Analysts (BSAs), technical integ |
| ring month-end, year-end, and key operational cycles. This position includes regular onsite work, ty | | ration teams, and data warehouse developers to ensure consistent and integrated reporting across sys |
| pically 1-3 days per month. The exact schedule and frequency may be adjusted as needed to meet depar | | tems. Provide ad hoc data analysis and support to business partners during month-end, year-end, and |
| tmental and operational demands. | | key operational cycles. This position includes regular onsite work, typically 1-3 days per month. Th |
| | | e exact schedule and frequency may be adjusted as needed to meet departmental and operational demand |
| | | s. |
| | | |
| Qualifications: | | Qualifications: |
| REQUIRED QUALIFICATIONS - Bachelor's degree in a related area and/or equivalent experience/training. | | REQUIRED QUALIFICATIONS - Bachelor's degree in a related area and/or equivalent experience/training. |
| - 3+ years of experience as a Reporting Analyst or equivalent role supporting Oracle Cloud Supply C | | - 3+ years of experience as a Reporting Analyst or equivalent role supporting Oracle Cloud Supply C |
| hain Management, Human Capital Management, or Financials - 3+ years of experience in relational data | | hain Management, Human Capital Management, or Financials - 3+ years of experience in relational data |
| base, SQL, or system development life-cycle project; and/or equivalent experience/training. - Profic | | base, SQL, or system development life-cycle project; and/or equivalent experience/training. - Profic |
| ient in SQL and data analysis - Knowledge of Oracle Fusion Analytics Warehouse (FAW) or Oracle Analy | | ient in SQL and data analysis - Knowledge of Oracle Fusion Analytics Warehouse (FAW) or Oracle Analy |
| tics Cloud - (OAC) or EPM reporting. - Advanced knowledge of Oracle reporting tools, BI Publisher, O | | tics Cloud - (OAC) or EPM reporting. - Advanced knowledge of Oracle reporting tools, BI Publisher, O |
| TBI, practices, and standards. - Ability to prepare complex data models unassisted. - Ability to und | | TBI, practices, and standards. - Ability to prepare complex data models unassisted. - Ability to und |
| erstand and model complex knowledge-intensive processes Oracle ERP data structures, and business pro | | erstand and model complex knowledge-intensive processes Oracle ERP data structures, and business pro |
| cesses (Finance, SCM, Research or HCM) - Ability to translate business needs into technical reportin | | cesses (Finance, SCM, Research or HCM) - Ability to translate business needs into technical reportin |
| g requirements. - Familiarity with highly complex data quality and governance issues and requirement | | g requirements. - Familiarity with highly complex data quality and governance issues and requirement |
| s. - Demonstrated effective communication and interpersonal skills. Demonstrated ability to communic | | s. - Demonstrated effective communication and interpersonal skills. Demonstrated ability to communic |
| ate technical information to technical and non-technical personnel at various levels in the organiza | | ate technical information to technical and non-technical personnel at various levels in the organiza |
| tion. Interpersonal and communication skills to work with both technical and non- technical personne | | tion. Interpersonal and communication skills to work with both technical and non- technical personne |
| l at various levels in the organization. - Demonstrated advanced problem-solving skills. Able to lea | | l at various levels in the organization. - Demonstrated advanced problem-solving skills. Able to lea |
| rn effectively and meet deadlines. PREFERRED QUALIFICATIONS - Familiarity with highly complex logica | | rn effectively and meet deadlines. PREFERRED QUALIFICATIONS - Familiarity with highly complex logica |
| l data design and data mapping or data conversion specially related to higher education or healthcar | | l data design and data mapping or data conversion specially related to higher education or healthcar |
| e reporting requirements. - 1+ year of experience in an organization comparable to UCSF in terms of | | e 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 supply chain, hu | | budget, size, complexity, scope of operation, and accounting systems - Knowledge of supply chain, hu |
| man capital management, or finance systems and processes within a healthcare environment - Certifica | | man capital management, or finance systems and processes within a healthcare environment - Certifica |
| tion:- Oracle Certifications - Lean Six Sigma Black Belt (LSSBB) - Project Management Professional ( | | tion:- Oracle Certifications - Lean Six Sigma Black Belt (LSSBB) - Project Management Professional ( |
| PMP) - Certified Business Analysis Professional (CBAP) | | PMP) - Certified Business Analysis Professional (CBAP) |