Designs, develops, and maintains Oracle Cloud ERP reports, dashboards, data models, extracts, and BI Publisher templates. Translates business requirements into accurate, user-friendly reporting solutions, supports data validation and reconciliation, manages report security, and provides ad hoc analysis, training, and documentation. Collaborates with Finance, HR, Supply Chain, IT, integration, and data warehouse teams. Participates in testing, upgrades, legacy-reporting transitions, quarterly release reviews, automation, and visualization improvements.
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 SCM 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, Smartview, Narrative Reporting, Fusion Data Intelligence) 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.
Responsibilities%
of time
Essential Function (Yes/No)
Key Responsibilities
(To be completed by Supervisor)
25
YesDesign, develop, and maintain reports, dashboards, and data extracts across Oracle Cloud ERP modules (e.g., HCM, Financials, Projects, Supply Chain) 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
YesBuild 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
YesSupport 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
YesCollaborate 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
YesManage report security, roles, and data access in compliance with organizational standards5
YesAssist in the transition from legacy reporting tools to Oracle Cloud reporting solutions10
YesProvide user training, documentation, and ongoing support for reporting tools and dashboards10
YesParticipate 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
YesIdentify 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%.)QualificationsREQUIRED 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 Chain Management, Human Capital Management, or Financials
- 3+ years of experience in relational database, SQL, or system development life-cycle project; and/or equivalent experience/training.
- Proficient in SQL and data analysis
- Knowledge of Oracle Fusion Analytics Warehouse (FAW) or Oracle Analytics Cloud
- (OAC) or EPM reporting.
- Advanced knowledge of Oracle reporting tools, BI Publisher, 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 (Finance, SCM, Research or HCM)
- 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
- 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 supply chain, human capital management, or finance systems and processes within a healthcare environment
- Certification:
- Oracle Certifications
- Lean Six Sigma Black Belt (LSSBB)
- Project Management Professional (PMP)
- Certified Business Analysis Professional (CBAP)
About UCSF
The University of California, San Francisco (UCSF) is a leading university dedicated to promoting health worldwide through advanced biomedical research, graduate-level education in the life sciences and health professions, and excellence in patient care. It is the only campus in the 10-campus UC system dedicated exclusively to the health sciences. We bring together the world’s leading experts in nearly every area of health. We are home to five Nobel laureates who have advanced the understanding of cancer, neurodegenerative diseases, aging and stem cells.
Pride Values
UCSF is a diverse community made of people with many skills and talents. We seek candidates whose work experience or community service has prepared them to contribute to our commitment to professionalism, respect, integrity, diversity and excellence – also known as our PRIDE values.
In addition to our PRIDE values, UCSF is committed to equity – both in how we deliver care as well as our workforce. We are committed to building a broadly diverse community, nurturing a culture that is welcoming and supportive, and engaging diverse ideas for the provision of culturally competent education, discovery, and patient care. Additional information about UCSF is available here.
Join us to find a rewarding career contributing to improving healthcare worldwide.
Equal Employment Opportunity
The University of California is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, age, protected veteran status, or other protected status under state or federal law.
Salary Information
The final salary and offer components are subject to additional approvals based on UC policy.
Your placement within the salary range is dependent on a number of factors including your work experience and internal equity within this position classification at UCSF. For positions that are represented by a labor union, placement within the salary range will be guided by the rules in the collective bargaining agreement.
To learn more about the benefits of working at UCSF, including total compensation, please visit: https://ucnet.universityofcalifornia.edu/compensation-and-benefits/index.html
University of California, San Francisco San Francisco, California, USA Office
San Francisco, CA, United States
University of California, San Francisco Daly City, California, USA Office
Daly City, United States
University of California, San Francisco Oakland, California, USA Office
Oakland, United States
University of California, San Francisco Richmond, California, USA Office
Richmond, United States
University of California, San Francisco San Rafael, California, USA Office
San Rafael, United States
University of California, San Francisco South San Francisco, California, USA Office
South San Francisco, United States
Similar Jobs
Artificial Intelligence • Healthtech • Machine Learning • Natural Language Processing • Biotech • Pharmaceutical
Supports Pfizer CentreOne’s inside sales and marketing activities by reviewing and routing marketing-qualified leads, executing outreach sequences, documenting activity in Salesforce, and assisting with campaigns, content, meetings, reporting, and marketing projects. The role develops commercial expertise across marketing, inside sales, and business development while progressing leads toward initial meetings and BD handoff.
Top Skills:
HubspotExcelMicrosoft OutlookMicrosoft PowerpointMicrosoft SharepointMicrosoft TeamsMicrosoft WordSalesforce
Big Data • Cloud • Software • Database
Leads strategic, cross-functional security programs with executive visibility and complex dependencies. Establishes standardized program-management practices, roadmaps, metrics, risk management, decision processes, and reporting across the Global Security Office. Drives alignment, resolves trade-offs, improves execution through automation and AI-enabled workflows, and connects security initiatives to company goals, customer trust, resilience, and business outcomes.
Top Skills:
Cloud SecurityConfluenceData PlatformsEnterprise ArchitectureGenerative AiGoogle WorkspaceIamInfrastructure SecurityJIRAProduct SecurityScriptingSecure SdlcThreat ModelingVulnerability Management
Artificial Intelligence • Healthtech • Machine Learning • Natural Language Processing • Biotech • Pharmaceutical
Leads go-to-market excellence for specialty-care patient engagement programs across pharmaceutical brands. Translates strategy into launch plans, targeting models, channel and field execution, compliant content operations, training, governance, and performance dashboards. Partners with Marketing, Patient Solutions, Legal, Compliance, Medical, Sales, and other functions to improve program productivity, accelerate review cycles, and establish data-backed feedback loops. Requires significant pharmaceutical experience, matrix leadership, strategic planning, and complex program-management expertise.
Top Skills:
AmplifyCentris
What you need to know about the San Francisco Tech Scene
San Francisco and the surrounding Bay Area attracts more startup funding than any other region in the world. Home to Stanford University and UC Berkeley, leading VC firms and several of the world’s most valuable companies, the Bay Area is the place to go for anyone looking to make it big in the tech industry. That said, San Francisco has a lot to offer beyond technology thanks to a thriving art and music scene, excellent food and a short drive to several of the country’s most beautiful recreational areas.
Key Facts About San Francisco Tech
- Number of Tech Workers: 365,500; 13.9% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Google, Apple, Salesforce, Meta
- Key Industries: Artificial intelligence, cloud computing, fintech, consumer technology, software
- Funding Landscape: $50.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Sequoia Capital, Andreessen Horowitz, Bessemer Venture Partners, Greylock Partners, Khosla Ventures, Kleiner Perkins
- Research Centers and Universities: Stanford University; University of California, Berkeley; University of San Francisco; Santa Clara University; Ames Research Center; Center for AI Safety; California Institute for Regenerative Medicine
