Sr Data Analyst

Job Posting

For UCOP internal applicants, please login to the internal candidate gateway at:
Jobs at UCOP.

Riverside

UCPath

At the University of California (UC), your contributions make a difference. A world leader producing Nobel and Pulitzer prize recipients with over 150 years of groundbreaking research transforming the world. Choose a career where you can leverage your knowledge, skills and aspirations to inspire and support some of the greatest minds in the world, and those who will follow in their footsteps.

Working at the University of California is being part of a unique institution, and a vibrant and diverse community. At the University of California, Office of the President, we propel our mission through impactful work locally, in government centers and systemwide. We are passionate people, serving the greater good.

The University of California, one of the largest and most acclaimed institutions of higher learning in the world, is dedicated to excellence in teaching, research and public service. The University of California Office of the President is the headquarters to the 10 campuses, six academic medical centers and three national laboratories and enrolls premier students from California, the nation and the world.

Learn more about the UC Office of the President.

UCPath is the University of California's shared services center in Riverside, CA. UCPath manages the payroll, benefits, and other human resources transactions for more than 200,000 UC employees working across ten UC campuses, five medical centers, three national labs and more. The staff at UCPath work in a variety of areas including business operations, customer service, quality management, technology, training, human resources and communications.

Learn more about the UCPath Center.

Under general supervision, the Senior Data Analyst will utilize advanced analytics tools and techniques to extract actionable insights from complex metrics, facilitating informed decision-making and process optimization. They will demonstrate a comprehensive understanding of data analytics principles and, along with proficient troubleshooting skills, the Senior Data Analyst showcases excellent attention to detail to ensure precise and reliable data analysis. They will play a crucial role in data management, reporting, analysis, and visualization across various functional areas.

The Senior Data Analyst leverages a blend of technical expertise and sound judgment to effectively utilize skills in driving organizational objectives.

• 20% Create and maintain reports containing formulas, multiple tables, and tailored functions utilizing People Soft Query, SQL, and other UCPath reporting tools.
• 20% Update existing metric dashboards and analyze new data to call out developing trends or anomalies. Develop new dashboards and generate reports tailored to meet customer requirements.
• 10% Engage in collaborative efforts with other departments to identify metric needs or resolve issues as necessary.
• 15% Test and evaluate data information and reconcile any differences from expected results.
• 15% Lead complex analysis efforts and identify meaningful correlations to translate into actionable insights.
• 20% Ensure stakeholders across UCPath and the University of California receive quality, performance, and compliance data promptly through various reporting mediums. Respond to user ad-hoc requests for data, advising and assisting with options for providing relevant information.

• Min 8 years Report development and data analytics or related experience

• Advanced knowledge of Microsoft Office suite.
• Advanced Excel capabilities with expertise in use of modeling, what-if analyses, pivot tables, look‑up functions, advanced formulas, macros, etc.
• Experience utilizing, analyzing, and reporting data from various source systems, such as People Soft, Salesforce, CRM, contact center systems, etc.
• Proficient in creating interactive visualizations, dashboards, and reports using Tableau Desktop and publishing them to Tableau Server for collaborative analysis.
• Proficient in writing and executing SQL queries and scripts using SQL Server Management Studio or SQL Developer for data retrieval, manipulation, and analysis.
• Ability to learn new analytical tools for process mining, analytics, and optimization, enabling efficient analysis and improvement of business processes.
• Strong written, verbal, and interpersonal communication skills, enabling effective interaction with stakeholders and other business users, with a demonstrated ability to communicate complex data concepts clearly and understandably.
• Ability to effectively manage competing and changing priorities to meet deadlines.

• Familiarity with Python programming language for data analysis and automation tasks for advanced analytics and visualization.

• Bachelor's degree in…