Job Summary:
Under the general direction of the UCPath and Timekeeping Systems Manager/Project Manager, the Business Intelligence Specialist position is a key role in the Systems Support Unit of the UCSF Payroll Services Department. This position is the primary specialist who provides support to ensure the successful implementation of changes to and the effective maintenance of our Oracle Cloud ERP for HCM and Finance, our Systemwide HCM system (UCPath), and our UKG Timekeeping system.
This position supports the functional areas of payroll, absence management, general ledger, payroll tax, and timekeeping. This position involves analyzing large-scale business processes and problems; developing solutions involving the use of computer systems, information flow and architecture; creating specifications for systems to meet requirements; validating requirements against needs; designing details of automated systems; developing user interface design; planning and executing unit integration and acceptance testing. The Business Intelligence Specialist resolves a wide range of business process issues of moderate to complex scope. Demonstrates good judgment in selecting methods and techniques to obtain solutions. May lead cross-functional teams to solve complex business or system issues.
Department Overview:
The UCSF Controller's organization delivers full accounting services and related systems for faculty, staff and students, UCSF Foundation, all University departments, and any outside entities who have a business relationship with the University. Services provided include General Ledger, Capital and Cash Accounting, Payroll, Student Loan Billing and Collections, Sponsored Research Accounting, and a Customer Service Center. The office uses sophisticated technology to account and report on UCSF financial activity. The candidate should have a firm understanding of various ERP platforms in a large and complex environment.
Payroll Services is a major unit of the Controller's Office. The Controller's office utilizes various systems to collect, disburse and report on funds. The payroll unit provides payroll collection and management for approximately 2,000 departments, as well as time and attendance and pay processing, systems management, payroll tax and accounting services. The primary function includes the facilitation of timely payments to approximately 40,000 employees per month. The Payroll Accounting unit within Payroll is responsible for reconciliation, reporting and account analysis. Included in the responsibility are the analysis and reconciliation of balance sheet accounts, intercampus billing and clearing, labor ledger and GL financial analysis and customer service for UCPATH.
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
Required Qualifications:
Preferred Qualifications:
%
of time
Essential Function (Yes/No)
Key Responsibilities
(To be completed by Supervisor)
10%Yes
Documentation and Project Management
45%Yes
Application and Operational Support, Data Analysis, Quality Assurance, and Reporting
Applies technical expertise and business analysis concepts to identify, evaluate and define complex systems scope and objectives with an understanding of applicable business practices, processes, systems and industry standards to meet end-user needs. This includes but not limited to:
Provides support for new application features and functions
Troubleshoots non-routine and complex system problems and data discrepancies
Using query tools to perform extracts to identify specific populations to support administrative needs
Responds to ad hoc reporting requests from UCSF department customers, Audit; research and respond to specific data/reporting requests and/or develops specifications for new on demand reports as required.
Generate and execute quality assurance and validation of payroll files
Submit payroll files to UCPath per UCPath payroll processing schedule
Maintain and track payroll files
Create, submit, and track configuration files and BRD for wage implementations, to update/change departmentID tables, update/change department/suspense/edit FAUs, projectID, licenses, EverCheck table, clinical incentive payments, fiscal year-end and calendar year-end rate changes (CBR, VLA, GAEL)
Create, submit, and track various payroll files (one-time payment, EdenRed/Parking files, UDAR, workstudy, time entry files) to UCPath
Demonstrate a proactive approach to identifying opportunities and must have exemplary follow-up and follow through to prompt resolution of identified issues and risks and follow-up and follow through of various documentations
Provide day-to-day support to Payroll Services Staff, answer inquiries, and provide research for key campus personnel and end users. Support role requires understanding of the structure of the data in the system, as well as an understanding of UCSF and UCPath Systemwide policies, workflow, operational processes and practices.
Open cases with UCPath pertaining to Payroll, Absence Management, Commitment Accounting/GL, Timekeeping, as needed
0 45%Yes
Business System Support
0 0 0 0 10%YesOther duties as assigned.0 0 0 0 0 0
%
of time
Essential Function (Yes/No)
Key Responsibilities
(To be completed by Supervisor)
10%Yes
Documentation and Project Management
45%Yes
Application and Operational Support, Data Analysis, Quality Assurance, and Reporting
Applies technical expertise and business analysis concepts to identify, evaluate and define complex systems scope and objectives with an understanding of applicable business practices, processes, systems and industry standards to meet end-user needs. This includes but not limited to:
Provides support for new application features and functions
Troubleshoots non-routine and complex system problems and data discrepancies
Using query tools to perform extracts to identify specific populations to support administrative needs
Responds to ad hoc reporting requests from UCSF department customers, Audit; research and respond to specific data/reporting requests and/or develops specifications for new on demand reports as required.
Generate and execute quality assurance and validation of payroll files
Submit payroll files to UCPath per UCPath payroll processing schedule
Maintain and track payroll files
Create, submit, and track configuration files and BRD for wage implementations, to update/change departmentID tables, update/change department/suspense/edit FAUs, projectID, licenses, EverCheck table, clinical incentive payments, fiscal year-end and calendar year-end rate changes (CBR, VLA, GAEL)
Create, submit, and track various payroll files (one-time payment, EdenRed/Parking files, UDAR, workstudy, time entry files) to UCPath
Demonstrate a proactive approach to identifying opportunities and must have exemplary follow-up and follow through to prompt resolution of identified issues and risks and follow-up and follow through of various documentations
Provide day-to-day support to Payroll Services Staff, answer inquiries, and provide research for key campus personnel and end users. Support role requires understanding of the structure of the data in the system, as well as an understanding of UCSF and UCPath Systemwide policies, workflow, operational processes and practices.
Open cases with UCPath pertaining to Payroll, Absence Management, Commitment Accounting/GL, Timekeeping, as needed
0 45%Yes
Business System Support
0 0 0 0 10%YesOther duties as assigned.0 0 0 0 0 0