Business Intelligence Specialist Payroll & Timekeeping

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. Responsibilities Documentation and Project Management: Consults with department leaders and process owners to gather and clarify data and reporting requirements for highly‑complex business intelligence solutions and analytics. Provides support and training on new applications. Using MS Suite, SmartSheet, Box, MS Teams, ServiceNow or other tracking applications to update and maintain standard operating procedures and processes, business process maps, project documents, various test documents, training materials, and logs for metrics reporting. Serves as primary back‑up for UCPath and Timekeeping Systems Manager during major special projects implementation. Application and Operational Support, Data Analysis, Quality Assurance, and Reporting: 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; researches and responds to specific data/reporting requests and/or develops specifications for new on‑demand reports as required. Generates and executes quality assurance and validation of payroll files. Submits payroll files to UCPath per UCPath payroll processing schedule. Maintains and tracks payroll files. Creates, submits, and tracks 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). Creates, submits, and tracks various payroll files (one‑time payment, EdenRed/Parking files, UDAR, work‑study, time entry files) to UCPath. Demonstrates a proactive approach to identifying opportunities and exhibits exemplary follow‑up and follow‑through to prompt resolution of identified issues and risks and follow‑up and follow‑through of various documentations. Provides day‑to‑day support to Payroll Services Staff, answers inquiries, and provides research for key campus personnel and end users. The 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. Opens cases with UCPath pertaining to Payroll, Absence Management, Commitment Accounting/GL, Timekeeping, as needed. Business System Support: Analyzes and troubleshoots highly‑complex data errors and problems, designing, testing, and applying advanced functional solutions. Gathers, analyzes, and documents business and/or functional requirements. Develops and maintains functional business requirement documents (BRD) and functional specification documents (FSD) to document requirements, solutions, changes, defects, fixes, projects, enhancements and upgrades. Possesses in‑depth understanding and skill in process and systems requirement documentation standards, such as Use Case modeling, User Story creations and narrative description. Creates business process maps. Executes configuration to support changes and enhancements to our various systems. Develops written functional requirements and reviews system specifications of system modifications. Develops and delivers mechanisms to support implementation of modifications, e.g., forms, reports, queries, schedules, training, etc. Executes unit testing, system integration testing, regression testing, and user acceptance testing to ensure correctness and system integrity. Develops test scripts and creates test scenarios and documents test results. Other duties as assigned. Required Qualifications BA or BS degree in Accounting, Finance, Business, IT or other related field and 3+ years of directly related experience; and/or equivalent combination of experience/training. 3‑5 years of experience in systems analysis. In‑depth knowledge of business intelligence functions, advanced analytics, industry standards and best practices. Advanced knowledge and skill in internal databases, BI applications, tools, and systems. Advanced critical thinking and problem‑solving skills to manage highly‑complex information, assess problems, and develop effective solutions. Advanced organizational and project management skills. Advanced written and verbal communication skills with the ability to convey complex information in a clear, concise manner. Ability to produce and deliver presentations to diverse audiences. Advanced interpersonal skills for effective collaboration with managers, professional and technical staff. Ability to serve as an advanced technical leader providing advice, counsel, and analysis on business intelligence issues. Demonstrated functional and technical knowledge of time and attendance systems, payroll, absence management, and general ledger. Ability to provide sophisticated functional systems analysis within the payroll, absence management, general ledger, and time‑keeping system domains. Critical, systems thinker able to track interconnected processes and data flow and to develop and document functional systems requirements. In‑depth understanding and skill in process and systems requirement documentation standards, such as Use Case modeling, User Story creations and narrative description. Self‑motivated and works independently and as part of a team. Able to learn effectively and meet deadlines. Demonstrated testing and test planning skills. Proficiency in SQL, or similar query tools for ad‑hoc reporting, analysis, and data issue resolution. Detail and quality orientation. Full working knowledge of MS Suite (Access, Word, Excel, PowerPoint, Project, Visio), SmartSheet. Preferred Qualifications Graduate degree MBA/MPA. Knowledge of University accounting, financial, and HR policies. Experience with Oracle Cloud HCM and Finance, PeopleSoft HCM, and UKG time‑keeping modules. PMP Certification. CPP Certification. 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. #J-18808-Ljbffr University of California - San Francisco