IT Business Systems Reporting Analyst
IT Bus Information-Analytics
Job Summary 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.
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. The salary range for this position is $143,900 - $215,800 (Annual Rate). To learn more about the benefits of working at UCSF, including total compensation, please visit: https://ucnet.universityofcalifornia.edu/compensation-and-benefits/index.html
Department Description 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 integrated with,enables accurate, efficient, and scalable business operations.
Required Qualifications
- Bachelor's degree in 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.
- Demonstrated advanced problem-solving skills. Able to learn effectively and meet deadlines.
- 3+ years of experience as a Reporting Analyst or equivalent role supporting Oracle Cloud Supply Chain Management, Human Capital Management, or Financials
- 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)
- Proficient in SQL and data analysis
- Knowledge of Oracle Fusion Analytics Warehouse (FAW) or Oracle Analytics Cloud
- (OAC) or EPM reporting.
- Ability to translate business needs into technical reporting requirements.
- Familiarity with highly complex logical data design and data mapping or data conversion specially related to higher education or healthcare reporting requirements.
- Familiarity with highly complex data quality and governance issues and requirements.
- Advanced knowledge of Oracle reportig tools BI Pubisher, OTBI, practices and standards.
- 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 communications skills to work with both technical and non- technical personnel at various levels in the organization.
Preferred Qualifications
- 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
- Oracle Certifications
- Lean Six Sigma Black Belt (LSSBB)
- Project Management Professional (PMP)
- Certified Business Analysis Professional (CBAP)
About UCSF At UCSF Health, our mission of innovative patient care, advanced technology and pioneering research is redefining what's possible for the patients we serve - a promise we share with the professionals who make up our team.
Consistently ranked among the top 10 hospitals nationwide by U.S. News & World Report - UCSF Health is committed to providing the most rewarding work experience while delivering the best care available anywhere. In an environment that allows for continuous learning and opportunities for professional growth, UCSF Health offers the ideal atmosphere in which to best use your skills and talents.
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 at diversity.ucsf.edu
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.
Job Code and Payroll Title 000599 DATA SYS ANL 4
Job Category Technical & Technologist
Bargaining Unit 99 - Policy-Covered (No Bargaining Unit)
Location San Francisco, CA
Campus Mission Center Building (SF)
Additional Shift Details 5 days, 40 hours / week Flexible - Rotational
|