Job Requisition Number: 23226. UCPath is the University of California?s strategic initiative to provide a standardized and streamlined payroll, benefits, Human Resources (HR) and academic personnel solution for all UC campuses and medical centers, as well as self-service for the university?s 190,000 employees. The UCPath initiative includes the creation of a system-wide shared service center, called the UCPath Center, responsible for the processing of the standardized administrative transactions.
The UCPath Local Reporting Lead is one of six leads reporting to the UCPath Local Project Management Office (PMO), responsible for the overall successful implementation and integration of UCPath?s system and services for UC Berkeley (UCB). This person will lead local efforts on UC Berkeley?s reporting utilizing UCPath provided data and local reporting applications.
This position is responsible for the overall management and coordination of UCB?s Human Resources (HR)/Payroll reports in UCPath. The incumbent will lead local efforts on UC Berkeley?s UCPath Campus Reporting and Business Intelligence (BI). This combines an understanding of a broad set of data analysis applications and software tools, including ad hoc analysis and querying, enterprise reporting, online analytical processing (OLAP), and operational BI with an excellent understanding of HR and payroll business processes, related data, and reporting needs. They will develop and implement a reporting strategy that includes decisions and direction on CalAnswers, PI Portfolio, Berkeley Administrative Initiative Reporting System (BAIRS), and Enterprise Data Warehouse (EDW). The focus will be on HR/Payroll data from the UCPath Data Dissemination Operational Data Store (DDODS), but in the context of all campus enterprise data (financials, student, development, etc). They will also work with the UCPath Archival Lead to ensure appropriate data from our current Human Capital Management (HCM) and Payroll (PPS) systems is stored in a manner able to meet operational and campus future reporting needs. We are looking for an analytical and technically skilled leader to join our team. The incumbent, in addition to leading the business intelligence function for UCPath at Berkeley, will bring together campus business leaders and the BI/Data Warehouse software development team to design and implement campus decisions to support systems deriving their data from UCPath?s DDODS.
This role requires an individual with excellent analytical abilities, comfortable working with large, complex datasets, deep knowledge and experience with data analytics and software tools, able to define easily usable reporting tools and dashboards to meet campus needs, and be able to define and prepare clear specifications and requirements for a technical team to execute. Outstanding business acumen and the ability to work with, and identify the needs of, a diverse campus community is necessary. The successful candidate will be a self-starter comfortable with ambiguity, with strong attention to detail, an ability to work in a fast-paced and ever-changing environment, and driven by a desire to meet the campus information needs and innovate in this space.
This person serves as the bridge between the business reporting needs of the campus and the technical team implementing the solution.
This is a 2-year contract position with the possibility of renewal/extension reporting to the UC Berkeley UCPath Project Manager.
Serves as a strategic project lead responsible for all work necessary to ensure the accurate business operations reporting and analytics within time and cost budgets. The position must first develop a report approach strategy considering what UC Berkeley currently supports and the UC-wide reporting direction and support. They must identify alignment points necessary with the other groups, particularly data conversion, integrations, systems requiring data retrofitting, and testing. They are responsible for the resource and budget plan in support of the UCPath reporting goals and deliverables and the overall project.
They are responsible for:
?Defining the Reporting Project Plan identifying strategy/approach, all necessary deliverables and work (technical and non-technical) necessary to meet those deliverables, documentation, change management, reporting gaps with UCPath deliverables, any data, data sources, or reporting retrofitting required, testing, and cutover. ?Overall reporting project management responsibility. The position provides updates and coordinates efforts with all the local UCPath teams, UC Berkeley campus, and UC-wide project team. ?The development and implementation process of the UCPath reporting deliverables. This position facilitates the collection of campus HR/Payroll information needs, produces and oversees the production of reporting specifications-analytics and User Interface (UI). It provides direction to the DDODS and BI/Data Warehouse technical teams. Coordinates any necessary cross-team work. Works closely with project business analyst(s) and central business representation from HR/Payroll/Campus Shared Services (CSS) -HR/Academic Personnel. ?Facilitating a campus reporting advisory group for gathering campus reporting needs. Organizes the interdepartmental activities ensuring completion of the project/product on schedule and within budget constraints. ?Providing analysis for highly complex project-related issues. ?Interacting with senior internal and external personnel both at UCB and UCPath. ?Monitoring the project from initiation through delivery, including gathering and documenting reporting requirements, necessary data and report analysis, reporting deliverables, change management, campus reporting rollout, and managing risk. ?Overall management responsibility for UCPath reporting. Manages the requirements gathering phase, creates use cases, and specifications for desirable deliverables. Provides direction to the technical conversion team. ?Providing analysis and specifications to the technical team for programs that assist in the transformation of UC Berkeley data that can be automatically cleaned and /or loaded into the UCPath instance. ?Identifying data inconsistencies found in reporting, creating documentation to correct what may involve data cleanup or standardization. ?Ensuring all team members acquire the knowledge and tools to do the job, such as access and familiarity with the UCPath metadata repository or better understanding of the UCB HCM/Payroll existing data structures. ?Providing a testing plan and leading the effort to create testing scripts for reporting deliverables. ?Organizing inter-team and inter-department activities to ensure completion of the project with all teams aware of substantive data changes and potential impacts. ?Documenting all data gaps and acquiring business feedback and resolution or any actions necessary to mitigate. ?Monitoring reporting project risks and issues and ensuring resolution.Knowledge & Skills: ?Requires strong conceptual and planning skills. ?Expert level communication, organization, and project management skills. ?Must be able to work in a collaborative manner to achieve results. ?Ability to consider upstream and downstream process impacts and implications. ?High level understanding of ?end-to-end? business processes & sub-processes. ?Strong data analysis and problem solving skills. ?Extensive knowledge of PeopleSoft HCM and Payroll product and strong understanding of the PeopleSoft data, structures, and interrelationships. ?Proven track record on leading projects and implementing on time and within budget. ?Experience implementing university change efforts. ?Strong analytical and problem solving skills. ?Strong collaboration and interpersonal skills, and the ability to interface with all levels of management and staff. ?Demonstrated understanding of business priorities, challenges, and direction to drive change and desired outcomes. ?Requires ability to assess campus needs for reporting and analytics, and ability to design services to meet those needs. ?Ability to gather clear campus data and reporting requirements and run effective design sessions. ?Ability to give clear direction on business requirements and technical specifications to a technical team. ?Ability to successfully manage and implement projects where team members are not direct reports. ?Must be a strong business and data analyst familiar with data models, Enterprise Risk (ER) diagrams, data validation and profiling, meta-data, and be comfortable using a metadata repository. ?They should have experience using industry standard reporting tools such as Cognos, OBIEE/BI Publisher and/or Business Objects/Crystal Reports, particularly one that utilizes a metadata layer. Advanced knowledge of SQL preferred. ?Experienced in designing dashboards, ad hoc reports, and enterprise operational and management reports.
Education & Training: ?Bachelor?s degree in related area and/or equivalent experience/training. Professional Project Management Professional (PMP) certification preferred. ?10+ years experience involved in implementing and supporting large, complex projects and initiatives having significant organizational impact. ?7+ years experience in business intelligence, analytics. ?7+ years experience with complex data systems and reporting/analytics/business intelligence software.
The University of California was chartered in 1868 and its flagship campus - envisioned as a "City of Learning" - was established at Berkeley, on San Francisco Bay. Today the world's premier public university and a wellspring of innovation, UC Berkeley occupies a 1,232 acre campus with a sylvan 178-acre central core. From this home its academic community makes key contributions to the economic and social well-being of the Bay Area, California, and the nation.