What are the responsibilities and job description for the IT Business Systems Reporting Analyst position at UCSF Health?
Job Description
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.
Qualifications
Required Qualifications
ABOUT US
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
About The Team
The UCSF IT Business Information & Analytics department is dedicated to transforming data into actionable insights that drive informed decision-making and operational excellence across UCSF�s academic, clinical, and research missions. By providing advanced analytics tools, data visualization solutions, and business intelligence expertise, the department supports UCSF�s ability to optimize workflows, manage resources, and achieve strategic goals. Specializing in data integration, reporting, and predictive analytics, the Business Information & Analytics team delivers scalable solutions that empower UCSF�s leadership, administrators, and operational teams to make data-driven decisions. Whether analyzing financial performance, tracking patient outcomes, or monitoring institutional metrics, the department ensures that users have access to accurate, timely, and meaningful data. The department works closely with stakeholders across UCSF to understand specific needs and tailor solutions to meet diverse business challenges. Through collaboration and consultation, the team designs custom dashboards, builds automated reporting systems, and develops predictive models that enhance efficiency and improve transparency. Security and compliance are integral to the department�s operations. The team ensures that all data handling processes and analytics tools adhere to regulatory standards such as HIPAA, FERPA, and UCSF policies, safeguarding sensitive information while maintaining trust and accountability. Innovation is at the heart of the department�s mission. By leveraging emerging technologies like artificial intelligence, machine learning, and big data platforms, the team continually enhances UCSF�s analytics capabilities to adapt to evolving demands. Through its commitment to service excellence, precision, and innovation, the UCSF IT Business Information & Analytics department empowers UCSF to unlock the full potential of its data, driving efficiency, advancing discoveries, and improving outcomes in patient care, research, and education.
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.
Qualifications
Required Qualifications
- Bachelor’s degree in related area and/or equivalent experience/training
- 3 years of experience with relational databases, SQL, or system development life-cycle projects; and/or equivalent experience/training
- Demonstrated advanced problem-solving skills and ability to learn quickly 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 independently prepare complex data models
- Ability to understand and model complex, knowledge-intensive processes and Oracle ERP data structures (Finance, SCM, Research, or HCM)
- Proficiency in SQL and data analysis
- Knowledge of Oracle Fusion Analytics Warehouse (FAW), Oracle Analytics Cloud (OAC), or Enterprise Performance Management (EPM) reporting
- Ability to translate business needs into technical reporting requirements
- Familiarity with complex logical data design, data mapping, and data conversion, particularly in higher education or healthcare reporting environments
- Familiarity with complex data quality and governance issues and requirements
- Advanced knowledge of Oracle reporting tools (BI Publisher, OTBI), practices, and standards
- Demonstrated effective communication and interpersonal skills, including the ability to communicate technical information to both technical and nontechnical audiences at various organizational levels
- 1 year of experience in an organization comparable to UCSF in budget, size, complexity, scope of operations, 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) certification
- Certified Business Analysis Professional (CBAP) certification
ABOUT US
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
About The Team
The UCSF IT Business Information & Analytics department is dedicated to transforming data into actionable insights that drive informed decision-making and operational excellence across UCSF�s academic, clinical, and research missions. By providing advanced analytics tools, data visualization solutions, and business intelligence expertise, the department supports UCSF�s ability to optimize workflows, manage resources, and achieve strategic goals. Specializing in data integration, reporting, and predictive analytics, the Business Information & Analytics team delivers scalable solutions that empower UCSF�s leadership, administrators, and operational teams to make data-driven decisions. Whether analyzing financial performance, tracking patient outcomes, or monitoring institutional metrics, the department ensures that users have access to accurate, timely, and meaningful data. The department works closely with stakeholders across UCSF to understand specific needs and tailor solutions to meet diverse business challenges. Through collaboration and consultation, the team designs custom dashboards, builds automated reporting systems, and develops predictive models that enhance efficiency and improve transparency. Security and compliance are integral to the department�s operations. The team ensures that all data handling processes and analytics tools adhere to regulatory standards such as HIPAA, FERPA, and UCSF policies, safeguarding sensitive information while maintaining trust and accountability. Innovation is at the heart of the department�s mission. By leveraging emerging technologies like artificial intelligence, machine learning, and big data platforms, the team continually enhances UCSF�s analytics capabilities to adapt to evolving demands. Through its commitment to service excellence, precision, and innovation, the UCSF IT Business Information & Analytics department empowers UCSF to unlock the full potential of its data, driving efficiency, advancing discoveries, and improving outcomes in patient care, research, and education.