SR DATA ANALYST

at  UCPath Center

POSITION SUMMARY

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.

EXPERIENCE

Required Qualifications

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

SKILLS AND ABILITIES

Required Qualifications

• 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 PeopleSoft, 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.

Preferred Qualifications

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

EDUCATION

Required Qualifications

• Bachelor’s degree in related area and / or equivalent experience / training

• 20% Create and maintain reports containing formulas, multiple tables, and tailored functions utilizing PeopleSoft 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.